
曙海教學(xué)優(yōu)勢
該課程,秉承21年教學(xué)品質(zhì),以項(xiàng)目實(shí)現(xiàn)為導(dǎo)向,面向企事業(yè)單位項(xiàng)目實(shí)際需求,講師將會與您分享設(shè)計(jì)的全流程以及工具的綜合使用技巧與經(jīng)驗(yàn)。課程可定制,線下/線上/上門皆可,全國免費(fèi)報(bào)名熱線:4008699035。
曙海培訓(xùn)的課程培養(yǎng)了大批受企業(yè)歡迎的工程師。大批企業(yè)和曙海
建立了良好的合作關(guān)系,合作企業(yè)三十多萬家。曙海的課程得到業(yè)內(nèi)企事業(yè)單位廣泛贊譽(yù)。
?
此培訓(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
?