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.