info@orb-experts.com
Dive deep into the world of PostgreSQL Administration and Development. In this intensive training, gain proficiency in PostgreSQL's specialized modules, ranging from replication to full-text search. Tailored for IT professionals, this course is a blend of both theoretical knowledge and practical skills.
Equip yourself with comprehensive knowledge in PostgreSQL Administration and Development.This course not only provides a foundational understanding of PostgreSQL but also advances to cover intricate modules, including:
• Specialized Modules: Replication, connection pooling, full-text search.
• Server Administration: From installation to client authentication.
• Advanced SQL Techniques: Type conversion, indexes, and concurrency control.
• Server Programming: Dive into triggers, procedural languages, and extending SQL.
• Internals: Understand the core mechanisms of PostgreSQL.
By the end of this course, participants will:
• Gain an in-depth understanding of PostgreSQL's architecture and functionalities.
• Master the process of setting up, administering, and optimizing PostgreSQL databases.
• Develop the ability to utilize PostgreSQL's advanced features effectively.
• Understand the under-the-hood operations, ensuring better troubleshooting and performance tuning.
• Familiarity with SQL and C programming language.
• Basics of system administration (Unix/Linux or Windows).
*We know each team has their own needs and specifications. That is why we can modify the training outline per need.
Introduction:
Setting Up PostgreSQL:
SQL Mastery:
Server Administration:
Advanced Techniques:
Client Interfaces:
Server Programming:
Internals of PostgreSQL:
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.
