曙海教学优势
曙海培训的课程培养了大批受企业欢迎的工程师。大批企业和曙海
建立了良好的合作关系。曙海培训的课程在业内有着响亮的知名度。
本课程，秉承二十一年积累的教学品质，以项目实现为导向,老师将会与您分享设计的全流程以及工具的综合使用经验、技巧。
此培训专为希望从基础知识中学习Postgre SQL Database管理员和架构师而设计。
您将学习Postgre SQL体系结构，安装，设计以及如何在Postgre SQL执行备份和恢复数据库。
· Introduction
· System Architecture and Internals
o Process Architecture
o Memory Internals
o Storage Architecture
· Installations
o Downloading PostgreSQL
o Preparing System for Installation
o Install PostgreSQL
o Create, Start, Stop a Database Server
o Viewing Information
· PSQL Tool
o Connecting to a Database
o Executing SQL
o psql Meta Commands
· PGAdmin4
o Connecting to a Database
o Basic Tasks using GUI
· Database Designing
o Database Users
o Creating and Managing Databases
o Schemas
o Tables
o Data Types
o Sequences
o Views
o Materialized Views
· Database Backups
o Logical or SQL Dump Backups
o Physical Backups - Offline
o Physical Backups - Online
o Archiving
· Restoring Backups
o Restoring SQL Dumps
o Restoring Offline Backups
o Point in Time Recovery
o Partial Restore
· Proactive Maintenance
o Database Statistics
o Data Fragmentation and Vacuuming
o Data Re-organization
o Automatic Maintenance Configuration
o Re-indexing
· System Parameters
o Parameter File
o Changing Server Parameters
o Resource Parameters
o Planner Parameters
o Logging Parameters
o Transaction Logging Parameters
