Unleash Your Potential with Oracle Training
Looking to supercharge your career in the world of databases and SQL? Dive into the realm of Oracle with our comprehensive ‘Oracle Database 19C: SQL Tuning Workshop’ course. This oracle training program, offered by Info Trek, is your gateway to mastering the art of SQL tuning and performance optimization.
Elevate Your Database Expertise
Designed for Application Developers, Data Warehouse Developers, PL/SQL Developers, and Support Engineers, this 3-day/21-hour course takes you on a journey to harness the full potential of Oracle Database 19C. With a strong foundation in database architecture, SQL, and PL/SQL, you’ll delve into the intricacies of SQL tuning. Learn to identify poorly performing SQL, trace applications through their architecture, and understand how the Query Optimizer makes critical data access decisions.
Practical Learning for Real-World Impact
Through interactive lectures, discussions, practical exercises, and workshops, you’ll not only modify SQL statements for peak performance but also gain valuable insights into optimizing execution plans, understanding access paths, and utilizing optimizer statistics. This course equips you with the skills needed to excel in the fast-paced world of database management, making you an indispensable asset to your organization and boosting your career prospects.
Don’t just keep up with the corporate world; lead the way with Oracle training from Info Trek. Join us on this exciting journey of learning and empowerment, and let Oracle Database 19C: SQL Tuning Workshop be your stepping stone to a brighter and more prosperous future.
Course Details
Course Duration: 5 days/35 hours; Instructor-led/ remote online training
What You Will Learn
This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Audience
- Administrator
- Analyst
- Developer
- Systems Administrator
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
- Retrieve Data using the SQL SELECT Statement
- Restrict and Sort Data
- Customize Output Using Single-Row Functions
- Use Conversion Functions and Conditional Expressions
- Report Aggregated Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Manage Tables by Using DML Statements
- Create Sequences, Synonyms, Indexes, Views, and Schema Objects
- Manage Data by Using Subqueries and Advanced Queries
- Control User Access and Manage Data in Different Time Zones
Outlines
Module 1: Course Overview
- Course Overview – Oracle Database 19c: SQL Workshop
Module 2: Introduction
- Introduction
- Practice 1-1: Introduction
Module 3: Retrieving Data Using the SQL SELECT Statement
- Retrieving Data Using the SQL SELECT Statement
- Practice 2-1: Retrieving Data Using the SQL SELECT Statement
Module 4: Restricting and Sorting Data
- Restricting and Sorting Data
- Practice 3-1: Restricting and Sorting Data
Module 5 : Using Single-Row Functions to Customize Output
- Using Single-Row Functions to Customize Output
- Practice 4-1: Using Single-Row Functions to Customize Output
Module 6 : Using Conversion Functions and Conditional Expressions
- Using Conversion Functions and Conditional Expressions
- Using the COALESCE Function
- Practice 5-1: Using Conversion Functions and Conditional Expressions
Module 7 : Reporting Aggregated Data Using the Group Functions
- Reporting Aggregated Data Using the Group Functions
- Practice 6-1: Reporting Aggregated Data by Using Group Functions
Module 8 : Displaying Data from Multiple Tables Using Joins
- Displaying Data from Multiple Tables Using Joins
- Practice 7-1: Displaying Data from Multiple Tables by Using Joins
Module 9 : Using Subqueries to Solve Queries
- Using Subqueries to Solve Queries
- Practice 8-1: Using Subqueries to Solve Queries
Module 10 : Using Set Operators
- Using Set Operators
- Practice 9-1: Using Set Operators
Module 11 : Managing Tables Using DML Statements
- Managing Tables Using DML Statements in Oracle
- Managing Tables Using DML Statements in MySQL
- Practice 10-1: Managing Tables by Using DML Statements
Module 12 : Introduction to Data Definition Language
- Introduction to Data Definition Language in Oracle
- Introduction to Data Definition Language in MySQL
- Practice 11-1: Introduction to Data Definition Language
Module 13 :Introduction to Data Dictionary Views
- Introduction to Data Dictionary Views
- Practice 12-1: Introduction to Data Dictionary Views
Module 14 : Creating Sequences, Synonyms, and Indexes
- Creating Sequences, Synonyms, and Indexes
- Practice 13-1: Creating Sequences, Synonyms, and Indexes
Module 15 : Creating Views
- Creating Views
- Practice 14-1: Creating Views
Module 16 :Managing Schema Objects
- Managing Schema Objects
- Practice 15-1: Managing Schema Objects
Module 17 : Retrieving Data by Using Subqueries
- Retrieving Data by Using Subqueries
- Practice 16-1: Retrieving Data by Using Subqueries
Module 18 : Manipulating Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Practice 17-1: Manipulating Data by Using Subqueries
Module 19 : Controlling User Access
- Controlling User Access
- Practice 18-1: Controlling User Access
Module 20 : Manipulating Data Using Advanced Queries
- Manipulating Data Using Advanced Queries
- Practice 19-1: Manipulating Data Part 1
- Practice 19-1: Manipulating Data Part 2
Module 21 :Managing Data in Different Time Zones
- Managing Data in Different Time Zones
- Practice 20-1: Managing Data in Different Time Zones
