← All courses

Your first database

You'll open a database and figure out which tables and columns it has, write your first SELECT queries with WHERE, ORDER BY and LIMIT, add and fix a row, and create a table of your own.

7 tasks · 2 questions
  1. Look inside the databaseeasy
  2. Your first SELECT: a price listeasy
  3. WHERE: what's out of stockeasy
  4. ORDER BY and LIMIT: the three most expensiveeasy
  5. LIMIT without ORDER BYinterview questioneasy
  6. INSERT: a new producteasy
  7. UPDATE: a new price for the kettleeasy
  8. UPDATE without WHEREinterview questioneasy
  9. CREATE TABLE: a suppliers tableeasy