Course Outline
What is PostgreSQL?
- A Concise History of PostgreSQL
- Standard Conventions
- Additional Resources
- Guidelines for Reporting Bugs
Getting Started with PostgreSQL
- Setting Up and Creating Databases
- Fundamentals of the SQL Language
- Advanced Capabilities
Deep Dive into SQL
- SQL Syntax Structure
- Data Definition Statements
- Data Manipulation Operations
- Executing Queries
- Understanding Data Types
- Working with Functions and Operators
- Handling Type Conversion
- Utilizing Indexes
- Implementing Full Text Search
- Managing Concurrency Control
- Performance Best Practices
Server Administration
- Compiling and Installing from Source
- Installing from Source on Windows Systems
- Configuring and Running the Server
- Tuning Server Configuration
- Securing Client Authentication
- Defining Database Roles
- Administering Database Instances
- Managing Localization Settings
- Performing Routine Maintenance
- Implementing Backup and Recovery Strategies
- Setting Up High Availability, Load Balancing, and Replication
- Configuring Recovery Procedures
- Tracking Database Activity
- Monitoring Disk Space Usage
- Ensuring Reliability with the Write-Ahead Log
- Running Regression Tests
Client Interfaces
- Using libpq in C Applications
- Handling Large Objects
- Implementing ECPG for Embedded SQL in C
- Exploring the Information Schema
Server-Side Programming
- Extending SQL Functionality
- Creating Database Triggers
- Understanding the Rule System
- Working with Procedural Languages
- Writing Procedures in PL/pgSQL
- Writing Procedures in PL/Tcl
- Writing Procedures in PL/Perl
- Writing Procedures in PL/Python
- Interfacing with the Server Programming API
Database Internals
- An Overview of PostgreSQL Architecture
- Examining System Catalogs
- The Frontend and Backend Protocol
- Adhering to PostgreSQL Coding Standards
- Supporting Native Languages
- Developing Custom Procedural Language Handlers
- Creating Foreign Data Wrappers
- Utilizing the Genetic Query Optimizer
- Defining Index Access Methods
- Managing GiST Indexes
- Managing GIN Indexes
- Physical Storage Management
- The BKI Backend Interface
- How the Planner Utilizes Statistics
Requirements
Familiarity with SQL and C programming
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 :)
