SQL — Beginner

SQL — Query a Real Database: 8 topics and 31 interactive cards with runnable examples and quizzes.

Topics

1. Reading Data — SELECT · WHERE
2. Sorting & Filtering — ORDER BY & LIMIT · LIKE & IN
3. Combining & Summarising — JOIN · GROUP BY & Aggregates · LEFT JOIN: Keeping Rows With No Match
4. SQL Basics: SELECT Queries — SELECT and WHERE · SELECT and WHERE in Code · Practice: SELECT and WHERE · Solution & Challenge: SELECT and WHERE · DISTINCT, LIKE, and IN · DISTINCT, LIKE, and IN in Code · Practice: DISTINCT, LIKE, and IN · Solution & Challenge: DISTINCT, LIKE, and IN
5. SQL CREATE TABLE and Data Types — Table Creation · Table Creation in Code · Practice: Table Creation · Solution & Challenge: Table Creation
6. SQL Data Import and Export — Loading and Exporting Data · Loading and Exporting Data in Code · Practice: Loading and Exporting Data · Solution & Challenge: Loading and Exporting Data
7. SQL INSERT, UPDATE, DELETE — Data Modification · Data Modification in Code · Practice: Data Modification · Solution & Challenge: Data Modification
8. SQL String Functions — String Manipulation · String Manipulation in Code · Practice: String Manipulation · Solution & Challenge: String Manipulation