Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Limiting Results
- The WHERE clause
- Comparison operators
- The LIKE condition
- The BETWEEN ... AND condition
- The IS NULL condition
- The IN condition
- Boolean operators: AND, OR, and NOT
- Applying various conditions within the WHERE clause
- Operator precedence
- The DISTINCT clause
SQL Functions
- Distinctions between single-row and multi-row functions
- Text, numeric, and date functions
- Explicit and implicit data conversions
- Conversion functions
- Nesting functions
- Testing function performance using the DUAL table
- Retrieving the current date with SYSDATE
- Handling NULL values
Aggregating Data Using Grouping Functions
- Overview of grouping functions
- How grouping functions handle NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Subqueries
- Incorporating subqueries into the SELECT command
- Single-row versus multi-row subqueries
- Operators for single-row subqueries
- Utilizing grouping functions within subqueries
- Operators for multi-row subqueries: IN, ALL, and ANY
- Handling NULL values in subqueries
Set Operators
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
Advanced Joins
- Reviewing join concepts
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
Advanced Use of Subqueries
- Revisiting subquery concepts
- Using subqueries as virtual tables, inline views, and column sources
- Utilizing the WITH clause (Common Table Expressions)
- Combining subqueries with joins
Analytic Functions
- The OVER clause
- The PARTITION BY clause
- The WINDOWING clause
- Functions: RANK, LEAD, LAG, FIRST_VALUE, LAST_VALUE
Retrieving Data from Multiple Tables (if time permits)
- Types of joins
- Using NATURAL JOIN
- Table aliases
- Joining tables via the WHERE clause
- INNER JOIN
- Outer Joins: LEFT, RIGHT, and FULL OUTER JOIN
- Cartesian products
Aggregate Functions (if time permits)
- Reviewing GROUP BY and the HAVING clause
- GROUPING SETS and ROLLUP
- GROUPING SETS and CUBE
Requirements
It is recommended that attendees have completed the 'Oracle SQL for Beginners' training course.
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
I found his methods very informative
