+39 0574 159 3000PostgreSQL Immersion
The PostgreSQL Immersion course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; Advanced Development and Performance; and Backup & Disaster Recovery. This course has minimal prerequisites, making it ideal as a speedy introduction to PostgreSQL. It is suitable for a wide range of participants, such as: application developers with working knowledge of databases, system administrators, and database administrators having prior experience with any database software
Prerequisites
- Basics of databases
- Basics of SQL
- Basics of Systems Administration
- Basics of Application Design
Topics
- Introduction to PostgreSQL
- OmniDB
- Server Configuration
- Database Administration
- User Administration
- Understanding Database Object Types
- Monitoring
- VACUUM, Freezing & Avoiding Wraparound
- Managing Cloud Databases
- Server Architecture & Server Tuning
- Security
- Database Design Alternatives
- Advanced Development
- EXPLAIN and SQL Execution
- Workload Analysis
- Indexes
- Partitioning
- Replication Architecture
- Point-In-Time Recovery
- Logical Backup
- Logical Replication Overview
- Online Upgrade
- Bi-Directional Replication
- Replication Startup & Setup
- Disconnection & Reconnection
- Switchover, Failover & Failback
- Physical Streaming Replication & Hot Standby
- repmgr
- Physical Backup
- Barman
Acquired Skills
- Basics of PostgreSQL
- PostgreSQL Database Administration
- PostgreSQL Application Design
- PostgreSQL Tuning and Performance
- PostgreSQL Database Architecture
- Advanced PostgreSQL development
- PostgreSQL Replication
- PostgreSQL High Availability
- PostgreSQL Disaster Recovery
- Basics of PostgreSQL Scalability
Upcoming Training Courses
Trainings in London, United Kingdom
On hold until further notice due to COVID-19
Duration
Online Training: 10 days (4 hours/day)
Public Training: 5 days (All Day)
Tags: PostgreSQL, Administration, Backup and Disaster Recovery
