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

Number of participants



Price per participant

Testimonials (5)

Related Courses

Migrating Oracle to Azure SQL or PostgreSQL

7 Hours

PostgreSQL Administration and Development

28 Hours

PostgreSQL for Administrators - 2 Days

14 Hours

PostgreSQL Advanced DBA

14 Hours

Implementing High Availability in PostgreSQL

7 Hours

PostgreSQL Performance Tuning

14 Hours

PostgreSQL Administration, Optimization and Replication

35 Hours

PostgreSQL for Developers

14 Hours

PostgreSQL 13 for Developers and Administrators

21 Hours

PostgreSQL for Administrators - 3 Days

21 Hours

PostgreSQL with Python

21 Hours

Data Management

35 Hours

Pivotal Greenplum for Developers

21 Hours

MarkLogic Server

14 Hours

SAP ASE for Database Administrators

28 Hours

Related Categories

1