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.
コース概要
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
要求
- 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 時間
お客様の声 (5)
一番気に入ったのは、チューターのアプローチです。すべてが素晴らしく、大満足です。もちろん、満足の後には膨大な量の新しい知識が待っています。
Olek - Asseco Poland S.A
コース - PostgreSQL Administration, Optimization and Replication
Machine Translated
良い交流
Asseco Poland S.A
コース - PostgreSQL Administration, Optimization and Replication
Machine Translated
エクササイズの要素は最も楽しめた。
Remigiusz - Asseco Poland S.A
コース - PostgreSQL Administration, Optimization and Replication
Machine Translated
雰囲気、興味深い例
Robert - Asseco Poland S.A
Machine Translated
トピックとその包括的な実践的なディスカッション。
Walentyn Weremejenko - Asseco Poland S.A
Machine Translated