AUDIENCE:   The course has been designed for Database Administrators, System Analysts, Application Developers and IT/Technical Staff. PREREQUISITES:   Knowledge of Oracle SQL and SQL*Plus, or equivalent taining. Our Oracle SQL part 1 and 2 course should provide an ideal pre-requisite. DURATION:   1 day. Hands on. OBJECTIVES:   This Course is similar to SQL Part Two for Experienced Users, with slightly different topics. On completion of the course delegates will be able to: Use advanced techniques to retrieve data using ROLLUP, CUBE, Set operators, correlated subqueries, and hierarchical queries Write SQL scripts which use SQL to generate SQL Use SQL*Plus to format reports COURSE CONTENT:   Using Group Functions with CUBE or ROLLUP Operations Using ROLLUP as an extension to the group by clause to produce subtotal values Using CUBE as an extension the group by clause to produce subtotal values Using the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE Operators Hierarchical Retrieval Discussing the benefits of the hierarchical query Ordering the rows retrieved by a query in a hierarchical manner Formatting hierarchical data so that it is easy to read Excluding branches from the tree structure Writing Correlated Subqueries Describing the types of problems that can be solved with a correlated subquery Describing a correlated subquery Writing correlated subqueries Using the EXISTS and NOT EXISTS Operators Updating and deleting rows Using correlated subqueries Using Set Operators Describing the set operators Obeying the set operators rules and guidelines Using a Set Operator to Combine Multiple Queries into a Single Subquery Controlling the Order of Rows Returned Writing Scripts to Generate Scripts Describing the types of problems that are solved by writing SQL scripts that generate other SQL scripts Writing and executing a script that generates a script of drop table commands Writing and executing a script that generates a script of insert into commands