Overview
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
Course Outline
- 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