Oracle SQL Advanced (STA_OSA)

Global Knowledge Network Netherlands bv

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

Prijs
vanaf € 1.255
Niveau
Niet opgegeven
Soort
Opleiding
Thema
Automatisering en ICT

Meer informatie en aanmelden bij Global Knowledge Network Netherlands bv

Beschrijving

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:

Startmomenten

Start Einde Plaats Prijs
3 december 2026 4 december 2026 Online € 1.255
10 december 2026 11 december 2026 Online € 1.255
7 januari 2027 8 januari 2027 Online € 1.255
11 februari 2027 12 februari 2027 Online € 1.255
11 maart 2027 12 maart 2027 Online € 1.255
8 april 2027 9 april 2027 Online € 1.255