Course Outline
What is PostgreSQL?
- PostgreSQL Historical Context
- Standard Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Getting Started with PostgreSQL
- Software Installation and Database Creation
- The SQL Language
- Advanced Capabilities
SQL Language Fundamentals
- SQL Syntax Rules
- Data Definition Statements
- Data Manipulation Operations
- Query Construction
- Data Type Management
- Using Functions and Operators
- Data Type Conversion
- Index Management
- Full-Text Search Implementation
- Concurrency Control Mechanisms
- Performance Optimization Strategies
Server Administration
- Building from Source Code
- Building from Source on Windows
- Server Initialization and Operation
- Server Configuration Settings
- Client Authentication Methods
- Database Role Management
- Database Administration Tasks
- Localization Options
- Routine Maintenance Procedures
- Backup and Restoration Strategies
- High Availability, Load Balancing, and Replication Setup
- Configuring Recovery Options
- Tracking Database Activity
- Monitoring Disk Consumption
- Ensuring Reliability via Write-Ahead Logging
- Running Regression Tests
Client Interface Development
- libpq C Library Usage
- Handling Large Objects
- ECPG: Embedded SQL in C
- Querying the Information Schema
Server-Side Programming
- Extending SQL Functionality
- Implementing Triggers
- Understanding the Rule System
- Procedural Language Support
- PL/pgSQL: SQL Procedural Language
- PL/Tcl: Tcl Procedural Language
- PL/Perl: Perl Procedural Language
- PL/Python: Python Procedural Language
- Server Programming Interfaces
Database Internals
- Overview of PostgreSQL Architecture
- System Catalogs
- Frontend/Backend Communication Protocol
- PostgreSQL Coding Standards
- Native Language Support Mechanisms
- Creating a Procedural Language Handler
- Developing a Foreign Data Wrapper
- Genetic Query Optimizer Details
- Index Access Method Interface Definition
- GiST Index Structure
- GIN Index Structure
- Physical Database Storage
- BKI Backend Interface
- Planner Use of Statistical Data
Requirements
Proficiency in SQL and C programming
Familiarity with basic system administration (Unix/Linux or Windows)
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 :)
