04. Select, and the order it runs | SQL and Data Modelling

Description:
Practise this topic with SQL test papers, free to start: https://www.pytesthub.com

Lecture 4 of 16 in SQL and Data Modelling, from Toppers Education Centre.
Unit 2 — Creating and changing data (weeks 2–3)
Worked in MySQL, against one university database throughout.

SELECT, WHERE, ORDER BY, LIMIT, DISTINCT; LIKE, IN, BETWEEN, IS NULL; and the logical order FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY.

CHAPTERS
0:00 The question
0:52 The six clauses, in the order you write them
2:29 The order it actually runs
4:27 Choosing rows: where in earnest
6:31 Shaping what comes back
8:29 The answer
9:50 Summary

WHAT THIS COVERS
- SELECT
- WHERE
- ORDER BY
- LIMIT
- DISTINCT
- LIKE
- IN
- BETWEEN
- IS NULL
- And the logical order FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY

Previous: 03. Insert, update and delete
Next: 05. Entities, attributes and keys

Full playlist: https://www.youtube.com/playlist?list=PLDPocssCnirA