INTERLAB
RUEN
Discuss a project
Direction · 06

Databases

SQL, PostgreSQL, MySQL, Redis and NoSQL, design, indexes, transactions, ORMs and migrations.

12 materials

Database Fundamentals

✓Databases: tables, keys and why a business needs themFundamentals · Beginner · 10 min

SQL

✓SQL from scratch: SELECT, WHERE, ORDER BYTutorial · Beginner · 9 min · practice 45–90 min✓SQL: JOIN, GROUP BY and aggregatesTutorial · Beginner · 10 min · practice 45–90 min

PostgreSQL

✓PostgreSQL: running in Docker, psql and a first tableTutorial · Beginner · 11 min · practice 45–90 min

Database Design

✓Database design: relationships, keys and normalisationTutorial · Intermediate · 10 min · practice 1.5–3 h

Indexes

✓Indexes: speeding up queries without slowing down writesDeep dive · Intermediate · 9 min

Transactions

✓Transactions and isolation: ACID without the mysteryDeep dive · Intermediate · 8 min

ORM & Migrations

✓ORM and migrations with PrismaTutorial · Intermediate · 13 min · practice 1.5–3 h

Query Optimization

✓Query optimisation: EXPLAIN ANALYZE in practiceHow-to · Advanced · 9 min · practice 2–4 h

Redis

✓Redis: cache, TTL and countersTutorial · Intermediate · 11 min · practice 1.5–3 h

NoSQL Concepts

✓NoSQL: documents, key-value, and when they beat SQLComparison · Intermediate · 9 min

MySQL

✓PostgreSQL or MySQL: practical differencesComparison · Intermediate · 8 min

Learning paths with this direction

SQL and PostgreSQL · 9 steps →
← All directions