DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Roadmaps master
Roadmaps master

Posted on • Updated 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.

Stop sifting through your feed.

Find the content you want to see.

Change your feed algorithm by adjusting your experience level and give weights to the tags you follow.