Course Outline
What is PostgreSQL?
- Concise Historical Context
- Established Conventions
- Additional Resources
- Protocol for Reporting Defects
PostgreSQL Fundamentals
- Deployment and Database Creation
- The SQL Language
- Advanced Capabilities
The SQL Language
- SQL Syntax Standards
- Data Definition Structures
- Data Manipulation Operations
- Executing Queries
- Data Typing System
- Functions and Operator Usage
- Type Casting and Conversion
- Indexing Strategies
- Full-Text Search Capabilities
- Concurrency Management
- Optimization Recommendations
Server Administration
- Compilation from Source Code
- Source-Based Installation on Windows
- Server Initialization and Management
- Configuration Parameters
- Client Verification Methods
- Role Management
- Database Administration
- Regional Settings (Localization)
- Scheduled Maintenance Procedures
- Data Archival and Restoration
- High Availability, Balancing, and Replication
- Recovery Mechanisms
- Activity Surveillance
- Disk Space Monitoring
- Reliability and Write-Ahead Logging
- Test Validation Suites
Client Interfaces
- libpq - C API Library
- Handling Large Objects
- ECPG - Embedded SQL within C
- Information Schema Exploration
Server Programming
- Expanding SQL Functionality
- Implementing Triggers
- Rule System Mechanics
- Procedural Language Support
- PL/pgSQL - SQL Procedure Language
- PL/Tcl - Tcl Procedure Language
- PL/Perl - Perl Procedure Language
- PL/Python - Python Procedure Language
- Server API Interfacing
Internals
- Architectural Overview
- System Catalog Structures
- Frontend/Backend Communication Protocol
- PostgreSQL Development Standards
- Native Language Implementation
- Developing Procedural Language Handlers
- Creating Foreign Data Wrappers
- Genetic Query Optimizer
- Index Access Method Definitions
- GiST Indexing Techniques
- GIN Indexing Techniques
- Physical Storage Layout
- BKI Backend Interface
- Planner Statistic Utilization
Requirements
Proficiency in SQL and C programming.
Familiarity with fundamental 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 :)
