曙海教学优势
曙海培训的课程培养了大批受企业欢迎的工程师。大批企业和曙海
建立了良好的合作关系。曙海培训的课程在业内有着响亮的知名度。
本课程，秉承二十一年积累的教学品质，以项目实现为导向,老师将会与您分享设计的全流程以及工具的综合使用经验、技巧。
此培训专为希望学习在Postgre SQL实现高可用性和Database安全性的工具和技术的Database管理员和架构师而设计。
您还将学习如何查找慢查询，监视数据库性能以及调整Postgre SQL for Performance。
· Introduction
· Database Security
o Users and Groups
o Access Control
o Row Level Security
o Host Based Access Control
o Data Encryption using pgcrypto
o Demos and Labs
· Performance Monitoring and Tuning
o Monitoring Slow Queries
o SQL Tuning
o Table Partitioning
o Operating System Best Practices
o Parameter Tuning
o Extensions
o Benchmarking
o Monitoring Best Practices
o Demos and Labs
· High Availability
o Transaction Log Archiving
o Streaming Replication
o Connection Pooling and HA setup using pgpool-II
§ Installation
§ Configuration
§ Pool Setup
§ HA Setup
o Demos and Labs
· Database Upgrades
o PostgreSQL Versioning
o Plan for Upgrade
o Upgrade using pg_dump
o Upgrade using pg_upgrade
o In Place or Not-in Place Upgrade
o Post Upgrade Tasks
