Oracle SQL Advanced Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais. The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Addit Oracle SQL Advanced Training Course Course Contents - DAY 1 Course Introduction Administration and Course Materials Course Structure and Agenda Delegate and Trainer Introductions Session 1: RETRIEVE DATA USING SUBQUERIES Correlated Subqueries In-Line Views The Exists Operator The WITH Clause Multi-Column Subqueries Insert and Update Using a Query Correlated Update and Delete Session 2: HIERARCHICAL QUERIES Hierarchical data The START WITH and CONNECT BY clauses The LEVEL pseudo-column Sequencing the output Eliminating nodes and branches Session 3: ENHANCED GROUPING FEATURES Review of basic grouping concepts The ROLLUP and CUBE extensions The GROUPING SETS extension Using the GROUPING and GROUPING_ID functions Session 4: ANALYTIC
