Course Content
Section 1 – Introduction to SQL and DDL Basics
0/3
Understanding SQL Intuition and DDL Basics
08:17
Authorization and DDL Commands
06:16
Advanced DDL: ALTER, DROP, and RENAME
08:34
Section 2 – Deep Dive into DDL and Constraints
0/3
Comprehensive DDL Concepts
08:07
DDL Commands: Read, Insert, and Update Authorization
04:56
Primary Key Constraints and Auto-Increment
05:10
Section 3 – Data Manipulation and Table Alterations
0/3
Table and Column Alterations
05:27
Data Manipulation Language (DML) Basics
04:45
SELECT Command: Advantages, Limitations, and Challenges
Section 4 – DML Commands: INSERT, UPDATE, DELETE
0/3
INSERT Command: Pros and Cons
06:13
UPDATE and DELETE Commands: Pros and Cons
07:19
Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT
06:27
Section 5 – Data Control Language and Constraints
0/3
DCL and Domain Constraints
06:44
Check Constraints and Table Constraints
08:25
Primary and Foreign Key Constraints
08:32
Section 6 – Advanced SQL Operations
0/3
Foreign Key vs. Primary Key and TRUNCATE vs. DELETE
07:21
SQL Procedures and Set Operations
06:54
Group By, Where, Fetch, Limit, and Distinct
07:46
Section 7 – Advanced Filtering and Examples
0/3
HAVING vs. WHERE with Examples
06:07
Match and Offset Functions
06:47
MIN, MAX, IN, and NOT IN Operations
06:33
Section 8 – Logical Operations and Grouping
0/3
AND, OR, NOT Operations
05:21
Grouping Sets and LIKE Operation
06:35
Advanced Grouping and Join Operations
07:08
Section 9 – Limit and Offset Operations
0/3
LIMIT and OFFSET Clauses
08:49
IN, NOT IN, and NULL Operations
07:41
Join Operations: LEFT and RIGHT
05:48
Section 10 – Advanced Join Techniques
0/3
Inner and Outer Joins
06:43
Full Outer and Cross Joins
05:43
Hands-On: RANK and ROW_NUMBER
06:30
Section 11 – Views and Triggers
0/3
Dense Rank: Advantages and Limitations
07:10
SQL Views: Creation, Updating, and Dropping
05:45
SQL Triggers: Row Level vs. Statement Level
06:21
Section 12 – Subqueries and Optimization
0/3
Deleting Triggers and Complex Subqueries
06:58
Subqueries and Query Optimization
06:58
Comparison Operations and Introduction to Stored Procedures
06:25
Section13 – Stored Procedures and Indexing
0/1
Stored Procedures with Parameters and Indexing in SQL
05:54
SQL for Data Engineers Designing and Building Data Pipelines
Previous
Next
0% Complete