PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!
Students taking this PostgreSQL Administration training class will learn to effectively administer PostgreSQL.
Delegates will learn
- to compile source code.
- about backup and disaster recovery.
- about inheritance, partitioning, and Tablespaces.
- to manage free space.
- about security in PostgreSQL.
- to create high availabilty and high performance solutions.
PostgreSQL Introduction & Architecture
PostgreSQL Data Types
Introduction to psql
Functions & Operators
Managing PostgreSQL Databases
PostgreSQL Roles and Security
Moving Data with PostgreSQL
Tablespaces, Inheritance and Data Partitioning
Transactions & Concurrency Control
Routine DBA Tasks and Best Practices
Monitoring and Statistics
PostgreSQL Tools Overview
PostgreSQL Performance Tuning
PostgreSQL Backup and Recovery
PostgreSQL Upgrade Methods
PostgreSQL Streaming Replication
PostgreSQL High Availability
PostgreSQL and AWS
PostgreSQL RDS Overview
PostgreSQL Redshift Overview
The PostgreSQL Contribs
|Capacity||Max 12 Persons|
|Training Type||Classroom / Virtual Classroom|