+49 (0) 30 5201 4923
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 customize the course outline and content to your specific needs and relevant use cases.
Introduction:
• Overview of PostgreSQL
• Brief History of PostgreSQL
• Conventions, Bug Reporting, and Further Information
Setting Up PostgreSQL:
• Installation and Database Creation
• Server Setup, Operation, and Configuration
• Installation from Source Code (including on Windows)
SQL Mastery:
• Introduction to the SQL Language
• SQL Syntax, Data Definition, and Manipulation
• Queries, Data Types, and Functions
• Indexes and Full Text Search
Server Administration:
• Client Authentication and Database Roles
• Managing Databases and Routine Maintenance Tasks
• Backup, Restore, and High Availability Solutions
• Monitoring: Database Activity and Disk Usage
• Reliability with the Write-Ahead Log
Advanced Techniques:
• Concurrency Control
• Performance Tips and Regression Tests
Client Interfaces:
• libpq - C Library and Large Objects
• ECPG - Embedded SQL in C
• The Information Schema
Server Programming:
• Extending SQL and Understanding Triggers
• Procedural Languages: PL/pgSQL, PL/Tcl, PL/Perl, PL/Python
• Rule Systems and Server Programming Interfaces
Internals of PostgreSQL:
• System Catalogs and Frontend/Backend Protocols
• PostgreSQL Coding Conventions and Native Language Support
• Writing Handlers and Data Wrappers
• Index Mechanisms: GiST, GIN, and Database Storage
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.
