Introduction to PostgreSQL (4 days)
What is it about?
During the training, participants will learn how to securely install, configure, monitor, and operate PostgreSQL-based systems in an enterprise environment. The course strikes a balance between theoretical background and practical examples, thereby preparing participants for day-to-day administrative tasks as well as for building highly available and secure database infrastructures.
Who is this course recommended for?
We recommend this course primarily to professionals working in the following fields:
-
For database administrators (DBAs)
-
For IT professionals who want to operate, configure, or maintain PostgreSQL
-
For those who want to manage high-availability databases
-
For developers and systems engineers who work with systems built on PostgreSQL
Prerequisite for starting the course:
The training is not tied to any specific degree, but a degree in computer science (at the high school or college level) is an advantage. Basic experience in database administration is recommended, as is intermediate knowledge of relational database management systems (RDBMS) (knowledge of PostgreSQL is a plus but not required), and a basic understanding of the SQL language. Basic knowledge of the Linux operating system (not required, but a plus)
Planned topics for the course
- Introduction and Architectural Overview – The Role, Components, and Operational Model of PostgreSQL
- System Architecture – Process Model, Memory Usage, Storage Structures
- Installation – Installing PostgreSQL on various platforms
- User Tools – Command-Line Interfaces – Using psql, pgAdmin, and Other Tools
- Managing Database Clusters – Structure, Initialization, and Cluster-Based Operation
- Configuration – Overview of key configuration files, performance tuning
- Data Dictionary – Querying and Interpreting Metadata
- Creating and Managing Databases – Managing Users, Schemas, and Permissions
- Database Security – Access Control, Authentication Methods
- Monitoring and Administration Tools – Performance Monitoring, Logging, Diagnostics
- SQL Basics – SELECT, INSERT, UPDATE, DELETE Basic Operations
- Backup and Restore – Full Backup, PITR (Point-in-Time Recovery)
- Routine maintenance tasks – VACUUM, ANALYZE, log rotation
- Data Transfer – Import/Export, COPY, pg_dump, pg_restore
- Replication and High Availability – Streaming replication, failover capabilities, HA tools
Information about course dates can be found here. If you are interested in on-site or customized courses, would like to register for our courses, or would like to receive a quote, please contact us at training@ulx.hu and/or call us at +36 1 450 0921.