Course Outline
What is PostgreSQL?
- A Concise History of PostgreSQL
- Coding and Style Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Getting Started with PostgreSQL
- Setup and Database Creation
- Overview of SQL Syntax
- Advanced Capabilities
SQL Language Fundamentals
- SQL Syntax Structure
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Executing Queries
- Supported Data Types
- Utilizing Functions and Operators
- Type Casting and Conversion
- Creating and Managing Indexes
- Implementing Full-Text Search
- Concurrency Control Mechanisms
- Performance Optimization Strategies
Server Administration
- Building from Source Code
- Source Installation on Windows Platforms
- Initializing and Running the Server
- Configuring Server Parameters
- Setting Up Client Authentication
- Managing Database Roles
- Overseeing Database Operations
- Localization Settings
- Standard Maintenance Procedures
- Backup Strategies and Restoration
- High Availability, Load Balancing, and Replication Strategies
- Configuring Disaster Recovery
- Tracking Database Activity
- Monitoring Storage Usage
- Ensuring Reliability via the Write-Ahead Log
- Conducting Regression Testing
Client Application Interfaces
- libpq - C Client Library
- Handling Large Objects
- ECPG - Embedding SQL in C Applications
- Utilizing the Information Schema
Server-Side Programming
- Extending SQL Capabilities
- 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
- Server Programming APIs
Database Internals
- Architectural Overview of PostgreSQL
- Understanding System Catalogs
- Frontend/Backend Communication Protocol
- PostgreSQL Coding Standards
- Native Language Integration
- Developing a Procedural Language Handler
- Creating a Foreign Data Wrapper
- How the Genetic Query Optimizer Works
- Index Access Method Interfaces
- Gist Indexes Implementation
- Gin Indexes Implementation
- Physical Storage Structures
- BKI Backend Interface
- Utilization of Statistics by the Planner
Requirements
Practical proficiency in SQL and C programming
Fundamental system administration skills 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 :)
