Show all

PostgreSQL Administration

This course is intended for beginning and intermediate users and administrators who will learn everything needed to use this database system effectively and will also prepare students for the daily management of PostgreSQL databases, backup, recovery, replication, monitoring and optimization. 
Level
Designed for participants with basic knowledge and experience
intermediate
Course length
3 days
Language
 cz  eu
Course code
KT21010080
PostgreSQL
Category:
Do you want this tailor-made course to your company? Contact us

Courses on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
9. - 11. 9. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010080-0024
Price without VAT
16 000 Kč
11. - 13. 11. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010080-0022
Price without VAT
16 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010080-0005
Price without VAT
16 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010080-0006
Price without VAT
16 000 Kč

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 

Lecturers

David Solnař
David Solnař

Freelance Consultant and Trainer Oracle, SQL Server, MySQL, .NET, WPF, ASP.NET

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

Contact us

Follow-up courses

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

Contact us

Why with us