Get in Touch
 Duration 28 hours

Course Outline

What is PostgreSQL?

  • A Concise History of PostgreSQL
  • Standard Conventions
  • Additional Resources
  • Guidelines for Reporting Bugs

PostgreSQL Fundamentals

  • Setting Up and Initializing the Database
  • Understanding the SQL Language
  • Advanced Capabilities

Deep Dive into SQL

  • SQL Syntax Structures
  • Defining Data Structures
  • Manipulating Data
  • Executing Queries
  • Handling Data Types
  • Using Functions and Operators
  • Type Casting and Conversion
  • Implementing Indexes
  • Full-Text Search Implementation
  • Managing Concurrency
  • Optimization Strategies

Server Management

  • Compiling from Source Code
  • Compiling from Source on Windows
  • Configuring and Running the Server
  • Server Parameter Configuration
  • Managing Client Credentials
  • Defining Database Roles
  • Administrating Databases
  • Localization Settings
  • Standard Maintenance Procedures
  • Creating Backups and Restoring Data
  • Ensuring High Availability, Load Balancing, and Replication
  • Configuring Recovery Options
  • Monitoring System Activity
  • Tracking Disk Space Usage
  • Ensuring Reliability via the Write-Ahead Log
  • Running Regression Tests

Client Connectivity

  • libpq - The C API
  • Handling Large Objects
  • ECPG - Embedding SQL in C
  • 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
  • Server Development Interfaces

Internal Architecture

  • PostgreSQL Internals Overview
  • System Catalog Structures
  • Client-Server Protocol
  • PostgreSQL Development Standards
  • Native Language Handling
  • Developing a Procedural Language Handler
  • Creating a Foreign Data Wrapper
  • The Genetic Query Optimizer
  • Index Access Method Definitions
  • GiST Index Structures
  • GIN Index Structures
  • Physical Storage Layout
  • BKI Backend Interfaces
  • Planner Statistics Usage

Requirements

Functional proficiency in SQL and C

Fundamental system administration skills (Unix/Linux or Windows)

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 5800 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (7)

Upcoming Courses

Related Categories