SQL & Databases

Welcome to the Data Kingdom: What's a Database?

Finding Your Treasure: The `SELECT` Spell

Secret Filters: `WHERE` to Find Specific Data

Adding New Friends: The `INSERT` Command

Giving a Makeover: `UPDATE` Your Records!

Cleaning Up Your List: `DELETE` Unwanted Data

Organizing Your Data: `ORDER BY` and `LIMIT`

Counting Your Collection: `COUNT`, `SUM`, and `AVG`

Finding Hidden Connections: `LEFT JOIN`, `RIGHT JOIN`, and `FULL JOIN`

Advanced Collection Organizing: `GROUP BY` and `HAVING` for Deeper Insights

Linking Your Worlds: Joining Tables with `INNER JOIN`

Building Your Own Tables: The `CREATE TABLE` Blueprint

Super Keys & Relationships: Database Connections

Your First Database Adventure: A Mini-Project

Queries within Queries: Subqueries and Common Table Expressions (CTEs)

Reshaping Your Data Kingdom: `ALTER TABLE` and `DROP TABLE`

Guarding Your Data's Integrity: `UNIQUE`, `CHECK`, and `DEFAULT` Constraints

Casting Reusable Spells: Creating and Using Views

Optimizing Your Data Hunts: Understanding Indexes for Faster Queries

Ensuring Data Consistency: Transactions with `COMMIT` and `ROLLBACK`