🐘 Become a PostgreSQL DBA
Tags: postgres, career, beginners, linux
Published: 2020-10-27 17:47:45


## Check your knowledge and learn missing to become PostgreSQL expert - [All skills for PostgreSQL DBA](https://infinite.education/view/PostgreSQL_DBA_2)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ftokci7niow9aanb0vze.png)

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](https://infinite.education/view/ALyZPdzNI36TKsDPQ0KCYEPS)**
 * Docker
 * Package managers (3 child nodes >>)
 * Managing Postgres service (3 child nodes >>)

**[Configure Postgres](https://infinite.education/view/uHpZliZ0IshgLQVdOI7n6FlT)**
 * postgresql.conf (9 child nodes >>)

**[SQL concepts](https://infinite.education/view/1lBJdjVaI1ddKFNY7XA98z9b)**
 * DML queries (4 child nodes >>)
 * Understand basic data types
 * DDL queries (1 child nodes >>)
 * COPY

**[Basic RDBMS terms and concepts](https://infinite.education/view/EmI1UAfQKIbEKYQJZCrwC2El)**
 * Relational model (6 child nodes >>)
 * Object model (7 child nodes >>)
 * Databases high-level concepts (3 child nodes >>)

**[SQL optimization technics](https://infinite.education/view/4dWsc7lYKWd9LqlkrGLDjioM)**
 * Indexes, and their use cases (6 child nodes >>)
 * SQL queries patterns and anti-patterns
 * SQL schema design patterns and anti-patterns

**[Automate Routine](https://infinite.education/view/vD34xoIdLZS3KPua9dFKINNy)**
 * 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](https://infinite.education/view/eKuu5VZRKvoOIMOexSXjvf8V)**
 * Fine-grained tuning (4 child nodes >>)
 * Advanced SQL topics (5 child nodes >>)
 * Low level internals (6 child nodes >>)

**[Develop application DBA skills](https://infinite.education/view/PGKoicfQJvfjIdkElZBN9PtK)**
 * 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](https://infinite.education/view/ZENva3eEJa0QKFqgvsitpvTb)**
 * 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](https://infinite.education/view/xdDgziALIXT8JSHfBi6RHeBP)**
 * roles
 * Objects privileges (2 child nodes >>)
 * Advanced Topics (9 child nodes >>)
 * SSL settings
 * Authentication models
 * pg_hba.conf


**[Postgres troubleshooting techniques](https://infinite.education/view/fZJm9gvVLkMBKlgpxG8axj9I)**
 * 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](https://infinite.education/view/CSeGk2k0KZk8LSSh3TC0Mrh4)**
 * Use Add button to add learning materials
 * Writing patches, attending in Commitfests
 * Reviewing patches


### [All skills for PostgreSQL DBA](https://infinite.education/view/PostgreSQL_DBA_2)

[Project page at facebook](https://www.facebook.com/InfEducation/)