Certificate Authentication

PostgreSQL Essentials Certificate for Aleksander Droszcz

Add to LinkedIn

Certificate ID: 
662167
Authentication Code: 
d41bc
Certified Person Name: 
Aleksander Droszcz
Trainer Name: 
Michał Kuna
Duration Days: 
2
Duration Hours: 
14
Course Name: 
PostgreSQL Essentials
Course Date: 
29 November 2021 09:00 to 30 November 2021 16:00
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