課程大綱：PstgreSQL Advanced DBA培訓
Intrductin
Database Security
Users and Grups
Access Cntrl
Rw Level Security
Hst Based Access Cntrl
Data Encryptin using pgcrypt
Dems and Labs
Perfrmance Mnitring and Tuning
Mnitring Slw Queries
SQL Tuning
Table Partitining
perating System Best Practices
Parameter Tuning
Extensins
Benchmarking
Mnitring Best Practices
Dems and Labs
High Availability
Transactin Lg Archiving
Streaming Replicatin
Cnnectin Pling and HA setup using pgpl-II
§ Installatin
§ Cnfiguratin
§ Pl Setup
§ HA Setup
Dems and Labs
Database Upgrades
PstgreSQL Versining
Plan fr Upgrade
Upgrade using pg_dump
Upgrade using pg_upgrade
In Place r Nt-in Place Upgrade
Pst Upgrade Tasks
加入高級會員獲得助教答疑
