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.
Course Objectives
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
Target Audience
Database Administrator for Century Financials System.
Course Outline
Day 1
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
Security Basics
Configuration, access control, ownership, etc.
Day 2
SQL Primer
Data types, basic queries, functions, constraints,
views, sequences, indexes
Backup and Recovery
backup types and strategies
Point-in Time Recovery
Routine Maintenance
Query plan, table
Statistics, vacuuming, re-indexing, and more
Postgres Data Dictionary
Moving Data
Performance tuning & Monitoring