PostgreSQL Database Administration

Learn tasks that a database administrator faces daily, from basic operations to managing mission-critical databases.

What you will learn

  • Introduction to PostgreSQL
  • Database & User administration
  • Security Permissions
  • Understand Object Types
  • Manage Cloud Databases
  • Configure database server
  • Database management using OmniDB
  • Use of VACUUM, Freezing & Avoiding Wraparound
  • General Monitoring and Maintenance

Skills you will gain

Administration Management Monitoring Server Configuration Authentication Maintenance

About This Course

This course covers the tasks that a database administrator faces daily, from basic operations to managing mission-critical databases. OmniDB is the chosen graphical administration tool. Course is suitable for system administrators and for database administrators with expertise on other database systems.

Prerequisites

  • Basics of databases
  • Basics of SQL

Duration

Online Training: 5 days (2 hours/day)

Public Training: 2 days (All Day)

Tags: PostgreSQLAdministration