課程大綱：PostgreSQL Administration, Optimization and Replic培訓
Introduction
PostgresSQL Setup and Configuration
Overview of PostgreSQL Architecture and Advanced Features
PostgreSQL Administration
Connecting to the Database
Overview of PgAdmin III
Configuring the Server
Setting up and Managing Users
Overview of Database Object Types
Setting Permissions & Security
Querying the Database
Monitoring the Database
Ensuring Atomicity and Isolation
Backing up and Restoring PostreSQL
Migrating Data to Another System
Working with PostreSQL Logs
Performance Optimization
Reducing I/O with HOT
Locking & Concurrency
Evaluating the Design of the Database
Optimizing SQL Queries with EXPLAIN
Inspecting the Workload
Benchmarking and Profiling
Optimzing Joins
Using Indexes Efficiently
PostgreSQL Replication
Overview of PostgreSQL Replication
High Availability in PostgreSQL
Streaming Replication
Managing Clusters Using repmgr
Running Queries on Database in Hot Standby
Synchronous Replication
File based Log Shipping
Trigger-based Logical Replication with Slony & Londiste
Connection Pooling
Upgrading PostgreSQL
Sharding and Scaling PostgreSQL
Summary and Conclusion
加入高級會員獲得助教答疑
