🐘 Become a PostgreSQL DBA

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

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

Comments

[Andrew Baisden]

Good resources thanks for sharing.