SQL
Ask questions of a database and get answers.
SQL is the standard language for working with data in tables. You will query a small bookshop database, filter and sort rows, summarize data, and combine tables.
- Beginner
- 10 lessons
- 1 h 59 min
- Free
Not started
Lessons
- 1Select columnsRead data from a table with SELECT and FROM.6 min
- 2Filter rows with WHEREPick only the rows that match a condition.10 min
- 3Sort and limitPut rows in order, keep the first few, and remove repeats.10 min
- 4Count and calculateUse COUNT, SUM, AVG, MIN, and MAX to get one answer from many rows.10 min
- 5Group rowsCalculate a result for each group with GROUP BY and HAVING.12 min
- 6Join tablesCombine rows from two tables that are linked by a shared value.12 min
- 7Change dataCreate a table, then add, change, and remove rows.14 min
- 8SubqueriesUse the result of one query inside another query.12 min
- 9Quiz, SQL basicsQuizTen questions on queries, filters, groups, joins, and changing data.8 min
- 10Project: bookshop reportProjectAnswer questions about book sales with joins, groups, subqueries, and an INSERT.25 min