ORDER BY
title: “ORDER BY” part: 1 topic_number: 9 slug: “order-by” difficulty: “Beginner” prerequisites: “select-from-where” — ORDER BY What Is It? ORDER BY sorts your query results. By default, SQL ret...
Rahul Chandna
Filtering Data
title: “Filtering Data” part: 1 topic_number: 8 slug: “filtering” difficulty: “Beginner” prerequisites: “select-from-where” — Filtering Data What Is It? Filtering refines your WHERE clause with ...
SELECT with FROM and WHERE
title: “SELECT with FROM and WHERE” part: 1 topic_number: 7 slug: “select-from-where” difficulty: “Beginner” prerequisites: “insert” — SELECT with FROM and WHERE What Is It? SELECT is the most i...
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...
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...