PostgreSQL – Developer

The Stalwart Learning Online PostgreSQL training course is ideal for those looking to migrate to PostgreSQL. This training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to PostgreSQL. Attendees will learn how to apply their SQL knowledge and experience to the PostgreSQL platform.

Designed for developers looking to migrate to PostgreSQL, this training course does not cover SQL, the SQL language, DML, or DDL – these are pre-requisites.

3 Days

Participants attending classes should have experience with SQL – including DDL, DML, and writing effective SQL queries before attending this PostgreSQL training class.

Alternatively, the above points can also be covered in Training.

  • Installing & managing PostgreSQL
  • Overview of PostgreSQL database
  • Using the psql client
  • pgAdmin as GUI client
  • Architectural Fundamentals (Logical and Physical layout)
  • Physical Architectural
  • Logical Architectural
  • Starting, stopping and finding status of postmaster
  • Exploring utilities in Postgresql (process and server / postmaster)
  • Working with above said process related utilities
  • Creating a Database
  • Accessing a Database
  • Creating a New Table
  • Populating a Table With Rows
  • Querying a Table
  • Joins Between Tables
  • Aggregate Functions
  • Configuration files in postgresql
  • Server configuration
  • Connectivity configuration
  • User auth. & privileges
  • Access Control
  • Remote machine connectivity
  • Schemas in Postgresql
  • Tablespace in postgresql
  • Hands-on exercise to create tablespace and using it.
  • Concurrency control – Introduction
  • Transaction Isolation (Levels with hands-on)
  • Explicit Locking
  • Hands-on Exercise / implementation
  • Data dictionary / meta data in postgresql
  • Using EXPLAIN
  • EXPLAIN ANALYZE
  • Disable Autocommit
  • Performance Tips
  • Understanding PostgreSQL indexes
  • PostgreSQL Index Types
  • Using COPY to load data
  • Using the PostgreSQL query optimizer
  • Analyzing & optimizing queries
  • Viewing execution plans with EXPLAIN
  • Improving query performance
  • Routine Database Maintenance Tasks
  • Routine Vacuuming
  • Routine Reindexing
  • Understand Auto-vacuuming
  • Log File Maintenance
  • Backup and Restore
  • SQL Dump
  • Pg_dump & pg_dumpall
  • File System Level Backup
  • Setting up WAL archiving
  • Hands-on Exercise / implementation
  • Routine Maintenance
  • Question Answer Session…!!