Course Outline
What is PostgreSQL?
- Brief Historical Context of PostgreSQL
- Standard Conventions
- Additional Resources
- Guidelines for Reporting Defects
Getting Started with PostgreSQL
- Installing Software and Initializing Databases
- Understanding the SQL Language
- Advanced Capabilities
The SQL Language
- Syntax Rules
- Defining Data Structures
- Manipulating Data
- Executing Queries
- Data Types
- Functions and Operators
- Converting Data Types
- Using Indexes
- Full-Text Search Capabilities
- Managing Concurrency
- Optimization Strategies
Server Administration
- Building from Source Code
- Building from Source on Windows
- Configuring and Operating the Server
- Tuning Server Settings
- Verifying Client Identity
- Managing Database Roles
- Administering Databases
- Localization Settings
- Regular Maintenance Procedures
- Backing Up and Restoring Data
- Ensuring High Availability, Load Distribution, and Replication
- Configuring Recovery Mechanisms
- Tracking Database Operations
- Monitoring Storage Consumption
- Ensuring Reliability via the Write-Ahead Log
- Running Regression Tests
Client Interfaces
- libpq: C Library for Connectivity
- Handling Large Objects
- ECPG: Embedding SQL within C Code
- Accessing the Information Schema
Server-Side Programming
- Enhancing SQL Functionality
- Implementing Triggers
- Utilizing the Rule System
- Using Procedural Languages
- PL/pgSQL: SQL-based Procedural Language
- PL/Tcl: Tcl-based Procedural Language
- PL/Perl: Perl-based Procedural Language
- PL/Python: Python-based Procedural Language
- Developing Server Extensions
Database Internals
- Overview of Internal Architecture
- System Catalogs
- Frontend-Backend Communication Protocol
- PostgreSQL Development Standards
- Support for Native Languages
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- Genetic Query Optimization
- Index Access Method Definitions
- GiST Index Structures
- GIN Index Structures
- Physical Data Storage Methods
- BKI Backend Interface
- How the Query Planner Leverages Statistics
Requirements
Proficiency in SQL and C programming
Foundational system administration skills (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 :)
