knaxuslearn · build · ship

Roadmaps / Databases / Week 0: Prerequisites

Read first

Week 0: Prerequisites

Ten hours. Skip any item you can already do.

  • SQL: create two tables, insert rows and write a JOIN with a GROUP BY and a HAVING.
  • Tools: start PostgreSQL in Docker and connect with psql.
  • Programming: write a program that connects to a database, inserts a row and reads it back.
  • Git: commit, branch, merge and resolve one conflict.
  • Data: say the difference between a row and a column, and between a primary key and an index.