Course Outline
What is PostgreSQL?
- A Concise History of PostgreSQL
- Standard Conventions
- Additional Resources
- Guidelines for Reporting Bugs
PostgreSQL Fundamentals
- Setting Up and Initializing the Database
- Understanding the SQL Language
- Advanced Capabilities
Deep Dive into SQL
- SQL Syntax Structures
- Defining Data Structures
- Manipulating Data
- Executing Queries
- Handling Data Types
- Using Functions and Operators
- Type Casting and Conversion
- Implementing Indexes
- Full-Text Search Implementation
- Managing Concurrency
- Optimization Strategies
Server Management
- Compiling from Source Code
- Compiling from Source on Windows
- Configuring and Running the Server
- Server Parameter Configuration
- Managing Client Credentials
- Defining Database Roles
- Administrating Databases
- Localization Settings
- Standard Maintenance Procedures
- Creating Backups and Restoring Data
- Ensuring High Availability, Load Balancing, and Replication
- Configuring Recovery Options
- Monitoring System Activity
- Tracking Disk Space Usage
- Ensuring Reliability via the Write-Ahead Log
- Running Regression Tests
Client Connectivity
- libpq - The C API
- Handling Large Objects
- ECPG - Embedding SQL in C
- The Information Schema
Server-Side Development
- Expanding SQL Capabilities
- Implementing Triggers
- Utilizing the Rule System
- Working with 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
- Server Development Interfaces
Internal Architecture
- PostgreSQL Internals Overview
- System Catalog Structures
- Client-Server Protocol
- PostgreSQL Development Standards
- Native Language Handling
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- The Genetic Query Optimizer
- Index Access Method Definitions
- GiST Index Structures
- GIN Index Structures
- Physical Storage Layout
- BKI Backend Interfaces
- Planner Statistics Usage
Requirements
Functional proficiency in SQL and C
Fundamental system administration skills (Unix/Linux or Windows)
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 5800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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 :)