SQL for Data Engineers Designing and Building Data Pipelines
Advanced DDL: ALTER, DROP, and RENAME
SQL for Data Engineers Designing and Building Data Pipelines
0%
Completed
Section 1 – Introduction to SQL and DDL Basics
Understanding SQL Intuition and DDL Basics
Video - 00:8:17 mins
Authorization and DDL Commands
Video - 00:6:16 mins
Advanced DDL: ALTER, DROP, and RENAME
Video - 00:8:34 mins
Section 2 – Deep Dive into DDL and Constraints
Comprehensive DDL Concepts
Video - 00:8:7 mins
DDL Commands: Read, Insert, and Update Authorization
Video - 00:4:56 mins
Primary Key Constraints and Auto-Increment
Video - 00:5:10 mins
Section 3 – Data Manipulation and Table Alterations
Table and Column Alterations
Video - 00:5:27 mins
Data Manipulation Language (DML) Basics
Video - 00:4:45 mins
SELECT Command: Advantages, Limitations, and Challenges
Reading
Section 4 – DML Commands: INSERT, UPDATE, DELETE
INSERT Command: Pros and Cons
Video - 00:6:13 mins
UPDATE and DELETE Commands: Pros and Cons
Video - 00:7:19 mins
Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT
Video - 00:6:27 mins
Section 5 – Data Control Language and Constraints
DCL and Domain Constraints
Video - 00:6:44 mins
Check Constraints and Table Constraints
Video - 00:8:25 mins
Primary and Foreign Key Constraints
Video - 00:8:32 mins
Section 6 – Advanced SQL Operations
Foreign Key vs. Primary Key and TRUNCATE vs. DELETE
Video - 00:7:21 mins
SQL Procedures and Set Operations
Video - 00:6:54 mins
Group By, Where, Fetch, Limit, and Distinct
Video - 00:7:46 mins
Section 7 – Advanced Filtering and Examples
HAVING vs. WHERE with Examples
Video - 00:6:7 mins
Match and Offset Functions
Video - 00:6:47 mins
MIN, MAX, IN, and NOT IN Operations
Video - 00:6:33 mins
Section 8 – Logical Operations and Grouping
AND, OR, NOT Operations
Video - 00:5:21 mins
Grouping Sets and LIKE Operation
Video - 00:6:35 mins
Advanced Grouping and Join Operations
Video - 00:7:8 mins
Section 9 – Limit and Offset Operations
LIMIT and OFFSET Clauses
Video - 00:8:49 mins
IN, NOT IN, and NULL Operations
Video - 00:7:41 mins
Join Operations: LEFT and RIGHT
Video - 00:5:48 mins
Section 10 – Advanced Join Techniques
Inner and Outer Joins
Video - 00:6:43 mins
Full Outer and Cross Joins
Video - 00:5:43 mins
Hands-On: RANK and ROW_NUMBER
Video - 00:6:30 mins
Section 11 – Views and Triggers
Dense Rank: Advantages and Limitations
Video - 00:7:10 mins
SQL Views: Creation, Updating, and Dropping
Video - 00:5:45 mins
SQL Triggers: Row Level vs. Statement Level
Video - 00:6:21 mins
Section 12 – Subqueries and Optimization
Deleting Triggers and Complex Subqueries
Video - 00:6:58 mins
Subqueries and Query Optimization
Video - 00:6:58 mins
Comparison Operations and Introduction to Stored Procedures
Video - 00:6:25 mins
Section13 – Stored Procedures and Indexing
Stored Procedures with Parameters and Indexing in SQL
Video - 00:5:54 mins
More
Announcements
Reviews
Course Info
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway
