PostgreSQL Essentials

Course code: PSQLE

Learn the essentials of administering enterprise-scale data solutions using the different tools available in PostgreSQL; providing the skills required to design, implement, and manage PostgreSQL This understanding will prepare you to install, configure, manage, and maintain PostgreSQL as well as manage large, highly available databases and their security requirements with confidence.


1 100 EUR

1 331 EUR including VAT

The earliest date from 11.11.2024

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 11.11.2024

Place : Praha

Type: In-person

Course duration: 4 days

Language: cz/sk

Price without VAT: 1 100 EUR

Register

Starting date: 10.02.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: 28.04.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: 09.06.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: 25.08.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: 13.10.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: 15.12.2025

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
11.11.2024 Praha In-person 4 days cz/sk 1 100 EUR Register
10.02.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
28.04.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
09.06.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
25.08.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
13.10.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
15.12.2025 In-person/Virtual 4 days en/cz 1 100 EUR Register
Upon request In-person/Virtual 4 days en/cz 1 100 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

Learn the essentials of administering enterprise-scale data solutions using the different tools available in PostgreSQL; providing the skills required to design, implement, and manage PostgreSQL This understanding will prepare you to install, configure, manage, and maintain PostgreSQL as well as manage large, highly available databases and their security requirements with confidence.


Course structure

  • Introduction and Architectural Overview
  • System Architecture
  • PostgreSQL Installation
  • User Tools – Command Line Interfaces
  • Database Clusters
  • Configuration
  • Data Dictionary
  • Creating & Managing Databases
  • Database Security
  • Monitoring and Admin Tools
  • SQL Primer
  • Backup, Recovery and Point-in Time Recovery
  • Routine Maintenance Tasks
  • Moving Data
  • Replication and High Availability Tools

Prerequisites

  • Basic experience in database administration
  • Intermediate knowledge of RDBMS concepts
  • Basic understanding of SQL
  • Basic experience with the use of the Linux operating system is helpful

 

Do you need advice or a tailor-made course?

onas

product support

Certification

This course includes 1 complimentary attempt/student at the PostgreSQL Associate certification exam/digital badge.

ComGate payment gateway MasterCard Logo Visa logo