課程大綱：PostgreSQL Essentials培訓
Introduction
System Architecture and Internals
Process Architecture
Memory Internals
Storage Architecture
Installations
Downloading PostgreSQL
Preparing System for Installation
Install PostgreSQL
Create, Start, Stop a Database Server
Viewing Information
PSQL Tool
Connecting ta Database
Executing SQL
psql Meta Commands
PGAdmin4
Connecting ta Database
Basic Tasks using GUI
Database Designing
Database Users
Creating and Managing Databases
Schemas
Tables
Data Types
Sequences
Views
Materialized Views
Database Backups
Logical or SQL Dump Backups
Physical Backups - Offline
Physical Backups - Online
Archiving
Restoring Backups
Restoring SQL Dumps
Restoring Offline Backups
Point in Time Recovery
Partial Restore
Proactive Maintenance
Database Statistics
Data Fragmentation and Vacuuming
Data Re-organization
Automatic Maintenance Configuration
Re-indexing
System Parameters
Parameter File
Changing Server Parameters
Resource Parameters
Planner Parameters
Logging Parameters
Transaction Logging Parameters
加入高級會員獲得助教答疑
