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.
Introduction to PostgreSQL 9 Database Administration
Connecting & Troubleshooting
PgAdmin III Overview
Understanding Database Object Types
Permissions & Security
MVCC and VACUUM
Data Migration & Test Environments
Help & Support
Advanced Development & Performance Summary
Server Architecture & Caching
MVCC, VACUUM and HOT
Locking & Concurrency
Database design alternatives
Advanced Development Summary
Workload Analysis, Benchmarking and Profiling
SQL Performance Tips & Tricks
PostgreSQL 9 Replication & Recovery Concepts
pg_dump and restore options
PITR Backup and Recovery
High Availability options
Managing clusters using repmgr
File based Log Shipping
Introduction to Slony & Londiste
Sharding and Scale Out
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.
Click here for registration