Course Code: bspa2
Duration: 14 hours
Course Outline:

PostgreSQL Administration (2 days)

 

  • System Architecture and Internals
    • Process Architecture
    • Memory Internals
    • Storage Architecture 
  • Installations
    • Downloading PostgreSQL packages
    • Preparing System for Installation
    • Install PostgreSQL 
    • Create, Start, Stop a Database Server
    • Viewing Information 
  • PSQL & GUI Tools
    • Connecting to a Database
    • Executing SQL
    • psql Meta Commands
  • Information Schema & Database Design
    • 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
    • Transaction log 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