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

Requirements

There are no specific requirements needed to attend this course. It is recommended to start with this training if you have never taken a formal training of PostgreSQL

 14 Hours

Testimonials (7)