2
PostgreSQL DBA learning roadmap.pdf
免费下载
Operating System Tools
top sysstat iotop
Profiling Tools
gdb
perf-tools Core Dumps
strace ebpf
Log Analysis
pgBadger
grepawk sed
Backup / Recovery Tools
Advanced Topics
DDL Queries
Data Types
For Schemas
For Tables
PostgreSQL
Basic RDBMS Concepts
Object Model
Query Processing
Data Types
Rows Columns
Tables Schemas
Databases
Queries
Relational Model
Domains Attributes
Tuples Relations
Constraints NULL
High Level Database Concepts
ACID MVCC Transactions
Write-ahead Log
Installation and Setup
Package Managers
Using Docker
Connect using `psql`
Managing Postgres
Using `systemd`
Using `pg_ctl`
Using `pg_ctlcluster`
Deployment in Cloud
Learn SQL Concepts
DML Queries
Querying Data
Modifying Data
Filtering Data
Joining Tables
Import / Export using `COPY`
Transactions CTE
Subqueries Lateral Join
Grouping Set Operations
Configuring PostgreSQL
Following postgres.conf
configurations and more
Resources Usage
Write-ahead Log
Checkpoints
Background Writer
Vacuums
Replication
Query Planner
Reporting Logging and Statistics
Adding Extra Extensions
Postgres Security Concepts
Authentication Models
Roles pg_hba.conf
SSL Settings
Object Priviliges
Grant / Revoke
Default Privileges
Advanced Topics
Row-Level Security
SELinux
Develop Infrastructure Skills
Replication
Streaming Replication
Logical Replication
pg_dump pg_dumpall
pg_restore
pg_basebackup
Builtin Tools3rd Party
barman
pgbackrest
pg_probackup
WAL-G
Backup Validation Procedures
Upgrade Procedures
Using `pg_upgrade`
Using Logical Replication
Connection Pooling
PgBouncer Alternatives
PgBouncer
Monitoring
Prometheus Zabbix
Cluster Management
Patroni
Patroni Alternatives
Load Balancing & Service Discovery
HAProxy
KeepAlived
Consul
Etcd
Kubernetes Deployment
Simple Stateful Setup
Helm Operators
Resource Usage and Provisioning, Capacity Planning
Learn to Automate Routines
Shell Scripts
Any Programming Language
Configuration Management
Ansible Salt Chef Puppet
Application Skills
Migrations
Practical Patterns and Antipatterns
liquibase, sqitch, Bytebase, ora2pg etc
Migration Tools
Bulk Loading and Processing Data
Data Partitioning
Data Normalization / Normal Forms
Queues
Practical Patterns and Antipatterns
Skytools PGQ
Advanced Topics
Low Level Internals
Processes and memory architecture
Vacuum Processing
Bu!er Management
Lock Management
Physical Storage and File Layout
System Catalog
Fine Grained Tuning
Per-user, Per-Database Settings
Storage Parameters
Workload-dependant tuning: OLTP, OLAP, HTAP
Advanced SQL
PL/pgSQL
Triggers
Aggregate and window functions
Procedures and Functions
Recursive CTE
Troubleshooting Techniques
Query Analysis
EXPLAIN Depesz
PEV2 Tenser
Troubleshooting Methods
USE RED
Golden Signals
SQL Optimization Techniques
Indexes and their Usecases
B-Tree Hash GiST
SP-GiST GIN BRIN
SQL Query Patterns / Anti-patterns
Schema Design Patterns / Anti-patterns
Introduction
What are Relational Databases?
RDBMS Benefits and Limitations
PostgreSQL vs Other RDBMS
PostgreSQL vs NoSQL Databases
Get Involved in Development
Mailing Lists
Reviewing Patches
Writing Patches
Keep Learning
Find the detailed version of this roadmap
along with resources and other roadmaps
https://roadmap.sh
MongoDB Roadmap
Related Roadmaps
Backend Roadmap
Important Note / Click here
explain.dalibo.com
Postgres Tools
pgcenter
Postgres System Views
pg_stat_activity
pg_stat_statements
Sharding Patterns
pgCluu
temBoard
check_pgactivity
check_pgbackrest
Terraform
Anonymization
PostgreSQL Anonymizer
of 1
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论