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
- Understanding the WHERE clause
- Utilizing comparison operators
- Employing the LIKE condition
- Using the BETWEEN ... AND range operator
- Checking for null values with the IS NULL condition
- Using the IN condition
- Applying Boolean operators: AND, OR, and NOT
- Combining multiple conditions within the WHERE clause
- Understanding operator precedence
- Using the DISTINCT clause to eliminate duplicates
SQL Functions
- Distinguishing between single-row and multi-row functions
- Text, numeric, and date features
- Understanding explicit and implicit conversion
- Utilizing conversion functions
- Nesting functions
- Testing function performance using the DUAL table
- Retrieving the current date with SYSDATE
- Managing NULL values effectively
Aggregating Data with Grouping Functions
- Overview of grouping functions
- How grouping functions handle NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Restricting grouped function results with the HAVING clause
Subqueries
- Placing subqueries within the SELECT command
- Differentiating between single-row and multi-row subqueries
- Operators used in single-line subqueries
- Using grouping features within subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
- Handling NULL values in subqueries
Set Operators
- The UNION operator
- The UNION ALL operator
- The INTERSECT operator
- The MINUS operator
Advanced Usage of Joins
- Reviewing join concepts
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Executing Hierarchical Queries
Advanced Usage of Sub-Queries
- Reviewing sub-query concepts
- Using sub-queries as virtual tables/inline views and column expressions
- Utilizing the WITH clause (Common Table Expressions)
- Combining sub-queries with joins
Analytics Functions
- Understanding the OVER clause
- Using the Partition Clause
- Using the Windowing Clause
- Ranking functions: RANK, LEAD, LAG, FIRST, LAST
Retrieving Data from Multiple Tables (if time permits)
- Types of joins
- Using NATURAL JOIN
- Applying table aliases
- Defining joins in the WHERE clause
- Using INNER JOIN
- Using Outer Joins: LEFT, RIGHT, FULL OUTER JOIN
- Understanding the Cartesian product
Aggregate Functions (if time permits)
- Reviewing GROUP BY and HAVING clauses
- Using GROUPING SETS with ROLLUP
- Using GROUPING SETS with CUBE
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
