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.
コース概要
What is PostgreSQL?
- A Brief History of PostgreSQL
- Conventions
- Further Information
- Bug Reporting Guidelines
Introduction to PostgreSQL
- Installation and Creating Database
- The SQL Language
- Advanced Features
The SQL Language
- SQL Syntax
- Data Definition
- Data Manipulation
- Queries
- Data Types
- Functions and Operators
- Foreign Data Wrappers
- Type Conversion
- Indexes
- Triggers
- Full Text Search
- The Information Schema
- PL/pgSQL - SQL Procedural Language
- Concurrency Control
- Performance Tips
- How the Planner Uses Statistics
Server Administration
- Source Code vs Distribution-Provided Packages
- Installation from Source Code
- Installation from Source Code on Windows
- Deployment of Binaries Obtained by Compiling Source Code
- Server Setup, Operation
- Database Physical Storage
- Filesystem Durability Requirements and Required Mount Options
- Server Configuration
- Special Considerations for Container-Based Deployments
- Client Authentication
- Database Roles
- Managing Databases
- Localization
- Routine Database Maintenance Tasks
- Backup and Restore
- Recovery Configuration
- Monitoring Database Activity
- Monitoring Disk Usage
- Reliability and the Write-Ahead Log
- Regression Tests
- Installation of Third-Party Server Extensions
High Availability, Load Balancing, and Replication
- Brewer's CAP Theorem
- Synchronous vs Asynchronous Replication
- Log Shipping (Warm Standby)
- Streaming Master-Slave Replication (Hot Standby)
- Trigger-Based Master-Slave Replication with Slony
- Trigger-Based Multi-Master Replication with Bucardo
- Connection Pooling and Synchronous Replication with Pgpool
- Failover Configurations using DRBD
- Replacing a Failed Server
- Recovering from Network Partition
要求
A basic working knowledge of SQL
14 時間
お客様の声 (5)
The training was interactive which made it interesting.
Priyanka Talwar - University of South Australia
コース - PostgreSQL for Administrators - 2 Days
素晴らしいラボのセットアップ。非常に実践的なトレーニングで、教材が強化された。
Brian - Verizon Connect
コース - PostgreSQL for Administrators - 2 Days
Machine Translated
トレーナーによる実践的な演習と提案。
Bruno - Verizon Connect
コース - PostgreSQL for Administrators - 2 Days
Machine Translated
トレーナーの高いプロ意識、豊富な知識、参加者との協力、豊富な例の選択。
Sławek
コース - PostgreSQL for Administrators - 2 Days
Machine Translated
トピックの理解に問題がある場合は繰り返します。
Łukasz
コース - PostgreSQL for Administrators - 2 Days
Machine Translated