PostgreSQL Administration

Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
This PostgreSQL Administration course covers administration, maintenance, security and performance tuning of PostgreSQL databases.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Objectives
The delegate will gain an understanding of:
- Install PostgreSQL
- Create a database
- Manage roles and privileges
- Manage schemas
- Transaction handling and concurrency
- Examine statistics and system tables
- Manage tablespaces
- Scale PostgreSQL using table inheritance and partitioning
- Understand error reporting and logging
- Security features of PostgreSQL
- Encrypt sensitive data
- Carry out periodic maintenance with Autovacuum
- Backup and recover databases
- Create indexes to improve table access
- Optimize queries and indexes
- Configure settings for increased performance
- Populate a new database efficiently
- Set up asynchronous and synchronous replication
Target Audience
This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL databases. This course is suitable for users of both PostgreSQL 9 and 10 databases.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
This course assumes a good working knowledge of SQL and specifically of the SELECT, INSERT, UPDATE and CREATE TABLE statements. This can be obtained by attendance on the pre-requisite SQL for PostgreSQL course.
This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
SQL for PostgreSQL
This 3-day course provides the skills required to use SQL to manipulate data held in a PostgreSQL database and to progress their SQL skills beyond the basics.
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Code | Location | Duration | Price | May | Jun | Jul | Aug | Sep | Oct |
---|---|---|---|---|---|---|---|---|---|
PSQLADM |
Virtual Classroom (London)
|
5 Days | $2,395 |
|
|
|