Postgresql
Instructor-led training in Postgresql. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Overview
This intermediate PostgreSQL course equips participants with the skills necessary to manage and optimize PostgreSQL databases effectively. You will learn advanced querying techniques, database design principles, and performance tuning strategies that are essential for any data-driven organization.
What you'll learn
- You will be able to design and implement relational database structures using PostgreSQL.
- You will be able to write complex SQL queries to retrieve and manipulate data.
- You will be able to optimize database performance through indexing and query analysis.
- You will be able to manage database security and user access controls.
- You will be able to implement backup and recovery strategies for PostgreSQL databases.
- You will be able to utilize PostgreSQL extensions to enhance database functionality.
- You will be able to troubleshoot common issues and optimize database operations.
Curriculum
7 modules · outline is indicative and can be tailored to your team.
1Introduction to PostgreSQL
- Overview of PostgreSQL architecture
- Installation and configuration
- Understanding data types and schemas
2Advanced SQL Queries
- Joins, subqueries, and set operations
- Window functions and common table expressions
- Aggregate functions and grouping data
3Database Design and Normalization
- Principles of database design
- Normalization and denormalization techniques
- Entity-relationship modeling
4Performance Tuning
- Indexing strategies and types
- Query planning and execution
- Monitoring performance and using EXPLAIN
5Database Security
- User roles and permissions
- Data encryption and secure connections
- Auditing and compliance measures
6Backup and Recovery
- Backup strategies and tools
- Point-in-time recovery
- Disaster recovery planning
7Using PostgreSQL Extensions
- Introduction to popular extensions (PostGIS, pgAdmin)
- Creating custom extensions
- Leveraging extensions for enhanced functionality
Prerequisites
Basic understanding of SQL and database concepts is recommended.
Who should attend
This course is ideal for database administrators, developers, and IT professionals looking to deepen their PostgreSQL knowledge.
Certification
Frequently asked questions
What is the delivery format of the course?
The course is delivered live online, allowing for interactive learning and real-time Q&A.
How long is the course?
The course typically spans 5 days, with each session lasting 3 hours.
Will I receive a certificate upon completion?
Yes, participants will receive an Skilvi course-completion certificate after finishing the course.
Are exam vouchers included?
Exam vouchers are available through authorized channels on request.
What are the prerequisites for this course?
Basic understanding of SQL and database concepts is recommended.
Pricing on request
- Live online (VILT)
- 24–32 hours
- Hands-on labs & assignments
- Skilvi completion certificate
Related courses
Cassandra
Instructor-led training in Cassandra. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Greenplum
Instructor-led training in Greenplum. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Mongodb
Instructor-led training in Mongodb. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Mysql
Instructor-led training in Mysql. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.