PostgreSQL

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

PostgreSQL is the most advanced open source database. Increasingly companies around the world are entrusting their most critical data to Postgres.

At the end of the training, participants will be able to:

Pre-requisite

All Attendees should have experience with SQL – including DDL, DML, and writing effective SQL queries.

Duarion

4  days

Course Outline

  1. History of PostgreSQL
  2. Major Features
  3. New Features of PostgreSQL
  4. Multi Version Concurrency Control
  5. Write-Ahead Logging
  6. Architectural Overview
  7. Limits
  1. Architectural Summary
  2. Shared Memory
  3. Statement Processing
  4. Utility Processes
  5. Disk Read Buffering
  6. Write Buffering
  7. Background Writer Cleaning Scan
  8. Commit & Checkpoint
  9. Physical Database Architecture
  10. Data Directory Layout
  11. Installation Directory Layout
  12. Page Layout
  1. Object Hierarchy
  2. Creating Databases
  3. Creating Schemas
  4. Schema Search Path
  5. Roles, Users & Groups
  6. Access Control
  1. The System Catalog Schema
  2. System Information views/tables
  3. System Information Functions
  1. Setting PostgreSQL Parameters
  2. Access Control
  3. Connection Settings
  4. Security and Authentication
  5. Settings
  6. Memory Settings
  7. Query Planner Settings
  8. WAL Settings
  9. Log Management
  10. Background Writer Settings
  11. Statement Behavior
  1. Authentication
  2. Authorization
  3. Levels of security
  4. pg_hba.conf file
  5. Users
  6. Object ownership
  7. Access control
  8. Application access parameters
  1. Backup Types
  2. SQL Dump
  3. Cluster Dump
  4. Offline Copy Backup
  5. Continuous Archiving
  6. pg_basebackup
  7. Point-In Time Recovery
  8. pg_upgrade
  1. Explain and Explain Analyze
  2. Table Statistics
  3. Updating Planner Statistics
  4. Vacuuming
  5. Scheduling Auto Vacuum
  6. Preventing Transaction ID Wraparound Failures
  7. The Visibility Map
  8. Routine Reindexing
  1. Partitioning
  2. Partitioning Methods
  3. When to Partition
  4. Partitioning Setup
  5. Partitioning Example
  6. Partitioning and Constraint
  7. Exclusion
  8. Caveats
  1. Database Statistics
  2. The Statistics Collector
  3. Database Statistic Tables
  4. Operating System Process Monitoring
  5. Current Sessions and Locks
  6. Log Slow Running Queries
  7. Disk Usage

Reviews