Course Outline
Understanding PostgreSQL
- Brief History of PostgreSQL
- Coding Conventions
- Additional Resources
- Guidelines for Reporting Bugs
PostgreSQL Basics
- Installation and Database Creation
- Overview of the SQL Language
- Advanced Capabilities
SQL Language Fundamentals
- SQL Syntax Structure
- Data Definition
- Data Manipulation
- Query Construction
- Available Data Types
- Functions and Operators
- Type Casting and Conversion
- Indexing Strategies
- Full-Text Search Implementation
- Concurrency Control Mechanisms
- Performance Optimization Recommendations
Server Management
- Compiling and Installing from Source
- Source Installation on Windows Environments
- Server Initialization and Operations
- Configuring Server Parameters
- Client Authentication Methods
- Managing Database Roles
- Database Administration
- Locale and Language Settings
- Standard Database Maintenance Procedures
- Backup and Recovery Procedures
- High Availability, Load Balancing, and Replication Strategies
- Recovery Setup
- Monitoring Database Operations
- Tracking Disk Utilization
- Reliability and Write-Ahead Logging (WAL)
- Running Regression Tests
Client Interaction Interfaces
- libpq C API Library
- Handling Large Objects
- ECPG for Embedded SQL in C
- Utilizing the Information Schema
Server-Side Development
- Extending SQL Functionality
- Implementing Triggers
- The Rule System
- Procedural Language Support
- PL/pgSQL Programming
- PL/Tcl Integration
- PL/Perl Integration
- PL/Python Integration
- Server Programming Interface (SPI)
Internal Architecture
- Overview of Internal Components
- System Catalogs
- Frontend to Backend Communication Protocol
- PostgreSQL Development Standards
- Native Language Support Implementation
- Creating Procedural Language Handlers
- Building Foreign Data Wrappers (FDW)
- Genetic Query Optimizer (GEQO)
- Index Access Method Interface Definition
- GiST Index Structure
- GIN Index Structure
- Physical Storage Mechanisms
- BKI Backend Interface
- Planner Statistics Usage
Requirements
Proficiency in SQL and C programming
Familiarity with basic system administration on Unix/Linux or Windows platforms
Testimonials (7)
step by step examples, byte size information
Esmadee Bin Ismail - SBS transit
Course - PostgreSQL Administration and Development
The different techniques that can be used to get the same result it is just optimise with a few steps
Abdul Hafiz - SBS transit
Course - PostgreSQL Administration and Development
1. Notes on the whiteboard 2. Labs were executed in a sharing mode
Evangelos Katsaros
Course - PostgreSQL Administration and Development
The instructor explained everything we asked, he was very accurate, and he kept my interested.
Katerina Andreopoulou
Course - PostgreSQL Administration and Development
The fact that we had a chance to hear about the difference between many databases types.
Marta Melloch - Amazon Development Center Poland Sp. z o.o.
Course - PostgreSQL Administration and Development
useful knowledge
Ewa Napieralska - Amazon Development Center Poland Sp. z o.o.
Course - PostgreSQL Administration and Development
The exercises and that the trainers was very responsive and was listening to us actively. He was also very patient with us. THANK YOU SO MUCH :)