课程概览
此培训专为希望从基础知识中学习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
