PostgreSQL Immersion Training

PostgreSQL
Event Start Date & Time
2017-11-13 10:00:00 AM
Event End Date & TIme
2017-11-17 05:00:00 PM

PostgreSQL (Postgres) the most powerful, open source object-relational database system, which runs on all major operating system and fully ACID compliant, is now heavily used by Government and Industries. A vast majority of enterprise applications developed by the Government of Kerala, including the much appreciated KSEB relies on Postgres. A number of cases are reported on plans for migration to Postgres as a major initiative based on the recent Open Source policies of central and state governments. This requires a major capacity building efforts on Postgres within various departments of government.

ICFOSS, mandated to ensure appropriate capacity building and ecosystem mentoring in open source technologies to support the major initiatives of the Government of Kerala is organizing a five day intensive workshop on Postgres for government employees and startups.

Call for Nominations & Selection process

ICFOSS requests all government departments to nominate one or two persons (Database administrators, systems administrators, or developers with working knowledge of database usage) as per the prerequisite given below:

Prerequisite: must have a working knowledge of SQL. Using the command line interface to a Linux system and some basic UNIX shell programming experience is needed to complete all of the replication workshop exercises.

The nominated candidates shall undergo a pre-work / evaluation (based on database skills) on 9th November. The final selection for workshop shall be based on the performance in this evaluation.

Finally selected candidates shall undergo the workshop at ICFOSS premises from 13th till 17th, November, 2017.

Participants shall undergo an evaluation on 17th, November, 2017 and successful candidates shall receive a certificate on Postgres Immersion Level I, jointly certified by ICFOSS and 2nd Quadrant. while others will only receive a participation certificate.

Subject Areas

Topics

Introduction to PostgreSQL 9 Database Administration

Connecting & Troubleshooting

PgAdmin III Overview

Server Configuration

Database Administration

User Administration

Understanding Database Object Types

Permissions & Security

Running SQL

Monitoring

MVCC and VACUUM

Maintenance

Data Migration & Test Environments

Server Logs

Help & Support

Advanced Development & Performance Summary

Server Architecture & Caching

Tuning Parameters

MVCC, VACUUM and HOT

Locking & Concurrency

Database design alternatives

Advanced Development Summary

Reading EXPLAINs

Workload Analysis, Benchmarking and Profiling

Join Planning

Indexes

SQL Performance Tips & Tricks

PostgreSQL 9 Replication & Recovery Concepts

pg_dump and restore options

PITR Backup and Recovery

Replication Concepts

High Availability options

Streaming Replication

Managing clusters using repmgr

Hot Standby

Synchronous Replication

File based Log Shipping

Introduction to Slony & Londiste

Connection Pooling

Upgrading PostgreSQL

Sharding and Scale Out

 

Minimum prerequisites

Course length

Participants must have a working knowledge of SQL. Using the command line interface to a Linux system and some basic UNIX shell programming experience is needed to complete all of the replication workshop exercises.

Who should attend

Database administrators, systems administrators, or developers with working knowledge of database usage.

5 days

 Click here for registration