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
- Various conditions applicable within the WHERE clause
- Operator precedence
- The DISTINCT clause
SQL Functions
- Differences between single-row and multi-row functions
- Text, numeric, and date functions
- Explicit and implicit data conversion
- 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 with the GROUP BY clause
- Grouping by multiple columns
- Filtering grouped results with the HAVING clause
Subqueries
- Incorporating subqueries within the SELECT statement
- Single-row versus multi-row subqueries
- Operators used with single-row subqueries
- Applying 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 Joins
- Review of Joins
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
Advanced Use of Sub-Queries
- Reviewing sub-queries
- Using sub-queries as virtual tables, inline views, or columns
- Utilizing the WITH clause
- Combining sub-queries with joins
Analytic Functions
- The OVER clause
- The PARTITION BY clause
- The Windowing Clause
- Rank, LEAD, LAG, FIRST, and LAST functions
Retrieving Data from Multiple Tables (if time permits)
- Types of joins
- Using NATURAL JOIN
- Table aliases
- Joins specified in the WHERE clause
- INNER JOIN
- Outer Joins: LEFT, RIGHT, and FULL OUTER JOIN
- Cartesian product
Aggregate Functions (if time permits)
- Reviewing the GROUP BY function and HAVING clause
- GROUP BY with ROLLUP
- GROUP BY with CUBE
Requirements
It is recommended to have 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
