Progress
0/7
1
Intro to databases
Tables, rows, columns: understanding a relational database
2
Selecting data
SELECT, FROM, WHERE: read data from a table
3
Filtering and sorting
AND/OR, LIKE, IN, ORDER BY: refine and order results
4
Aggregating and grouping
COUNT, SUM, GROUP BY: compute statistics
5
Joins
INNER and LEFT JOIN: link multiple tables
6
Modifying data
INSERT, UPDATE, DELETE: write and change data
7
Designing and securing
CREATE, keys, and the #1 flaw: SQL injection
What you will learn
Understand the relational model: tables, keys, relations
Write SELECT queries to read any data
Join multiple tables together
Compute statistics with aggregates
Modify data without breaking everything
Protect against SQL injection with prepared statements
Play to practise
Free games to practise SQL while having fun.