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
Restricting 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
- Combining multiple conditions in 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 type conversion
- Conversion functions
- Nesting functions
- Testing function behaviour using the DUAL table
- Retrieving the current date with the SYSDATE function
- Handling NULL values
Aggregating Data Using Grouping Functions
- Overview of grouping functions
- How grouping functions treat NULL values
- Creating data groups with the GROUP BY clause
- Grouping across multiple columns
- Filtering grouped results with the HAVING clause
Subqueries
- Embedding subqueries within the SELECT statement
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Using grouping within subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
- How NULL values are handled in subqueries
Set Operators
- The UNION operator
- The UNION ALL operator
- The INTERSECT operator
- The MINUS operator
Advanced Use of Joins
- Reviewing joins
- Combining inner and outer joins
- Partitioned outer joins
- Hierarchical queries
Advanced Use of Subqueries
- Reviewing subqueries
- Using subqueries as virtual tables, inline views, and columns
- The WITH clause
- Combining subqueries 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 (Time Permitting)
- Types of joins
- Using NATURAL JOIN
- Table aliases
- Joins in the WHERE clause
- INNER JOIN
- LEFT, RIGHT, and FULL OUTER JOIN
- Cartesian product
Advanced Aggregate Functions (Time Permitting)
- Reviewing the GROUP BY function and HAVING clause
- GROUPING and ROLLUP
- GROUPING and CUBE
Requirements
It is recommended that attendees have completed 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
