POSTGRE SQL DBA

Course Overview :

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet).

Course Content

• PostgreSQL System Architecture
• Transactions and Concurrency
• Performance Tuning
• Hardware, OS and Server Parameter Configuration
• Connection Settings and Memory Parameters
• Table Partitioning
• High Availability & Replication
• Connection Pooling
• Monitoring & Statistics
• Procedural Languages and PL/pgSQL
• Add on Utilities – Extension Modules
• 9.4 Release Highlights