Class Units
-
Welcome to the course!
-
Unit 1 - Module 1 - Introduction to SQL & Relational Databases (5:50)
-
Unit 2: Table Management. Learn how tables are structured so you can confidently work with real datasets. (9:53)
-
Unit 3: Selecting and Retrieving Data. Master SELECT statements and start pulling meaningful data immediately. (10:52)
-
Unit 4: Filtering Data. Use WHERE, logical operators, and conditions to extract exactly the data you need. (8:50)
-
Unit 5 - Module 2 - Intermediate SQL: Creating Calculated Fields and Using Aggregate Functions. Perform calculations and summaries used in analytics and reporting. (10:49)
-
Unit 6: Using SQL Clauses. Use GROUP BY, HAVING, and ORDER BY to analyze and organize data like a pro. (13:39)
-
Unit 7: Creating Table Joins. Combine data from multiple tables — a must-have skill for real-world SQL jobs. (22:54)
-
Unit 8: Creating Subqueries. Solve complex business questions using nested queries. (13:42)
-
Unit 9 - Module 3 - Advanced SQL: Creating Advanced Subqueries. Handle sophisticated data challenges with confidence. (12:45)
-
Unit 10: Creating Advanced Joins. Master complex joins used in enterprise databases. (15:52)
-
Unit 11: Creating Union Queries. Merge datasets and produce cleaner, more powerful results. (11:10)
-
Unit 12: Transaction Processing, Stored Procedures, Triggers. Understand how SQL supports real applications, automation, and data integrity. (11:57)
-
Course Completion: You’re Job-Ready!
