Course Outline
What is PostgreSQL?
- Brief History of PostgreSQL
- Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Introduction to PostgreSQL
- Installing and Creating Databases
- Overview of the SQL Language
- Advanced Capabilities
The SQL Language
- SQL Syntax Structure
- Defining Data Structures
- Manipulating Data
- Executing Queries
- Data Type Specifications
- Utilizing Functions and Operators
- Handling Type Conversions
- Managing Indexes
- Full-Text Search Implementation
- Concurrency Management
- Optimization Recommendations
Server Administration
- Building and Installing from Source
- Source Installation on Windows Platforms
- Configuring and Running the Server
- Tuning Server Parameters
- Verifying Client Access
- Defining Database Roles
- Oversight of Databases
- Locale Configuration
- Regular Maintenance Procedures
- Data Backup and Restoration
- Ensuring High Availability, Load Distribution, and Replication
- Setting Up Recovery Mechanisms
- Tracking Database Operations
- Monitoring Storage Utilization
- Ensuring Reliability via Write-Ahead Logging
- Conducting Regression Testing
Client Interfaces
- libpq C Programming Library
- Handling Large Objects
- ECPG Embedded SQL for C Applications
- Utilizing the Information Schema
Server Programming
- Extending SQL Capabilities
- Implementing Triggers
- Managing the Rule System
- Working with Procedural Languages
- PL/pgSQL SQL Procedural Language
- PL/Tcl Tcl Procedural Language
- PL/Perl Perl Procedural Language
- PL/Python Python Procedural Language
- Server-Side Development APIs
Internals
- Architectural Overview of PostgreSQL
- Structure of System Catalogs
- Frontend and Backend Protocols
- PostgreSQL Coding Standards
- Native Language Integration
- Developing Procedural Language Handlers
- Creating Foreign Data Wrappers
- Genetic Query Optimization Techniques
- Defining Index Access Method Interfaces
- GiST Index Implementation
- GIN Index Implementation
- Physical Storage Architecture
- BKI Backend Interfaces
- Planner Utilization of Statistical Data
Requirements
Proficient understanding of SQL and the C programming language
Familiarity with fundamental system administration tasks on Unix/Linux or Windows platforms
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 :)
