課程概覽

PostgreSQL（或Postgres）是最受歡迎的開源關系數(shù)據(jù)庫之一。 在培訓結(jié)束后，參與者將能夠： 使用高級管理技術來配置和管理PostgreSQL服務器優(yōu)化數(shù)據(jù)庫和查詢以獲得最佳性能復制并縮放PostgreSQL服務器 聽眾 數(shù)據(jù)庫管理員系統(tǒng)管理員具有數(shù)據(jù)庫經(jīng)驗的開發(fā)人員 課程的 格式 部分講座，部分討論，練習和沉重的練習 注意 本課程基于PostreSQL 9，但可以適應不同的版本

課程大綱

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

?