Erthiox course audio
← Back to text lessons
SQL & Databases
Listen to the audio to unlock the exam – or finish the lessons instead. Either path opens the same exam, and passing it earns the certificate. Prefer reading? Use the button above to go back to the 50 text lessons.
HOOK
Hook
No experience needed.
✓
RELATIONAL DATABASES TABLES
Relational databases, tables, and keys
A relational database organises data into tables, and the course starts with that picture: a table is a collection of rows, each row is one thing, like one customer or one order, and each column is one attribute of that thing, like a name or a price.
✓
SELECT WHERE ORDER
SELECT, WHERE, ORDER BY, and aggregates
SELECT is the verb of SQL, and the course builds it in layers.
Confuse them and your numbers lie politely, which is the worst kind of wrong.
✓✓
INSERT UPDATE DELETE
INSERT, UPDATE, DELETE, and the safety practice
Reading data is half of SQL.
DELETE removes data where a condition matches.
✓✓
FOREIGN KEYS JOINS
Foreign keys, JOINs, and normalisation
Real data lives in many tables, and foreign keys are the links between them: a column in one table that holds the primary key of another, like an order row holding the id of the customer who placed it.
✓
INDEXES SUBQUERIES CASE
Indexes, subqueries, CASE, and transactions
Indexes speed up queries, and the course explains them with the classic analogy: an index is like the index of a book, letting the database jump to the right rows instead of reading every page.
✓
CONSTRAINTS PERFORMANCE AND
Constraints, performance, and the complete query
Constraints enforce data rules at the database level: a column must not be empty, a value must be unique, a price must be positive.
✓
YOUR SEVEN DAY
Your seven day plan
Here is your seven day plan.
Seven days, and you will be able to interrogate any database with confidence.
✓✓
CLOSE
Close
Remember the rule of this path: watching this video unlocks the exam.
See you in lesson one.
✓✓
0:00 / 10:01
Watched 0:00
Listen to the audio to unlock the exam.
Audio complete – you can now take the exam. Continue to exam.
That's the audio.
Listen again, read the lessons, or take the exam when you are ready.
Captions are on by default. Keyboard: Space play/pause, arrows seek 5s, M mute, F fullscreen player.