Course Outline
Limiting Results
- The WHERE Clause
- Comparison Operators
- LIKE Condition
- BETWEEN ... AND Prerequisite
- IS NULL Condition
- IN Condition
- Boolean Operators: AND, OR, and NOT
- Multiple Conditions in 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
- Nested Functions
- Function Performance - Dual Table
- Current Date Function: SYSDATE
- Handling NULL Values
Aggregating Data Using Grouping Functions
- Grouping Functions Overview
- Treatment of NULL Values in Grouping Functions
- Creating Data Groups - GROUP BY Clause
- Grouping Multiple Columns
- Limiting Grouped Function Results - HAVING Clause
Subqueries
- Placing Subqueries in the SELECT Statement
- Single-Row and Multi-Row Subqueries
- Single-Row Subquery Operators
- Grouping in Subqueries
- Multi-Row Subquery Operators: IN, ALL, ANY
- Treatment of NULL Values in Subqueries
Collective Operators
- UNION Operator
- UNION ALL Operator
- INTERSECT Operator
- MINUS Operator
Further Usage of Joins
- Revisiting Joins
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
Further Usage of Subqueries
- Revisiting Subqueries
- Using Subqueries as Virtual Tables/Inline Views and Columns
- Using the WITH Clause
- Combining Subqueries and Joins
Analytic Functions
- OVER Clause
- Partition Clause
- Windowing Clause
- Rank, Lead, Lag, First, 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 OUTER JOIN
- Cartesian Product
Aggregate Functions (if time permits)
- Revisiting GROUP BY Function and HAVING Clause
- Grouping with ROLLUP
- Grouping with CUBE
Requirements
Recommended participation in the "Oracle SQL for Beginners" training course for government personnel.
Testimonials (5)
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
Liviu
Course - Oracle SQL LP - Fundamentals
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
