Learn with Abdou

Chapters

The course as a book. Each chapter is one sitting of reading with a few concepts to practise on their own; the labs stay in Canvas as the graded work.

SQL playgroundMy progress

The chapters

4 chapters

2

Ask questions of one table

SELECT, WHERE, LIKE, NULL and what top five means

Goes with Lab 2: SELECT and WHERE · 6 concepts

Open
7

Connect tables

JOINs and the rows that have no match

Goes with Lab 8: The Normalized World · 6 concepts

Open
9

Change rows and tables safely

INSERT, UPDATE, DELETE, ALTER and DROP, with a preview first

Goes with Lab 10: From Paper to Database · 6 concepts

Open
10

Load a file and prove the load

Staging, validation, orphans, reconciliation and the rebuild

Goes with Lab 10: From Paper to Database · 5 concepts

Open

Chapters still being written

The other lessons are on the learning path.

Every topic of the course is still there in class order. A topic moves into this book once its chapter is ready, and its old link then opens the chapter.

Open the learning path