Course Outline
Understanding PostgreSQL
- Historical Overview of PostgreSQL
- Standard Conventions
- Additional Resources
- Protocols for Reporting Bugs
Getting Started with PostgreSQL
- Setup and Database Creation
- Overview of the SQL Language
- Advanced Capabilities
SQL Language Essentials
- SQL Structure and Syntax
- Defining Data Structures
- Manipulating Data
- Executing Queries
- Data Type Definitions
- Use of Functions and Operators
- Converting Data Types
- Indexing Strategies
- Implementing Full-Text Search
- Managing Concurrency
- Optimization Strategies
Managing the Server
- Installing from Source
- Installing from Source on Windows
- Configuring and Running the Server
- Tuning Server Settings
- Securing Client Access
- Managing User Roles
- Oversight of Databases
- Language and Locale Settings
- Regular Maintenance Procedures
- Creating Backups and Restoring Data
- Ensuring High Availability, Load Distribution, and Replication
- Setting Up Recovery Mechanisms
- Tracking Database Operations
- Monitoring Storage Usage
- Ensuring Reliability via Write-Ahead Logging
- Running Regression Tests
Client Connectivity Tools
- libpq - C API Library
- Handling Large Objects
- ECPG - Embedding SQL in C
- Exploring 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
- Developer Interfaces for the Server
Internal Architecture
- Snapshot of PostgreSQL Inner Workings
- System Catalog Structures
- Frontend/Backend Communication Protocol
- PostgreSQL Coding Standards
- Support for Native Languages
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- The Genetic Query Optimizer
- Defining Index Access Method Interfaces
- Using GiST Indexes
- Using GIN Indexes
- Physical Data Storage Layout
- Utilizing the BKI Backend Interface
- How the Planner Leverages Statistics
Requirements
Practical proficiency in SQL and C
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 :)
