Customized Onsite Training

5
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors
Request Class or call 1-877-932-8228
Overview

The primary objective of this course is to provide an introduction to the PostgreSQL database. The course targets both administrators and developers.

Goals
  1. Learn about the history of PostgreSQL.
  2. Learn where to find PostgreSQL documentation and resources.
  3. Understand PostgreSQL Server Architecture.
  4. Learn about different popular PostgreSQL clients.
  5. Learn to work with PostgreSQL functions.
  6. Learn to create your own functions.
  7. Learn to program with plpgsql.
  8. Learn to install and setup PostgreSQL securely.
  9. Learn basic administration tasks such as user creation, cataloging and backing up.
  10. Learn about SLONY and PGPOOL.
  11. Understand inheritance in PostgreSQL.
  12. Learn to partition tables.
  13. Learn to use Tablespaces.
  14. Learn about database monitoring.
  15. Understand the EXPLAIN Statement
  16. Learn about PITR
  17. Learn to tune the Postgresql Server
Outline
  1. Intro and Architecture
    1. History and Overview
    2. PostgreSQL Major Features
    3. PostgreSQL Limits
    4. PostgreSQL Architecture
    5. MVCC
    6. Write Ahead Logs
    7. The Background Writer
    8. PostgreSQL Data Types
  2. Installation
    1. Overview
    2. Binary Installation
    3. Source Installation
    4. Initializing a PostgreSQL cluster
    5. Starting and stopping a PostgreSQL cluster
    6. Automatic startup/shutdown
    7. Lab
  3. Configuration
    1. Access Control
    2. Connection settings
    3. Security and Authentication settings
    4. Memory settings
    5. Kernel resource settings
    6. Log management
    7. Background writer settings
    8. Vacuum cost settings
    9. Autovacuum settings
    10. Lab
  4. Intro to psql
    1. Command line parameters
    2. Meta commands
    3. Security
    4. Lab
  5. Managing PostgreSQL Databases
    1. PostgreSQL Clusters
    2. PostgreSQL Databases
    3. Tables, Joins and Aggregates
    4. PostgreSQL Indexes and Foreign Keys
    5. Lab
  6. Roles and Security
    1. Schemas
    2. Tables, Views and Rules
    3. Users, Groups and Roles
    4. Tables and Sequences
    5. Object Security
    6. Lab
  7. Tablespaces, Partitioning and Advanced Features
    1. Vacuum
    2. Tablespaces
    3. Inheritance
    4. Table Partitioning
    5. Windowing Functions
    6. Transactions
    7. Concurrency Control
    8. Functions and Operators
    9. Type conversion
    10. Full text search
    11. Lab
  8. Moving Data with PostgeSQL
    1. Basic DML
    2. COPY
    3. Other Tools
    4. Lab
  9. Routine DBA Tasks and Best Practices
    1. Log Management
    2. Query analysis
    3. Routine Vacuuming
    4. Recovering disk space
    5. Managing Planner statistics
    6. REINDEX
    7. Lab
  10. Monitoring and Statistics
    1. Database Logs
    2. OS Process monitoring
    3. The PostgreSQL Statistics Collector
    4. Statistics Views
    5. Statistics Functions
    6. Lab
  11. Performance Tuning
    1. OS Tuning
    2. Hardware configuration
    3. Transaction logs
    4. Tablespaces and Partitioning
    5. Checkpoint tuning
    6. Query tuning
    7. Lab
  12. Backup and Recovery
    1. The pg_dump utility
    2. The pg_dumpall utility
    3. Recovery options
    4. Point In Time Revovery
    5. Lab
  13. PostgreSQL Upgrades
    1. The pg_upgrade utility
    2. RPM based upgrades
    3. Source based upgrades
    4. Replication based upgrades
    5. Rolling back
    6. Lab
  14. Replication and HA
    1. Streaming Replication
    2. Synchronous Replication
    3. Replication Slots
    4. Failover management
    5. Connection Poolers
    6. HA configurations
    7. Lab
  15. Triggers
    1. Overview
    2. Triggers
    3. Lab
  16. Event Triggers
    1. Overview
    2. Event Triggers
    3. Lab
  17. RULEs
    1. Overview
    2. SELECT Views
    3. Updating a View
    4. Materialized Views
    5. Rules and privileges
    6. Lab
  18. The PL/pgSQL Language
    1. Structure
    2. Declarations
    3. Expressions
    4. Statements
    5. Control Structures
    6. Cursors
    7. Errors and Messages
    8. Trigger Procedures
  19. Other Procedural Languages
    1. PL/Perl
    2. PL/Python
    3. More...
  20. PostgreSQL Contribs
    1. Overview of additionally supplied modules
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this PostgreSQL class:

  • Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

72,346

Students who have taken Live Online Training

15,155

Organization who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

8.52

Students rated our Introduction to PostgreSQL for Developers and Administrators trainers 8.52 out of 10 based on 3 reviews

Contact Us or call 1-877-932-8228