The Complete Oracle SQL Certification Course

Course Curriculum

Chapter 1: Database Basics

Lecture 1: Oracle Database Introduction & Basics of Tables

Lecture 2: Creating the Workspace in Oracle

Lecture 3: IMPORTANT: Prepare the Sample Data

Lecture 4: Dedicated TA Support

Lecture 5: Join our Online Community (Discord)

Lecture 6: How to Proceed in This Course

Chapter 2: Single Table Queries (Exercises & Solutions in the Lectures)

Lecture 1: Oracle Exams and Certification Information

Lecture 2: Retrieving Data Using the SELECT Clause

Lecture 3: Using the WHERE Clause in a Query

Lecture 4: Important Information from Instructor

Lecture 5: Using Operators in the WHERE Clause

Lecture 6: Some Inspiration

Lecture 7: Combining WHERE, AND & OR with Operators

Lecture 8: Query Filtering Continued BETWEEN, IN and NULL

Lecture 9: What Will Make you Grow as a Software Developer

Lecture 10: Query Filtering Conditions & Operator Precedence

Lecture 11: Ordering, Concatenating And Aliasing Query Results

Lecture 12: Assignment 1: Practice with Single Table Queries

Chapter 3: Single Row Functions (Exercises and Solutions In the Lectures)

Lecture 1: Single Row Functions (SRF) & Using The Dual Table

Lecture 2: Using Functions in WHERE And Character Based SRFs

Lecture 3: Numeric and Date Data type SRFs

Lecture 4: Conversion SRFs and Date Formatting

Lecture 5: Some More Date Functions

Lecture 6: Concluding SRFs & NULL / NULLIF Functions

Lecture 7: Assignment 2: Practice with Single Row Functions

Chapter 4: Grouping Functions (Exercises and Solutions In the Lectures)

Lecture 1: Grouping Functions MIN, MAX, AVG, COUNT etc.

Lecture 2: GROUP BY Clause & HAVING Clause

Lecture 3: More Practice With The GROUP BY Clause

Chapter 5: Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)

Lecture 1: SELECT within SELECT (Subqueries)

Lecture 2: Relating Tables Together Using JOINs

Lecture 3: Joins Continued INNER & OUTER Joins

Lecture 4: Career Advice

Lecture 5: Correlated Subqueries with EXISTS & NOT EXIST operators

Lecture 6: SELF JOIN

Lecture 7: CROSS JOIN, NATURAL JOIN and the USING CLAUSE

Lecture 8: EQUIJOIN and NON-EQUIJOINs

Lecture 9: CASE Statements

Chapter 6: Analytical Functions using OVER and PARTITION with ORDER BY

Lecture 1: OVER Clause with PARTITION BY

Lecture 2: Compute Running Totals with Ordering and Partitioning

Lecture 3: Unbounded Preceding Order in Over Clause

Lecture 4: Slicing Windows and Filtering with Analytic Functions

Lecture 5: Rank, Dense_rank, Lead, and Lag Functions

Lecture 6: Assignment: Application of Window Functions and SELF JOIN

Chapter 7: Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)

Lecture 1: Creating Your Own Tables & Design Considerations

Lecture 2: Inserting Data Into Our Table

Lecture 3: Create Table With a Primary Key Constraint

Lecture 4: INSERT ALL for Multi-table & Conditional Inserts

Lecture 5: Using ALTER to modify the table structure

Lecture 6: Create Table with SELECT + UPDATE Data

Lecture 7: MERGE Statement in Oracle

Lecture 8: Primary and Foreign Keys

Lecture 9: Sequence Statements in Oracle

Lecture 10: DELETE, TRUNCATE, and DROP Commands

Lecture 11: Working With Database Indexes

Lecture 12: System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

Lecture 13: Views and Other Objects and Commands (Newly Added)

Lecture 14: SQL could be tricky, check this out!

Lecture 15: Granting and Revoking Privileges

Chapter 8: ADDITIONAL TOPICS + REVIEW for EXAM 170-071

Lecture 1: OFFSET and FETCH

Lecture 2: ERD Diagrams

Lecture 3: Commit, Rollback, and Savepoint

Lecture 4: Large Objects and Interval Data Types

Lecture 5: Using Cascade Constraints and On Delete Cascade

Lecture 6: UNUSED Columns

Lecture 7: External Tables

Lecture 8: SQL Plus and Substitution Variables

Chapter 9: Exam Question Walkthrough Videos + 2 Exams

Lecture 1: QA 1- DML, DDL, and Transaction Control

Lecture 2: QA 2- Fetch and Substitution Variables

Lecture 3: QA 3 – Conversion Functions, TO_CHAR, NVL, and TO_DATE

Chapter 10: APPENDIX – Installing Oracle on Windows

Lecture 1: Install Oracle Database 19c in Windows

Lecture 2: Install Oracle SQL Developer in Windows

Chapter 11: Course Extras!

Lecture 1: Bonus Lecture