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
- LIKE condition
- BETWEEN ... AND condition
- IS NULL condition
- IN condition
- Boolean operators: AND, OR, and NOT
- Multiple conditions within the WHERE clause
- Operator precedence
- DISTINCT clause
SQL functions
- Differences between single-row and multi-row functions
- Text, numeric, and date functions
- Explicit and implicit conversion
- Conversion functions
- Nesting functions
- Testing function performance using the DUAL table
- Retrieving the current date using SYSDATE
- Handling NULL values
Aggregating data using grouping functions
- Grouping functions
- How grouping functions handle NULL values
- Creating groups of data - the GROUP BY clause
- Grouping by multiple columns
- Limiting grouped results - the HAVING clause
Subqueries
- Placing subqueries in the SELECT statement
- Single-line and multi-line subqueries
- Operators for single-line subqueries
- Using grouping functions within subqueries
- Operators for multi-line subqueries: IN, ALL, ANY
- Handling NULL values in subqueries
Set operators
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
Advanced Usage of Joins
- Review of Joins
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
Advanced Usage of Sub-queries
- Review of sub-queries
- Using sub-queries as virtual tables (inline views) and columns
- Using the WITH clause
- Combining sub-queries with joins
Analytics functions
- OVER clause
- PARTITION BY clause
- 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 in the WHERE clause
- INNER JOIN
- Left, Right, and Full Outer Joins
- Cartesian product
Aggregate Functions (if time permits)
- Review of GROUP BY and HAVING clauses
- GROUPING and ROLLUP
- GROUPING and CUBE
Requirements
Attendance at the "Oracle SQL for Beginners" training course is recommended.
14 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
I found his methods very informative
