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 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 conversions
- Conversion functions
- Nested functions
- Testing function performance using the DUAL table
- Using the SYSDATE function to retrieve the current date
- Handling NULL values
Aggregating Data Using Grouping Functions
- Grouping functions
- How grouping functions handle NULL values
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Limiting grouped function results using the HAVING clause
Subqueries
- Placing subqueries within the SELECT command
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Using grouping functions in subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
- Handling NULL values in subqueries
Set Operators
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
Advanced Usage of Joins
- Reviewing joins
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
Advanced Usage of Subqueries
- Reviewing subqueries
- Using subqueries as virtual tables/inline views and columns
- Using the WITH clause
- Combining subqueries with joins
Analytic Functions
- The OVER clause
- The PARTITION BY clause
- The WINDOWING clause
- Rank, LAG, LEAD, FIRST, and LAST functions
Retrieving Data from Multiple Tables (if time permits)
- Types of joins
- Using NATURAL JOIN
- Table aliases
- Joins in the WHERE clause
- INNER JOIN
- OUTER JOINs (LEFT, RIGHT, FULL)
- Cartesian products
Aggregate Functions (if time permits)
- Reviewing GROUP BY and HAVING clauses
- GROUPING SETS and ROLLUP
- GROUPING SETS and CUBE
Requirements
It is recommended that participants have previously attended the 'Oracle SQL for Beginners' training course.
14 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
I found his methods very informative
