
曙海教學(xué)優(yōu)勢
本課程,秉承二十一年積累的教學(xué)品質(zhì),以項(xiàng)目實(shí)現(xiàn)為導(dǎo)向,面向企事業(yè)項(xiàng)目實(shí)際需要,老師將會與您分享設(shè)計(jì)的全流程以及工具的綜合使用經(jīng)驗(yàn)、技巧。課程可定制,線上/線下/上門皆可,熱線:4008699035。
  曙海培訓(xùn)的課程培養(yǎng)了大批受企業(yè)歡迎的工程師。大批企業(yè)和曙海
     建立了良好的合作關(guān)系,20多年來,合作企事業(yè)單位以達(dá)30多萬。曙海培訓(xùn)的課程在業(yè)內(nèi)有著響亮的知名度。
?
此培訓(xùn)專為希望學(xué)習(xí)在Postgre?SQL實(shí)現(xiàn)高可用性和Database安全性的工具和技術(shù)的Database管理員和架構(gòu)師而設(shè)計(jì)。
您還將學(xué)習(xí)如何查找慢查詢,監(jiān)視數(shù)據(jù)庫性能以及調(diào)整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
?