DEV Community

Roadmaps master
Roadmaps master

Posted on • Edited on

🐘 Become a PostgreSQL DBA

Check your knowledge and learn missing to become PostgreSQL expert - All skills for PostgreSQL DBA

Alt Text

You may help project by suggesting learn materials for each tree node. Others will thank you. Community - is power!

Here is first 2 levels of tree:

Install and run PostgreSQL

  • Docker
  • Package managers (3 child nodes >>)
  • Managing Postgres service (3 child nodes >>)

Configure Postgres

  • postgresql.conf (9 child nodes >>)

SQL concepts

  • DML queries (4 child nodes >>)
  • Understand basic data types
  • DDL queries (1 child nodes >>)
  • COPY

Basic RDBMS terms and concepts

  • Relational model (6 child nodes >>)
  • Object model (7 child nodes >>)
  • Databases high-level concepts (3 child nodes >>)

SQL optimization technics

  • Indexes, and their use cases (6 child nodes >>)
  • SQL queries patterns and anti-patterns
  • SQL schema design patterns and anti-patterns

Automate Routine

  • Use Add button to add learning materials
  • Configuration management (4 child nodes >>)
  • Automation using shell scripts or any other favourite language (3 child nodes >>)

Postgres advanced topics

  • Fine-grained tuning (4 child nodes >>)
  • Advanced SQL topics (5 child nodes >>)
  • Low level internals (6 child nodes >>)

Develop application DBA skills

  • Database normalization and normal forms
  • Migrations (3 child nodes >>)
  • Queues (2 child nodes >>)
  • Bulk Loading and Processing
  • Data import and export
  • Data partitioning and sharding patterns

Develop architect skills

  • Use Add button to add learning materials
  • Postgres forks and extensions (4 child nodes >>)
  • Differences between Postgres and other RDBMS and NoSQL databases
  • RDBMS

PostgreSQL Security

  • roles
  • Objects privileges (2 child nodes >>)
  • Advanced Topics (9 child nodes >>)
  • SSL settings
  • Authentication models
  • pg_hba.conf

Postgres troubleshooting techniques

  • Postgres system views (2 child nodes >>)
  • Log analyzing (2 child nodes >>)
  • Query analyzing (4 child nodes >>)
  • External tracing/profiling tools (5 child nodes >>)
  • Postgres tools (1 child nodes >>)
  • Operating system tools (3 child nodes >>)
  • Troubleshooting methods (3 child nodes >>)

Develop Postgres hacker skills

  • Use Add button to add learning materials
  • Writing patches, attending in Commitfests
  • Reviewing patches

All skills for PostgreSQL DBA

Project page at facebook

Top comments (1)

Collapse
 
andrewbaisden profile image
Andrew Baisden

Good resources thanks for sharing.