Storing and querying data with SQL databases.

On the map: Develop › Data

1. SQL databases Beginner 12 min read ✓ Learned

   Tables, keys and queries: how applications store data reliably in a relational database.

   Before this: HTTP and APIs

2. Schema migrations Intermediate 10 min read ✓ Learned

   Change the database structure in small, versioned steps that run the same way everywhere.

   Before this: SQL databases

Technologies & Frameworks

Tools you are likely to meet with these topics. They are options, not requirements: you do not need any of them to mark a topic as learned, and nobody uses them all. Pick one when a project calls for it.

With SQL databases

• PostgreSQL

  Database

  An open-source relational database server with transactions, constraints, JSON columns and many index types.

  Tutorial ↗ — PostgreSQL, official documentation, opens in a new tab Official · PostgreSQL

• SQLite

  Database

  A SQL database engine stored in a single file and used as a library, with no server to run.

  Recommended for: Learning SQL, local tools and small applications

  SQLite In 5 Minutes Or Less ↗ — SQLite, official documentation, opens in a new tab Official · SQLite

With Schema migrations

• PostgreSQL

  Database

  An open-source relational database server with transactions, constraints, JSON columns and many index types.

  Tutorial ↗ — PostgreSQL, official documentation, opens in a new tab Official · PostgreSQL