PosgreSql Database Administration Module (CFG-TC03)
About this course
This course is designed for database professionals who are responsible for administration and maintenance of PostgreSQL, who want to increase proficiency and learn the best practices .
This special 2-days course teaches both foundational and advanced Postgres database administration topics. This immersive class offers hands-on experience with Postgres use cases based on years of field experience.
Upon completion of this course of this course you should be able to:
- Upon course completion, you will be prepared to successfully manage your mission critical PostgreSQL installations.
- Performing core administration tasks with confidence and skil
Database Administrator for Century Financials System.
Postgres System Architecture
Getting Started – installation, setting environmnet, variables, creating a cluster, connecting to the server.
Configuration – connection, authentication,
WAL, log, vacuum settings and more
Creating and Managing Databases
Object, hierarchy, databases, schemas, roles,
users, groups and access control
Introduction to PSQL
Basic conventions, commands and parameters.
Using pgAdmin III
Configuration, access control, ownership, etc.
Data types, basic queries, functions, constraints,
views, sequences, indexes
Backup and Recovery
backup types and strategies
Point-in Time Recovery
Query plan, table
Statistics, vacuuming, re-indexing, and more
Postgres Data Dictionary
Performance tuning & Monitoring