PostgreSQL5 - Comprehensive PostgreSQL Administration

Price: 
28 500 CZK
Vendor: 
EDB
Course length: 
5 dnů

Designed for database professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices, this special 1-week course teaches both Essentials and Advanced topics:

      Essentials

  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pgAdmin III
  • Security Basics
  • SQL Primer
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data

      Advanced Topics

  • Transactions and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Monitoring
  • Extension Modules

 

 

 

 

 

 

Upon course completion, you will be prepared to manage large, highly available databases and their security requirements with confidence.

Pre-requisites:  Basic experience in database administration. No prior knowledge of PostgreSQL is required.