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
Filtering Result Sets
- Utilizing the WHERE clause
- Application of comparison operators
- Using the LIKE condition for pattern matching
- Range filtering with the BETWEEN ... AND condition
- Identifying null values with the IS NULL condition
- Filtering via the IN condition
- Logical operators: AND, OR, and NOT
- Combining multiple conditions within the WHERE clause
- Understanding operator precedence
- Eliminating duplicates with the DISTINCT clause
Utilizing SQL Functions
- Distinguishing between single-row and multi-row functions
- Working with text, numeric, and date functions
- Understanding explicit and implicit data conversion
- Applying conversion functions
- Nesting functions for complex operations
- Testing function performance using the DUAL table
- Retrieving the current system date using SYSDATE
- Managing NULL values effectively
Aggregating Data with Grouping Functions
- Overview of grouping functions
- How grouping functions handle NULL values
- Organizing data into groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering aggregated results with the HAVING clause
Implementing Subqueries
- Incorporating subqueries into the SELECT statement
- Differentiating between single-row and multi-row subqueries
- Operators used with single-line subqueries
- Applying grouping functions within subqueries
- Operators for multi-line subqueries: IN, ALL, and ANY
- Handling NULL values within subqueries
Set Operators
- The UNION operator
- The UNION ALL operator
- The INTERSECT operator
- The MINUS operator
Advanced Join Techniques
- Review of fundamental joins
- Combining Inner and Outer joins
- Implementing Partitioned Outer Joins
- Constructing hierarchical queries
Advanced Subquery Applications
- Reviewing subquery fundamentals
- Utilizing subqueries as virtual tables (inline views) and column expressions
- Employing the WITH clause (Common Table Expressions)
- Integrating subqueries with joins
Analytics Functions
- Understanding the OVER clause
- Defining partitions with the Partition Clause
- Applying the Windowing Clause
- Utilizing ranking and offset functions: RANK, LEAD, LAG, FIRST, and LAST
Retrieving Data from Multiple Tables (Time Permitting)
- Overview of join types
- Utilizing NATURAL JOIN
- Assigning and using table aliases
- Performing joins within the WHERE clause
- Executing INNER JOINs
- Executing outer joins: LEFT, RIGHT, and FULL OUTER JOIN
- Understanding the Cartesian product
Advanced Aggregate Functions (Time Permitting)
- Reviewing the GROUP BY and HAVING clauses
- Utilizing ROLLUP for hierarchical subtotals
- Utilizing CUBE for multi-dimensional aggregation
Requirements
It is recommended that attendees have previously completed the "Oracle SQL for Beginners" training course.
14 Hours
Testimonials (3)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
I found his methods very informative
