課程概覽

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

課程大綱

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

?