Oracle SQL Advanced

By the end of this course, the delegate will be able to use SQL Developer as an alternative to SQL*Plus, manage schema objects with data dictionary views, write multiple column subqueries, manage large data sets with subqueries and construct hierarchical queries. Delegates will also be able to use the ROLLUP, CUBE and GROUPING SETS group by extensions, manage data in different time zones, use regular expression functions and control user access to database objects Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Course content

• SQLDeveloper
• Hierarchical Queries
• Enhanced Grouping Extensions and Functions
• TIMESTAMP,TIMEZONEandINTERVALDatatypes
• TIMESTAMPandINTERVALFunctions and Literals
• POSIXCompliant Regular Expression Notation
• Regular Expression Functions
• Enhanced Subquery Functions
• Multitable Insert Statements
• Merge Rows in a Table
• External Tables
• Flashback Operations
• Control User Access