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.
✓✓
Press play to begin.
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.