The EDB Blog

February 3, 2014

February marks an important development in EnterpriseDB’s expansion in India, where the use of open source software has been rising as technology buyers seek solutions with low upfront deployment costs. At a cost that is 80% or more less than traditional alternatives, Postgres represents significant savings.

Our uptake with enterprises like inMobi, the largest mobile ad platform and longtime EnterpriseDB customer, and large systems integrators, like Wipro and Tata Consultancy Services, as well as government organizations like the National Informatics Centre, have propelled Postgres to the forefront in India.

To help our users master their deployments and support the growing demand for expertise, we’re staging a five-day classroom training event, PostgreSQL Administration, in Bangalore Feb. 24-28.

For information and to register, please visit: http://bit.ly/1ioSlq8

The course will be taught by an EnterpriseDB professional certified in PostgreSQL and well-versed in other database environments. The course also provides a path toward certification and it includes one free attempt at the qualifying exam.

Course Outline

EnterpriseDB’s PostgreSQL Administration class will cover the following key components of database mastery over five days:

PostgreSQL Introduction & Architecture 
Get an introduction to the features of the PostgreSQL database. You will gain a conceptual understanding of PostgreSQL database architecture and how its components work and interact with one another.

Installation & Configuration
Database administrators will learn techniques for installing and configuring PostgreSQL, with practical tips to help ensure a successful PostgreSQL install in your environment. You’ll get instruction on how to configure the server parameter file (postgresql.conf) and all of the important parameters for preparing a PostgreSQL instance for production.

Create, Manage & Secure the PostgreSQL Database
Learn how to create a database and properly manage the various structures in an effective and efficient manner. A detailed explanation of PostgreSQL host-based authentication will prepare you for implementing different security modes in PostgreSQL.

Managing PostgreSQL using PSQL and PGADMIN III  
Get an overview of the PSQL Console and the PGADMIN III GUI, which can be used to manage and monitor multiple PostgreSQL database instances from a single GUI interface.

Introduction to SQL Primer & Moving Data – PostgreSQL Structured Query Language (SQL)
This is a hands-on introduction to SQL Basics including an overview of relational databases and instructions on how to access them through SQL Commands. You’ll also learn how to export and import table data to and from a file.

PostgreSQL Backup and Recovery
Designed for technical support and DBAs, you’ll learn how to back up PostgreSQL databases using different techniques, evaluate recovery requirements and develop an appropriate strategy for backup and recovery procedures. You’ll learn how to implement Point-in-Time Recovery as well.

Transactions & Concurrency
This course will give you an understanding of PostgreSQL's core MVCC functionality. Learn how to implement transaction isolation and gain an understanding of how PostgreSQL implements locking.

Performance Tuning & Routine Maintenance Tasks
Learn a number of 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. You’ll learn techniques for proactive and reactive database maintenance as well.

High Availability & Replication
The material will address how to use PostgreSQL Streaming Replication to perform data replication activities between PostgreSQL database systems. Attendees will also learn how to use Slony for implementing asynchronous trigger-based replication between different PostgreSQL database instances.

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 course covers the "what, why, when and how" aspects of table partitioning.

PostgreSQL Data Dictionary, Monitoring & Postgres Enterprise Manager
You’ll learn how to view monitoring information stored in PostgreSQL Data Dictionary tables. This course also covers how to install and configure the Postgres Enterprise Manager console so you can use this enterprise-class tool to monitor all aspects of your enterprise servers from a single interface.

Procedural Languages
This course will teach you how to compile PL/pgSQL programs, update, insert and delete data and define and execute functions. You’ll get an understanding of advanced PL/pgSQL features, such as how to take advantage of error reporting, cursors and triggers.

Add On Utilities
The course will also cover PostgreSQL extensions and teach you how to install and manage various extensions previously known as contrib modules.

This class in Bangalore, which covers both introductory and advanced PostgreSQL material, marks the second live training event we’ve held in India to support the expanding Postgres marketplace. A class staged in Pune was wildly successful and we expect the momentum to continue, with many events to come. Stay tuned.

For more information on the course or to register, please visit: http://bit.ly/1ioSlq8

Fred Dalrymple is a Product Manager at EnterpriseDB.

A former EDB Product Manager, Fred was responsible for marketing and product management of Postgres Plus Cloud Database and Training. He is an accomplished software professional experienced in many domains, including online content and publishing, eCommerce, and storage, with a proven ability to...