In productionCore

Advanced SQL Testing

Testing for Advanced SQL: Tests the code they wrote, not the code they meant.

Questions90 planned

Topics10 planned

Answering time~68 minutes

At five a day~18 days

LevelCore

Who it is for

Tests the code they wrote, not the code they meant.

The behaviour people get wrong after they are already productive in the language.

You will get the most out of it if you have written Advanced SQL recently enough to read it without effort, and have been surprised by it at least once. If you are picking the language up for the first time, start with Advanced SQL Essentials and come back to this one.

How long it takes

Planned at 90 graded questions, which is about 68 minutes of answering and roughly 18 days at five a day.

Nothing ships until every runnable snippet in it has been executed and matched against its answer.

Syllabus

What you will be asked about

This course is in production

It is planned as ten topics of ten questions, the same shape as every other course in the catalogue: one concept card, six multiple-choice questions, one predict-the-output, one ordering task and one matching task per topic. The topics themselves are mined from PostgreSQL and SQLite documentation, and nothing is listed here until the questions exist and have been executed — a syllabus written before the content is a promise, and this page only carries facts.

Free and paid courses are decided per course, not per language, and this one will be included in a subscription.

The rest of the track