Corporate Oracle SQL Training Course

1. Oracle Database basic of tables

1. Retrieving data using the SELECT clause
2. Using the WHERE clause in a query
3. Using operators in the WHERE clause
4. Combining WHERE, AND & OR with Operators
5. Query filtering continued BETWEEN, IN and NULL
6. Query filtering conditions & Operator Precedence
7. Ordering, Concatenating, and Aliasing Query Results

1. Single Row Functions (SRF) & Using the Dual Table
2. Using functions in WHERE and character-based SRFs
3. Numeric and Date Data type SRFs
4. Conversion SRFs and Date Formatting
5. Some more Date Functions
6. Concluding SRFs & NULL / NULLIF Functions

1. Grouping functions MIN, MAX, AVG, COUNT, etc.
2. GROUP BY Clause & HAVING clause

3. GROUP BY Clause

1. SELECT within SELECT (Subqueries)
2. Relating Tables Together Using JOINs
3. Joins Continued INNER & OUTER Joins
4. Correlated Subqueries with EXISTS & NOT EXIST Operators
5. SELF JOIN
6. CROSS JOIN, NATURAL JOIN, and the USING CLAUSE
7. EQUIJOIN and NON-EQUIJOINs

1. OVER Clause with PARTITION BY
2. Compute Running Totals with Ordering and Partitioning
3. Unbounded Preceding Order in Over Clause
4. Slicing Windows and Filtering with Analytic Functions
5. Rank, Dense_rank, Lead, and Lag Functions