The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
The delegate will learn and acquire skills as follows:
Retrieving Data Using Correlated Subqueries, In-Line Views and Multi-Column Subqueries
Using the WITH Clause
Inserting and Updating Rows Using Complex Subqueries
Creating Hierarchical Queries
Creating Analytic Queries
Using ROLLUP, CUBE and GROUPING SETS Group By Enhancements
Implementing the GROUPING and GROUPING_ID Functions
Managing Large Data Sets
Inserting Data Conditionally and Unconditionally
Merging Rows in a Table
Creating TIMESTAMP and INTERVAL Datatypes
Using TIMESTAMP, TIMEZONE and INTERVAL Functions and Literals
Using Regular Expressions and Implementing Related Functions
Managing Objects with the Data Dictionary
Managing Schema Objects
Performing Flashback Operations
Creating and Using External Tables
Controlling User Access to Database Objects
Who will the Course Benefit?
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.
To provide the skills needed to use the more advanced features of Oracle SQL.
Together with the Oracle SQL course,
the Oracle SQL Advanced course covers the major topics required for the following Oracle examination:
Oracle Database SQL Fundamentals 1Z0-071
Before taking this exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates should have attended the Oracle SQL course or have a similar level of experience.