PostgreSQL Administration

Focus on Training
Course summary
Next available date: - United Kingdom
Professional Training

Course description

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.

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

Who will the Seminar Benefit?

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.

About provider

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...

Read more and show all courses with this provider

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here