Workshop (WDB14)

PostgreSQL Administration

DURATION: 40 hours

Content:

PostgreSQL architecture and connectivity
Lock and concurrency considerations
Creation and maintenance of databases
Disk space management
Implementing techniques to improve the performance of the environment
Backup and restore of databases and transaction logs
Understanding the transaction log (WAL) and automatic recovery
PostgreSQL settings
Memory management – Shared Buffer and Kernel Buffer
Managing security – access permissions, logins, users, groups and roles
Utilities for PostgreSQL administration
Working with extensions
Checking data integrity
Monitoring and problem identification
Configuring replication strategies and clusters

Recommended for:

Database administrators (DBAs), system administrators, developers and professionals responsible for maintaining and managing the PostgreSQL operating environment

Skills acquired:

-Overview of PostgreSQL’s internal architecture and connectivity aspects between clients and server
-Identification of the need for adjustment in the settings of the main product parameters
-Knowledge of the best database creation and maintenance techniques and their respective objects, taking into account aspects of space allocation and management
-Base to define and implement routines and procedures for managing security (logical and physical) and ensuring data integrity
-Plan and implement backup and restore routines according to the needs of each environment
-Techniques for quick problem identification

Prerequisites::

-Knowledge of SQL language
-Knowledge of relational database design concepts
-Basic knowledge in some database management system
-Knowledge of Linux and/or Windows environment

Duration:

5 days (9am to 6pm)

Are you interested or want to receive more information? Fill in the form to the side