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