         PostgreSQL for Administrators - 3 Days培訓

Introduction

Overview of PostgreSQL features and architecture
Basics of database administration
Getting Started

Installing PostgreSQL
Configuring a pgAdmin 4 client
Creating a database user
Creating a database
Database Operations

SQL syntax, functions, and operators
Data definition and data types
User-defined data types
Table schemas
Creating and modifying tables
Manipulating data in tables
Querying and filtering data
Exploring constraints
Conversion functions
Joining multiple tables
Combining queries
Indexes and full-text search
Concurrency control
Regular expressions
Database Server Administration

Security and encryption
Access roles and permissions
Backup and restore
Upgrading PostgreSQL
High availability
Load balancing and replication
Statistics and monitoring
High Performance Tuning

Resource management
Monitoring query performance
Parameter tuning
Index optimization
Query optimization
Scalability and partitioning
External Tools for Monitoring and Observability

pgAdmin
pgBadger
pgbench
node-exporter Prometheus, Grafana
Zabbix
Troubleshooting

Summary and Next Steps