This course covers the tasks that a database administrator faces daily, from basic operations to intermediate techniques. The course uses OmniDB as the graphical administration tool and is suitable for system administrators and for database administrators with expertise on other database systems.

Topics

• Introduction to PostgreSQL
• OmniDB
• Server Configuration
• Database Administration
• User Administration
• Understanding Database Object Types
• Permissions & Security
• Monitoring
• VACUUM, Freezing & Avoiding Wraparound
• Managing Cloud Databases
• Maintenance

Prerequisites

• Basics of databases
• Basics of SQL

Acquired Skills

• Basics of PostgreSQL
• PostgreSQL Database Administration

Date & Time: 16-20 March 2020 (daily from 4pm - 6pm UTC)

View Terms & Conditions.