PostgreSQL Training – India

PostgreSQL – India

A course for PostgreSQL DBAs and aspiring DBAs, designed by our panel of on field DBAs. The training will be delivered by one of our Solution Architects or Database Administrators who are working hands-on in field in customer implementation, tuning, health check, Oracle Migration, HA and DR setups. The courses’ content will have extensive sample and exercises. Training material itself will be one of the important take away for attendees. The courses are designed keeping in mind various production experiences and challenges faced by our own experts. These training provide you with a great opportunity to interact with our experts and learn from their own experiences. Currently, these are available only in India.

Our PostgreSQL Training is delivered under following modules – choose the most relevant one, based on your expertise and need:

1. Technical Training for PostgreSQL Database Administration

This course includes basics of RDBMS and fundamentals of PostgreSQL, two very important aspects for aspiring PostgreSQL DBAs and PostgreSQL DBAs in transition. The course covers essentials of PostgreSQL Administration which would help learners to perform their duties as a PostgreSQL DBA. It is recommended to have a knowledge of SQL and Linux for effective learning.

Course covers following topics in depth (Duration – 3 days):

  • Basics of Relational Database
  • Introduction to PostgreSQL
  • Architecture of PostgreSQL
  • Getting started – Installation and Configuration
  • Client Access
  • Understanding Security Architecture of PostgreSQL
  • Performing DBA essential tasks
  • Logical Backup and Bulk loading
  • Physical Backup and Recovery

 

Recommended for: Individuals and professionals who want to administer and maintain PostgreSQL. No prior knowledge of PostgreSQL is required to attend this class.

Pre-requisites: Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

Learnings from the course: You will be able to handle installation and configuration of PostgreSQL more confidently. You will be better placed to design security policy for your database and application access and design the backup and maintenance policies of the database.

2. Advanced Technical Training for PostgreSQL Administration

This course prepares DBAs to perform more complex Admin tasks and manage large, highly available databases with confidence.

Requires participants to be well versed with basics of PostgreSQL proficient in regular PostgreSQL DBA functions. It is highly recommended to undergo ‘Technical Training for PostgreSQL’ course prior to taking up Advanced Technical Training for PostgreSQL.

Course covers following topics in depth (Duration – 2 days):

  • Fundamentals and Basics
  • Transactions Isolation and Concurrent access
  • Introduction to Basics of PL/pgsql
  • Performance Sizing and Tuning
  • Monitoring PostgreSQL
  • Connection Pooling and Middleware Tools
  • DR and HA Setup with PostgreSQL
  • PostgreSQL Extension and FDW

 

Recommended for: IT Professionals who want to enhance their Postgres administration skills to the next level.

Pre-requisites: Participants should be proficient in regular Postgres DBA functions. It is highly recommended to undergo ‘Technical Training for PostgreSQL’ course prior to taking up Advanced Technical Training for PostgreSQL. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

Learnings from the course: You will be able to handle sizing, tuning, troubleshooting and monitoring of PostgreSQL databases in your environment. You will be better placed to setup and manage HA setups.

3. Technical + Advanced Technical Combined Training for PostgreSQL Administration

This course is a combination of ‘Technical Training’ and ‘Advanced Technical Training’. It will enable those who are new to PostgreSQL to learn basics and get started on advanced topics e.g. replication, backup recovery. This training will enable attendees to perform daily tasks as PostgreSQL DBA and gain confidence in handling larger Postgres deployments. It is recommended to have a knowledge of SQL and Linux for effective learning.

Training Requisites

For all training sessions, candidates are requested to bring along their own laptop* with a minimum of below configurations:

– Red Hat or CentOS 6.6 Installed
– 4 GB RAM
– 20 GB Hard Disk
– 4 Computing Core

* This will aid candidates in retaining the environment that will be set up during the hands-on training.

Alternatively, for candidates using a laptop hosting Windows/Mac OS :

– Candidates can create Virtual Machines running CentOS/Red Hat 6.6.
– Candidates can raise a request with us for Cloud Instance and we will provide them with a Cloud Setup which they can connect using Putty and WinSCP

Other system requisites :

– The laptop used by the candidate should be able to connect to internet via wifi
– The laptop should have a pdf reading software
– The Windows laptops should have Putty and WinSCP installed on it

Why train with Ashnik?

  • We are not just a training or education firm, we are an Open Source solutions and services company. The training content and delivery is beyond an introduction to technology – it is more of an enablement for the attendees looking to adopt and deploy PostgreSQL in their environment
  • The course is built by our DB Consultants and Solution architects who have worked on real life projects. Hence it is not merely a theoretical module but is based on real project implementation and resolved challenges.
  • Course will be delivered through real implementation concepts by a Senior Solution Architect, actively involved in projects at Stock Exchange, Security Depository, Insurance firms.
  • Additional advantage of having an offline chat with the trainer during breaks, post-training hours to discuss queries

Enrol for our PostgreSQL Training

Book a Seat