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:
- Docker
- Package managers (3 child nodes >>)
- Managing Postgres service (3 child nodes >>)
- postgresql.conf (9 child nodes >>)
- 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 >>)
- Indexes, and their use cases (6 child nodes >>)
- SQL queries patterns and anti-patterns
- SQL schema design patterns and anti-patterns
- Use Add button to add learning materials
- Configuration management (4 child nodes >>)
- Automation using shell scripts or any other favourite language (3 child nodes >>)
- 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
- Use Add button to add learning materials
- Postgres forks and extensions (4 child nodes >>)
- Differences between Postgres and other RDBMS and NoSQL databases
- RDBMS
- 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
Top comments (1)
Good resources thanks for sharing.