Course Outline
Understanding PostgreSQL
- A Concise History of PostgreSQL
- General Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Getting Started with PostgreSQL
- Setting Up and Initializing the Database
- The SQL Language
- Advanced Capabilities
The SQL Language
- SQL Syntax
- Defining Data Structures
- Data Manipulation Operations
- Running Queries
- Data Types
- Using Functions and Operators
- Handling Type Conversion
- Implementing Indexes
- Full-Text Search Capabilities
- Managing Concurrency
- Performance Optimization Advice
Server Administration
- Building from Source Code
- Building from Source on Windows
- Configuring and Running the Server
- Configuring Server Parameters
- Handling Client Authentication
- Managing Database Roles
- Administering Databases
- Localization Settings
- Performing Routine Maintenance
- Backup and Restoration Procedures
- Implementing High Availability, Load Balancing, and Replication
- Configuring Recovery Options
- Monitoring Database Activity
- Tracking Disk Usage
- Ensuring Reliability via the Write-Ahead Log
- Running Regression Tests
Client Interfaces
- libpq - The C Library
- Managing Large Objects
- ECPG - Embedding SQL in C
- Utilizing the Information Schema
Server-Side Programming
- Extending SQL Functionality
- Implementing Triggers
- Working with the Rule System
- Using Procedural Languages
- PL/pgSQL - SQL Procedural Language
- PL/Tcl - Tcl Procedural Language
- PL/Perl - Perl Procedural Language
- PL/Python - Python Procedural Language
- The Server Programming Interface
Internal Mechanics
- An Overview of PostgreSQL Internals
- System Catalogs
- The Frontend/Backend Protocol
- PostgreSQL Coding Standards
- Native Language Support
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- The Genetic Query Optimizer
- Defining the Index Access Method Interface
- GiST Indexes
- GIN Indexes
- Physical Database Storage
- The BKI Backend Interface
- How the Planner Leverages Statistics
Requirements
Practical experience with SQL and C
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 :)
