課程大綱： PostgreSQL Essentials培訓(xùn)
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 to a Database
Executing SQL
psql Meta Commands
PGAdmin4
Connecting to a 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
加入高級會員獲得助教答疑
