Francisco Javier Palacios PérezFco. Javier Palacios Pérez
Software Developer
Course: SQL: From Zero to DBA

Course: SQL: From Zero to DBA

Learn SQL and PostgreSQL from zero to DBA-level judgment: relational modeling, queries, joins, aggregations, indexes, performance, transactions, security, ORMs, and production operations.

Why We Need Databases1

Why We Need Databases

Before writing your first query, understand what problem databases solve: persistence, relationships, concurrency, querying, and real guarantees.

Setting Up PostgreSQL with Docker, psql, and pgAdmin2

Setting Up PostgreSQL with Docker, psql, and pgAdmin

Run PostgreSQL 18 with Docker Compose, connect with psql and pgAdmin, and understand the pieces of your first real SQL environment.