Course Outline

Introduction to PostgreSQL

  • A Brief History of PostgreSQL
  • Features
  • Internals Summary
  • Limits and Terminology

Installation and Configuration

  • Pre-requisites
  • Installation from Packages and Creating Database
  • Installation from Source Code
  • Client Installation
  • Starting and Stopping a Database Server
  • Environment Setup

The SQL Language

  • SQL Syntax
  • Data Definition
  • Data Manipulation
  • Queries
  • Data Types
  • JSON
  • Functions and Operators
  • Type Conversion
  • Indexes

Transactions and Concurrency

  • Transactions and Isolation
  • Multi-Version Concurrency Control

Client Interfaces

  • Command Line Interface - psql
  • Graphical Interface - pgadmin4

Server Programming

  • Extending SQL
  • Triggers
  • The Rule System
  • Procedural Languages
  • PL/pgSQL - SQL Procedural Language
  • Error Handling
  • Cursors

Foreign Data Wrappers

  • Extension in PostgreSQL
  • Adding FDW in a Database
  • postgres_fdw
  • file_fdw
  • Other FDWs

SQL Tuning

  • Logging in PostgreSQL
  • Query Plans
  • Optimizing Queries
  • Statistics
  • Planner Parameters
  • Parallel Query Scans
  • SQL Best Practices
  • Indexes
  • Table Partitioning

Requirements

A working knowledge of SQL

  14 Hours
 

Testimonials

Related Courses

PostgreSQL Administration and Development

  28 hours

PostgreSQL for Administrators - 2 Days

  14 hours

PostgreSQL Administration, Optimization and Replication

  35 hours

PostgreSQL Essentials

  14 hours

PostgreSQL Advanced DBA

  14 hours

Implementing High Availability in PostgreSQL

  7 hours

PostgreSQL Performance Tuning

  14 hours

Migrating Oracle to Azure SQL or PostgreSQL

  7 hours

PostgreSQL 13 for Developers and Administrators

  21 hours

PostgreSQL for Administrators - 3 Days

  21 hours

PostgreSQL with Python

  21 hours

Data Management

  35 hours

SAP ASE for Database Administrators

  28 hours

Pivotal Greenplum for Developers

  21 hours

MarkLogic Server

  14 hours