PostgreSQL DBA roadmap
Six stages · about three months at five hours a week · 28 resources
Run, tune and protect a PostgreSQL database.
Leads to roles such as Database Administrator, Backend Developer.
Create a free account to open the lessons and videos, tick off stages, save this roadmap and track your progress.
The stages
Stage 1: SQL and Postgres basics
Install, connect and query with confidence.
about 2 weeks 4 lessons and videos inside
You will be able to
- Install Postgres and use psql
- Create tables with types and constraints
- Write joins and aggregates
Project
Create a schema for a library system and load sample data.
Stage 2: Indexes and query plans
Why queries are slow and how to fix them.
about 3 weeks 5 lessons and videos inside
You will be able to
More roadmaps to explore
- Frontend DeveloperHTML to your first frontend offer, in eight stages.
- Backend DeveloperOne language, one database, one deployed service.
- QA EngineerManual testing done properly, then automation.
- DevOpsLinux, CI and what on-call really means.
- Full Stack DeveloperFrontend, backend and a database, shipped as one product.
- Android DeveloperFrom Kotlin basics to an app on the Play Store, in six stages.