Courses with lecturer

Term

Language

Place

Form

Price without VAT

17. - 19. 2. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010080-0025

Price without VAT

16 000 Kč

Order

28. - 30. 7. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010080-0026

Price without VAT

16 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010080-0005

Price without VAT

16 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010080-0006

Price without VAT

16 000 Kč

Order

Target audience

IT specialists who want to learn how to effectively manage the PostgreSQL database system.

Course content

PostgreSQL database system architecture
Introduction to administration - installation, cluster creation, connection to the server
Configuration - connection, authentication, WAL, log and other settings
Creation and administration of databases - databases, schemas, roles, users, groups
Using pgAdmin
Security basics - configuration, access control, ownership
SQL Primer - data types, basic queries, functions, constraints, views, indexes
Maintenance - Query plan, statistics, vacuum, index maintenance
Transactions and competitive approach
Extension modules
Data transfer
Backup and recovery - backup types and strategies
Point in Time Recovery
High availability and replication
Monitoring
Performance tuning

Materials

Materials are in electronic form.

Objectives

Understand the architecture of the database system
Perform installation and implementation of the database system
Necessary and recommended steps leading to optimal configuration
Create and manage databases
Use custom command line tools and GUI
Properly configure and ensure the required level of security
Use help and illuminate basic concepts
Theory and practical implementation of backup and recovery of databases
Maintenance tasks to ensure efficient system operation
Perform data moving
Understand metadata

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