PostgreSQL 16 Server-Side Application Development: A Basic Course

Course ID : PS-DEV1

Duration In-class (в days) : 4 days

Duration Online : 4 days

Сurriculum : Virtual Instructor-Led Training - ONLINE

Overview

The PostgreSQL Foundation Course covers the fundamental topics needed to develop the backend of PostgreSQL applications.

Audience for this course

Database developers

Prerequisites for this course

  • SQL Basics
  • Experience with a procedural programming language
  • Basic knowledge of Unix

Outcomes

By completing this course, students will acquire the skills to:

    • Understand the PostgreSQL architecture
    • Use basic database objects: tables, indexes, views
    • Program server-side in SQL and PL/pgSQL
    • Use basic data types, including records and arrays
    • Organize interaction with the client side of the application

Outline

Module 1: Introduction

Module 2: Basic Toolkit

    • Install and manage, psql

Module 3: Architecture

    • PostgreSQL general structure
    • Isolation and multiversioning
    • Buffer cache and log

Module 4: Data Organization

    • Logical structure                      
    • Physical structure                    

Module 5: The bookstore application

    • Application data schema                        

Module 6: SQL

    • Functions                            
    • Procedures                      
    • Composite types                            

Module 7: PL/pgSQL

    • Language overview and constructs
    • Query execution
    • Cursors
    • Dynamic commands
    • Arrays
    • Error handling
    • Triggers
    • Debugging

Module 8: Access Control

    • Access control overview

Module 9: Backup Copy

    • Logical redundancy

Ask question