DatabaseBeginner to Advanced • 12 Hours • 28 Chapters
Dashboard Unlocked ✓SQL
SQL Tutorial covering SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, Aggregates (COUNT, SUM, AVG, MIN, MAX), Joins (INNER, LEFT, RIGHT, FULL), GROUP BY, HAVING, Subqueries, CREATE TABLE, and Constraints with interactive coding challenges.
Overall Course Progress0 / 28 Chapters (0%)
📚Course Chapters & Curriculum
Module 1: SQL Basics & Data Querying5 Lessons
1
SQL Intro & Relational Databases
+50 XP • Interactive IDENext Chapter ▶Open →
🔒
SQL SELECT Statement & Column Selection
+50 XP • Interactive IDE🔒 Locked
🔒
SQL SELECT DISTINCT & Unique Values
+50 XP • Interactive IDE🔒 Locked
🔒
SQL WHERE Clause & Filtering Records
+50 XP • Interactive IDE🔒 Locked
🔒
SQL ORDER BY (ASC / DESC Sorting)
+50 XP • Interactive IDE🔒 Locked
Module 2: Logical Operators & Aggregation5 Lessons
🔒
SQL AND, OR & NOT Operators
+50 XP • Interactive IDE🔒 Locked
🔒
SQL INSERT INTO (Adding New Records)
+50 XP • Interactive IDE🔒 Locked
🔒
SQL NULL Values (IS NULL & IS NOT NULL)
+50 XP • Interactive IDE🔒 Locked
🔒
SQL UPDATE Statement & Modifying Data
+50 XP • Interactive IDE🔒 Locked
🔒
SQL DELETE Statement & Truncation
+50 XP • Interactive IDE🔒 Locked
Module 3: Functions, Limits & Pattern Matching5 Lessons
🔒
SQL SELECT TOP / LIMIT / FETCH FIRST
+50 XP • Interactive IDE🔒 Locked
🔒
SQL MIN() & MAX() Aggregate Functions
+50 XP • Interactive IDE🔒 Locked
🔒
SQL COUNT(), AVG() & SUM() Functions
+50 XP • Interactive IDE🔒 Locked
🔒
SQL LIKE Operator & Wildcards (%)
+50 XP • Interactive IDE🔒 Locked
🔒
SQL IN Operator & Subquery Matching
+50 XP • Interactive IDE🔒 Locked
Module 4: Ranges, Aliases & Joins5 Lessons
🔒
SQL BETWEEN Operator & Date Ranges
+50 XP • Interactive IDE🔒 Locked
🔒
SQL Aliases (AS Keyword)
+50 XP • Interactive IDE🔒 Locked
🔒
SQL INNER JOIN (Combining Tables)
+50 XP • Interactive IDE🔒 Locked
🔒
SQL LEFT JOIN & RIGHT JOIN
+50 XP • Interactive IDE🔒 Locked
🔒
SQL FULL OUTER JOIN & CROSS JOIN
+50 XP • Interactive IDE🔒 Locked
Module 5: Grouping, HAVING, Subqueries & DDL5 Lessons
🔒
SQL GROUP BY Clause & Aggregations
+50 XP • Interactive IDE🔒 Locked
🔒
SQL HAVING Clause & Filtered Groups
+50 XP • Interactive IDE🔒 Locked
🔒
SQL EXISTS Operator & Subqueries
+50 XP • Interactive IDE🔒 Locked
🔒
SQL CREATE TABLE & ALTER TABLE
+50 XP • Interactive IDE🔒 Locked
🔒
SQL Constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL)
+50 XP • Interactive IDE🔒 Locked
Module 6: Advanced Window Functions, CTEs & Query Tuning3 Lessons
🔒
Chapter 26: Window Functions (ROW_NUMBER, RANK, DENSE_RANK)
+85 XP • Interactive IDE🔒 Locked
🔒
Chapter 27: Common Table Expressions (WITH Clause)
+85 XP • Interactive IDE🔒 Locked
🔒
Chapter 28: B-Tree Indexes & Execution Plan Analysis
+90 XP • Interactive IDE🔒 Locked