Advanced PostgreSQL Administration – Part II of New Training Rollout

November 25, 2013

Part II of our new and improved training program continues with a revamped and refreshed on-demand version of our Advanced PostgreSQL Administration training course. The first part of our new initiative to make training programs more dynamic and interactive was the topic of my November 11 post and it marked the release of our new and improved Introduction to PostgreSQL training course. Our new approach to training calls for creating individual modules around core functions and capabilities. This replaces the production of a single, long recording that users must replay and search when trying to revisit specific material. We’ve also added more features and hands-on exercises. We will be integrating more interactive features in future classes. Registration in the class provides access for six weeks to nine individual instruction modules, each providing instruction on a specific topic. This way, users can hone in on specific modules and revisit course materials more easily. The following is a breakdown of the individual modules in our new Advanced PostgreSQL Administration training:

Introduction & PostgreSQL System Architecture This module provides a full introduction of the features of a PostgreSQL database. Gain a conceptual understanding of PostgreSQL database architecture and how its components work and interact with one another.

Transactions & Concurrency Learn about core MVCC functionality of PostgreSQL and how to implement transaction isolation. Users will see how PostgreSQL implements locking. This module features hand-on exercises to reinforce the material.

Performance Tuning & Routine Maintenance Tasks This module introduces practical, safe and highly efficient ways to optimize performance for the PostgreSQL Server. Users will explore performance issues affecting the design of the database and applications using the database, major database performance parameters, and the different tools that assist in performance monitoring and tuning. This module also covers proactive and reactive database maintenance. Hands-on exercises reinforce the material.

High Availability & Replication Learn how to use PostgreSQL Streaming Replication to perform data replication activities between PostgreSQL database systems. Also learn how to use Slony for implementing asynchronous trigger-based replication between different PostgreSQL database instances. Hands-on exercises reinforce the material.

Table Partitioning Using partitioning tables is an essential skill for designing and managing big data volumes. Partitioning has many additional features over normal table management. This module covers the "what, why, when and how" aspects of table partitioning.

Connection Pooling Opening and maintaining a database connection for each user has an overhead on PostgreSQL instances, which can be reduced by connection pooling. This module covers different tools and techniques used for database connection pooling.

PostgreSQL Data Dictionary, Monitoring & Postgres Enterprise Manager Learn how to view monitoring information stored in PostgreSQL Data Dictionary tables. Also learn how to install and configure the Postgres Enterprise Manager console to use this enterprise-class tool to monitor all aspects of your enterprise servers using this single interface. Structured hands-on lab exercises reinforce this material.

Procedural Languages Learn how to Compile PL/pgSQL programs, update, insert, and delete data and define and execute functions. Gain an understanding of advanced PL/pgSQL features, such as how to take advantage of error reporting, cursors and triggers.

Add On Utilities This module will cover PostgreSQL Extensions and teach you how to install and manage various extensions previously known as contrib modules.

Marc Linster is Vice President, Professional Services, at EnterpriseDB.

Share this

Relevant Blogs

EDB Postgres Advanced Server 15 TPS Benchmark

Overview There is often a need to increase the count of user-base connected to an application mainly due to business requirements due to factors such as business growth and addition...
August 22, 2023

More Blogs

Solving the Cloud Database Investment Mystery

Moving databases to the cloud is currently one of the most popular IT activities in enterprises around the world. According to Gartner, spending on cloud databases is outpacing on-premises...
January 15, 2023