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
Testimonials (5)
What I liked most was the presenter's approach. Everything is great, I am very satisfied. Of course, with satisfaction comes a huge amount of new knowledge.
Olek - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
good interaction
Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
What I liked the most was the exercise parts.
Remigiusz - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
Machine Translated
atmosphere, interesting examples
Robert - Asseco Poland S.A
Machine Translated
Topics and their comprehensive practical discussion.
Walentyn Weremejenko - Asseco Poland S.A
Machine Translated