PostgreSQL Bespoke Certificate for Mihaela Arcip
Add to LinkedIn
Certificate ID:
753507
Authentication Code:
0550f
Certified Person Name:
Mihaela Arcip
Trainer Name:
Michał Kuna
Duration Days:
4
Duration Hours:
28
Course Name:
PostgreSQL Bespoke
Course Date:
5 February 2024 10:00 to 8 February 2024 17:00
Course Outline:
Performance Tuning
- Operating System Best Practices
- Server Parameter Tuning
- Extension – pg_stat_statements
- Demo and Labs
Benchmarking
- Database Benchmarking
- Pgbench
- Reading the Results
- Demo and Labs
- 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