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
JOINwith aGROUP BYand aHAVING. - 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.