Course Outline

What is PostgreSQL?

  • A Brief History of PostgreSQL
  • Conventions
  • Further Information
  • Bug Reporting Guidelines

Introduction to PostgreSQL

  • Installation and Creating Database
  • The SQL Language
  • Advanced Features

The SQL Language

  • SQL Syntax
  • Data Definition
  • Data Manipulation
  • Queries
  • Data Types
  • Functions and Operators
  • Type Conversion
  • Indexes
  • Full Text Search
  • Concurrency Control
  • Performance Tips

Server Administration

  • Installation from Source Code
  • Installation from Source Code on Windows
  • Server Setup and Operation
  • Server Configuration
  • Client Authentication
  • Database Roles
  • Managing Databases
  • Localization
  • Routine Database Maintenance Tasks
  • Backup and Restore
  • High Availability, Load Balancing, and Replication
  • Recovery Configuration
  • Monitoring Database Activity
  • Monitoring Disk Usage
  • Reliability and the Write-Ahead Log
  • Regression Tests

Client Interfaces

  • libpq - C Library
  • Large Objects
  • ECPG - Embedded SQL in C
  • The Information Schema

Server Programming

  • Extending SQL
  • Triggers
  • The Rule System
  • Procedural Languages
  • PL/pgSQL - SQL Procedural Language
  • PL/Tcl - Tcl Procedural Language
  • PL/Perl - Perl Procedural Language
  • PL/Python - Python Procedural Language
  • Server Programming Interface

Internals

  • Overview of PostgreSQL Internals
  • System Catalogs
  • Frontend/Backend Protocol
  • PostgreSQL Coding Conventions
  • Native Language Support
  • Writing A Procedural Language Handler
  • Writing A Foreign Data Wrapper
  • Genetic Query Optimizer
  • Index Access Method Interface Definition
  • GiST Indexes
  • GIN Indexes
  • Database Physical Storage
  • BKI Backend Interface
  • How the Planner Uses Statistics

Requirements

A working knowledge of SQL and C

Basic system administration (Unix/Linux or Windows)

 28 Hours

Testimonials (7)

Upcoming Courses