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 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
Requirements
- Basic knowledge of SQL
- Familiarity with database concepts
Audience
- Database administrators
- Database developers
- System administrators
21 Hours
Testimonials (5)
Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter
Ryan - Questronix Corporation
Course - PostgreSQL for Administrators - 3 Days
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
Course - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system