DROP TABLE
title: “DROP TABLE” part: 1 topic_number: 6 slug: “drop-table” difficulty: “Beginner” prerequisites: “create-table, alter-table” — DROP TABLE What Is It? DROP TABLE completely deletes a table fr...
Rahul Chandna
ALTER TABLE
title: “ALTER TABLE” part: 1 topic_number: 5 slug: “alter-table” difficulty: “Beginner” prerequisites: “create-table” — ALTER TABLE What Is It? ALTER TABLE modifies an existing table’s structure...
DELETE
title: “DELETE” part: 1 topic_number: 4 slug: “delete” difficulty: “Beginner” prerequisites: “insert, update” — DELETE What Is It? DELETE removes entire rows from a table. Unlike UPDATE (which c...
UPDATE
title: “UPDATE” part: 1 topic_number: 3 slug: “update” difficulty: “Beginner” prerequisites: “insert” — UPDATE What Is It? UPDATE modifies existing data in a table. You use it to change values i...
INSERT
title: “INSERT” part: 1 topic_number: 2 slug: “insert” difficulty: “Beginner” prerequisites: “create-table” — INSERT What Is It? INSERT is how you add new rows (records) to a table. Think of a t...
CREATE TABLE — Building Your Database Structure
title: “CREATE TABLE” part: 1 topic_number: 1 slug: “create-table” difficulty: “Beginner” prerequisites: “setup-company-db” — CREATE TABLE — Building Your Database Structure What Is It? CREATE T...
Mini Challenge 11 — Capstone: Complete Business Intelligence Dashboard
title: “Mini Challenge 11 — Capstone Project” part: 3 topic_number: 0 slug: “mini-challenge-11” difficulty: “Advanced” prerequisites: “row-number, rank, transactions” — Mini Challenge 11 — Capston...
Mini Challenge 10 — Recursive CTEs, Dates, Views
title: “Mini Challenge 10 — Part 3 Topics 1-3” part: 3 topic_number: 0 slug: “mini-challenge-10” difficulty: “Advanced” prerequisites: “hierarchies-recursive-cte, date-functions, views” — Mini Cha...
Mini Challenge 9 — COALESCE, Subqueries
title: “Mini Challenge 9 — Part 2 Topics 5-7” part: 2 topic_number: 0 slug: “mini-challenge-09” difficulty: “Intermediate” prerequisites: “coalesce, nested-subqueries, correlated-subqueries” — Min...
Mini Challenge 8 — SUBSTRING, CASE, Self Joins, Multiple Joins
title: “Mini Challenge 8 — Part 2 Topics 1-4” part: 2 topic_number: 0 slug: “mini-challenge-08” difficulty: “Intermediate” prerequisites: “substring, case-when, self-joins, multiple-joins” — Mini ...