Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- PostgreSQL vs MySQL vs Oracle.
- Overview of PostgreSQL 13 features and architecture.
Getting Started
- Setting up a database server.
- Installing PostgreSQL 13.
- Creating and accessing a database.
- SQL syntax, commands, and functions.
Configuring a Postgres Database
- Data definition, default values, and constraints.
- Setting up and modifying tables.
- Managing privileges and security policies.
- Creating database schemas.
- Implementing table inheritance and partitioning.
- Adding, updating, and querying data.
- Data types, functions, and operators.
- Using indexes and running full-text search.
- Understanding concurrency control.
Managing a Database Server
- Upgrading a PostgreSQL cluster.
- Securing the server and encrypting data.
- Configuring server parameters.
- Enabling client authentication.
- Setting up access roles and permissions.
- Managing multiple databases.
- Performing database maintenance tasks.
- Backing up and restoring data.
- Optimizing database performance and reliability.
- Monitoring database activity and disk usage.
- Implementing logical replication.
- Running regression tests.
Client-Side Programming
- Using the libpq C library and large object interface.
- Executing embedded SQL statements.
- Exploring the information schema.
- Other PostgreSQL client applications.
Server-Side Programming
- Extending the SQL query language.
- Writing event trigger functions.
- Implementing rule systems.
- Using procedural languages (PLs).
- Exploring TCL, Perl, and Python PLs.
- Executing server programming interfaces.
- Examples of logical decoding.
- Tracking replication progress.
Troubleshooting
Summary and Next Steps
Requirements
- Familiarity with RDBMS concepts.
- Experience with SQL.
Audience
- System administrators.
- Developers.
21 Hours
Testimonials (2)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
