课程目录: PostgreSQL Advanced DBA培训
4401 人关注
(78637/99817)
课程大纲:

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