Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete Oracle SQL Certification Course
Join our Discord Server
Join our Online Community (Discord)
Database Basics
Lesson 1 - Course Overview (5:54)
Lesson 2 - Oracle Database Overview & Basics of Tables (19:42)
Lesson 3 - Setting up The SQL Development Environment (6:33)
IMPORTANT: Prepare the Course Data (3:42)
Single Table Queries
Lesson 4 - Retrieving Data Using SELECT Clause (14:42)
Lesson 5 - Using the WHERE Clause In a SQL Query (19:35)
Important Notes From Instructor (3:35)
Lesson 6 - Using Operators in the WHERE Clause (19:45)
Lesson 7 - Combining WHERE, AND & OR with Operators (19:14)
Lesson 8 - Query Filtering Continued BETWEEN, IN and NULL (19:58)
Lesson 9 - Query Filtering Conditions & Operator Precedence (19:54)
Lesson 10 - Ordering, Concatenating & Aliasing Query Results (19:58)
ASSIGNMENT 1: Practice with Single Table Queries
Single Row Functions (SRFs)
Lesson 11 - Single Row Functions (SRF) & Using The Dual Table (19:36)
Lesson 12 - Using Functions in WHERE And Character Based SRFs (19:58)
Lesson 13 - Numeric and Date Data type SRFs (19:52)
Lesson 14 - Conversion SRFs & Date Formatting (19:37)
Lesson 15 - Concluding SRFs & NULL / NULLIF Functions (16:15)
Assignment 2: Practice with Single Row Functions
Grouping Functions
Lesson 16 - Grouping Functions MIN, MAX, AVG, COUNT etc. (19:42)
Lesson 17 - GROUP BY Clause & HAVING Clause (19:57)
Lesson 18 - More Practice With The GROUP BY Clause (12:10)
Multi-Table Queries and Joins
Lesson 19 - SELECT within SELECT (Subqueries) (23:55)
Lesson 20 - Relating Tables Together Using JOINs (19:19)
Lesson 21 - Joins Continued INNER & OUTER Joins (21:29)
Lesson 22 - More Joins With Correlated Subqueries (21:13)
SELF JOIN (11:10)
CROSS JOIN, NATURAL JOIN and the USING CLAUSE (8:43)
EQUIJOIN and NON-EQUIJOINs (9:38)
Lesson 23- CASE Statements (8:40)
Analytical Functions using OVER and PARTITION with ORDER BY
OVER Clause with PARTITION BY (18:31)
Compute Running Totals with Ordering and Partitioning (18:47)
Unbounded Preceding Order in Over Clause (8:41)
Sliding Windows and Filtering with Analytic Functions (5:59)
Rank, Dense_rank, Lead, and Lag Functions (15:05)
Creating, Altering, and Updating Tables Using SQL
Lesson 24 - Creating Your Own Tables & Design Considerations (20:59)
Lesson 25 - Inserting Data Into Our Table (19:39)
Lesson 26 - Create Table With a Primary Key Constraint (21:34)
Lesson 27 - Using ALTER to modify the table structure (Newly Added) (16:32)
Lesson 28 - Create Table with SELECT + UPDATE Data (Newly Added) (19:55)
Lecture 29 - MERGE Statement in Oracle (16:57)
Primary And Foreign Keys
Lecture 30 - Sequence Statements (12:27)
Lesson 31 - Deleting, Dropping and Truncating (18:48)
Lesson 32 - Working With Database Indexes (Newly Added) (14:19)
Lesson 33 - System Tables, Pseudo Columns & Deleting Duplicates (Newly Added) (24:05)
Lecture 34 - Views and Other Objects and Commands (Newly Added) (23:33)
Lecture 35 - Granting and Revoking Privileges (15:08)
ADDITIONAL TOPICS + REVIEW for EXAM 170-071
OFFSET and FETCH (9:55)
ERD Diagrams (18:34)
Commit, Rollback, and Savepoint (14:36)
Large Objects and Interval Data Types (17:32)
Using Cascade Constraints and On Delete Constraints (17:56)
UNUSED Columns (7:36)
External Tables (14:59)
SQL Plus and Substitution Variables (32:41)
Exam Question Walkthrough Videos
QA 1- DML, DDL, and Transaction Control (24:19)
QA 2- Fetch and Substitution Variables (25:13)
QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL (28:50)
APPENDIX- Installing Oracle on Windows
Installing Oracle Database 19c in Windows (9:35)
Installing Oracle SQL Developer in Windows (13:27)
Lesson 20 - Relating Tables Together Using JOINs
Download
Code for Relating Tables together using JOINs .txt
Complete and Continue