Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
PostgresSQL Setup and Configuration
Overview of PostgreSQL Architecture and Advanced Features
PostgreSQL Administration
- Connecting to the Database
- Overview of PgAdmin III
- Configuring the Server
- Setting up and Managing Users
- Overview of Database Object Types
- Setting Permissions & Security
- Querying the Database
- Monitoring the Database
- Ensuring Atomicity and Isolation
- Backing up and Restoring PostreSQL
- Migrating Data to Another System
- Working with PostreSQL Logs
Performance Optimization
- Reducing I/O with HOT
- Locking & Concurrency
- Evaluating the Design of the Database
- Optimizing SQL Queries with EXPLAIN
- Inspecting the Workload
- Benchmarking and Profiling
- Optimzing Joins
- Using Indexes Efficiently
PostgreSQL Replication
- Overview of PostgreSQL Replication
- High Availability in PostgreSQL
- Streaming Replication
- Managing Clusters Using repmgr
- Running Queries on Database in Hot Standby
- Synchronous Replication
- File based Log Shipping
- Trigger-based Logical Replication with Slony & Londiste
- Connection Pooling
- Upgrading PostgreSQL
- Sharding and Scaling PostgreSQL
Summary and Conclusion
Requirements
- Experience with SQL
- Experience with the Linux command line
- Experience with basic UNIX shell programming
Audience
- Database administrators
- Systems administrators
- Developers with database experience
35 Hours
Testimonials (7)
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
Piotr Romer - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
Amount (a lot) of knowledge provided. Cheerful aprroach to the subject.
Oskar Debowski - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
The exercises were very good, but I think the best part was that the instructor had personalized attention with each one of us. Everything was truly excellent!
Manuel Alberto Solis Zavala - Direccion de Informatica
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
THE COURSE MATERIAL AND THE PATIENCE OF THE INSTRUCTOR
Juan Manuel Castro Cota - Direccion de Informatica
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
Trainer is very approachable and shown expertise in Postgres both in admin and dev side. Acquired lots of learnings in this training. Also, Kahoot knowledge check games are fun.
Kristine - G-Xchange, Inc
Course - PostgreSQL Administration, Optimization and Replication
The comments on experiences beyond the theory were what I liked most, as they are practical cases already in work environments.
Hugo Celis Olvera - Total System Services de Mexico SA de CV
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
I liked that the instructor made it very practical, sharing his experience and the topics were very interesting. He would first give us the theory and then the practical exercises, which helped reinforce what we learned.
LIZBET CRISTINA BAUTISTA GOMEZ - Banco de Mexico
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
