Building AI apps with Claude: study plan
From the first API call to tools, streaming and an agent, using Anthropic's free docs.
16 itemsStart
SQL study plan
Queries, joins, grouping, indexes and transactions, practised on PostgreSQL with its free manual.
15 items · 5 sections · study, sql, database, postgresql
Setup (2)
- Install PostgreSQLpostgresql.org
- Tutorial: create a databasepostgresql.org
Basics (5)
- Create a table and add rowspostgresql.org
- Query a table (SELECT, WHERE, ORDER BY)postgresql.org
- Joins between tablespostgresql.org
- Aggregate functions and GROUP BYpostgresql.org
- Update and delete rowspostgresql.org
Going further (5)
- Foreign keyspostgresql.org
- Transactionspostgresql.org
- Window functionspostgresql.org
- WITH queries (CTEs)postgresql.org
- Data types: pick the right onepostgresql.org
Performance (2)
- Indexespostgresql.org
- Read query plans with EXPLAINpostgresql.org
Project (1)
- Model a small shop (customers, orders, items) and write 10 report queries
Written from www.postgresql.org
Similar
DevOps basics study plan
Git, Linux, containers, CI and a first deploy, each step from the tool's own free docs.
15 itemsStart
Go study plan
The Go tour, modules, tests and a small web service, from go.dev only.
16 itemsStart
Python developer study plan
From first script to a tested, packaged Python project, using only the free official docs.
17 itemsStart
React study plan
Components, state, effects and a first app, following the free docs on react.dev.
17 itemsStart