Course Outline
What is PostgreSQL?
- A Concise History of PostgreSQL
- Standard Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Getting Started with PostgreSQL
- Installation Process and Database Creation
- Foundations of the SQL Language
- Advanced Capabilities
The SQL Language
- SQL Syntax
- Data Definition
- Data Manipulation
- Executing Queries
- Data Types
- Functions and Operators
- Type Casting
- Indexing
- Full-Text Search
- Concurrency Management
- Performance Optimization Tips
Server Administration
- Compiling from Source Code
- Installing from Source on Windows
- Server Initialization and Operation
- Configuring the Server
- Client Authentication Methods
- Database Roles and Privileges
- Database Management
- Localization Settings
- Standard Maintenance Procedures
- Backup and Restoration Strategies
- High Availability, Load Balancing, and Replication
- Recovery Setup
- Tracking Database Activity
- Monitoring Disk Consumption
- Reliability and the Write-Ahead Log
- Conducting Regression Tests
Client Interfaces
- libpq - The C Library
- Handling Large Objects
- ECPG - Embedding SQL in C
- Utilizing the Information Schema
Server-Side Programming
- Expanding SQL Functionality
- Implementing Triggers
- The Rule System
- Procedural Language Support
- PL/pgSQL - The SQL Procedural Language
- PL/Tcl - The Tcl Procedural Language
- PL/Perl - The Perl Procedural Language
- PL/Python - The Python Procedural Language
- The Server Programming API
Database Internals
- Overview of PostgreSQL Architecture
- System Catalogs
- Frontend/Backend Communication Protocol
- PostgreSQL Coding Standards
- Native Language Handling
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- Genetic Query Optimizer
- Index Access Method Interface Definition
- GiST Indexing
- GIN Indexing
- Physical Database Storage
- BKI Backend Interface
- How the Planner Leverages Statistics
Requirements
Proficiency in SQL and C programming
Fundamental 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 :)
