A quick revision course ยท MySQL first, PostgreSQL alongside

Back to the Database

You knew this once. This brings it back fast: what a relational database is, how to get MySQL and PostgreSQL running on Windows, and what the engines can actually do for you as a DBA. Every chapter opens with the short version and takes about five minutes. The goal is recognition, not memorization. When you need exact syntax, ask an AI. When you need to know what is possible, look here.

Start with chapter 1 Jump to the Windows install Final exam

How to use this

  1. Skim the short version first. Every chapter opens with a box that gives you the whole thing in about 60 seconds. Read the rest only where it feels unfamiliar.
  2. Read in order the first time. Chapters run about five minutes each. Part 1 rebuilds the vocabulary that every later chapter leans on.
  3. Do the quick check at the end. Three to five questions, instant feedback. If you miss one, the explanation tells you which section to reread.
  4. Mark chapters as done. Progress is saved in this browser only, so it stays private and survives closing the tab.
  5. Keep a database open for Part 3. Once MySQL is installed (chapter 4), load the sample database from chapter 6 and try each capability on real rows.
  6. Use AI for syntax, not for understanding. The "Ask the AI" boxes show how to phrase a request so the answer is right for your engine and version.

About the two engines

The job is MySQL, so MySQL comes first everywhere. PostgreSQL is covered alongside for two reasons: many teams run both, and seeing where they differ makes the concepts stick. MySQL and PostgreSQL badges mark engine-specific points; Both means the capability is standard.

Version baseline: MySQL 8.4 LTS, 9.7 LTS and the 26.x Innovation line; PostgreSQL 17 and 18; Windows 11. Where something changed recently, the chapter says so.