PostgreSQL 16 for Developers and Administrators

• Basic knowledge of SQL
• Familiarity with database concepts

Audience

• Database administrators
• Database developers
• System administrators

PostgreSQL is a powerful, open-source relational database management system (RDBMS) known for its robustness, extensibility, and standards compliance. It is designed to handle a wide range of workloads, from small single-machine applications to large Internet-facing applications with many concurrent users.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and administrators who wish to leverage the latest features and improvements in PostgreSQL 16.

By the end of this training, participants will be able to:

• Understand the architecture and components of PostgreSQL 16.
• Utilize advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls.
• Perform database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Utilize PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to PostgreSQL 16

• Overview of PostgreSQL
• New features in PostgreSQL 16
• Installation and setup
• PostgreSQL architecture and components

Getting Started with PostgreSQL

• PostgreSQL database cluster setup
• Creating and managing databases
• Basic SQL operations
• Setting up and exploring PostgreSQL 16

Advanced SQL Techniques

• Advanced querying techniques
• Common table expressions (CTEs)
• Window functions
• JSON and JSONB data types
• Writing advanced SQL queries

Data Types and Extensions

• Custom data types
• Full-text search
• PostGIS for geospatial data
• PL/pgSQL programming
• Using advanced data types and extensions

Indexing and Query Optimization

• Index types and usage
• Query planning and execution
• Analyzing and optimizing queries
• Indexing and query optimization

Performance Tuning

• Performance tuning parameters
• Memory and resource management
• Monitoring and analyzing performance
• Performance tuning and monitoring

Backup and Recovery

• Backup strategies
• Point-in-time recovery
• Logical and physical backups
• Performing backup and recovery

Security and Access Control

• Authentication and authorization
• Role management and permissions
• Encryption and SSL/TLS setup
• Implementing security best practices

High Availability and Replication

• Replication concepts and types
• Setting up streaming replication
• Configuring high availability with Patroni
• Implementing replication and high availability

Integrating PostgreSQL with Applications

• Connecting PostgreSQL with various programming languages
• Using PostgreSQL in modern application frameworks
• ORMs and PostgreSQL
• Integrating PostgreSQL with an application

Summary and Next Steps