Database Administration

This class covers the tasks that a database administrator faces daily, starting from basic operations to advanced techniques. Course notes use pgAdmin as the graphical administration tool.

Subject Areas Topics Course acquired skills

Software development

Systems administration

Connecting & Troubleshooting

pgAdmin III Overview

Server Configuration

Database Administration

User Administration

Understanding Database Object Types

Permissions & Security

Running SQL

Monitoring

MVCC and VACUUM

Maintenance

Data Migration & Test Environments

Server Logs

Help & Support

Basics of PostgreSQL database administration

PostgreSQL basics

Minimum prerequisites Course length

SQL Basics

Basic knowledge of databases

2 days

Course Price: USD$ 1550 | GBP£ 1000 | EUR€ 1200

© 2001-2014 2ndQuadrant Ltd. All rights reserved. | Privacy Policy