PostgreSQL Database Administration

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

Prerequisites Topics Acquired skills

SQL basics

Basics of databases

• Introduction to PostgreSQL

• PgAdmin III Overview

• Server Configuration

• Database Administration

• User Administration

• Understanding Database Object Types

• Permissions & Security

• Running SQL

• Monitoring

• VACUUM, Freezing & Avoiding Wraparound

• Maintenance

• Basics of PostgreSQL database administration

• PostgreSQL basics

Tags: Software development, Systems Administration

Code: PGADMEN
Length: 2.00 days
Price: £ 1000

Upcoming related events


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.