Advanced PostgreSQL

This course Advanced PostgreSQL gives you a unique opportunity to get trained and certified on advanced database administration for PostgreSQL. Learn how to best fulfill the more advanced DBA responsibilities including security, database tuning and benchmarking, monitoring, setting up high availability and replication, and more.

Level

intermediate

Course length

5 days

Language

Course code

KT22010072

Order

Category:

Database PostgreSQL

Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term

Language

Place

Form

Price without VAT

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT22010072-0002

Price without VAT

2 400,00 €

Order

Course description

This course is designed for DBAs, Architects, and Database Professionals who are responsible for ongoing and advanced administration and maintenance of PostgreSQL, including implementing strategic database solutions for the enterprise.

Required knowledge

We recommend taking Foundations of PostgreSQL prior to this course.

Target audience

This course is intended for DBAs and IT Professionals who want to enhance their Postgres administration skill to the next level.

Course content

Postgres Advanced Server System Architecture and Installation
Database Objects and Hierarchy
Configuration Settings and Parameters
User Tools for Administration – Command Line and Graphical
Tablespaces – Creating and Managing
Users, Groups, and Assigning Privileges
Security Settings
Data Loading
Transactions and Concurrency
Routine and Proactive Maintenance Tasks
Backup, Recovery, and Point In Time Recovery
Performance Tuning
Moving Data
Data Dictionary

Certification

The training will prepare you for the PostgreSQL Professional Certification exam.

Materials

Hands-on labs
Study materials

Do you want this tailor-made course for your company?

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news

Do you want this tailor-made course for your company?

News with the course

Database 7. 4. 2021

Database systems trainings

More news

Advanced PostgreSQL

Courses with lecturer

Course description

Required knowledge

Target audience

Course content

Certification

Materials

Do you want this tailor-made course for your company?

News with the course

Do you want this tailor-made course for your company?

News with the course

Why with us