PostgreSQL Developer Fundamentals & Advanced Training

postgres-training-post-banner

docker
mongoDB

PostgreSQL Training

Designed for DBAs, Architects, Application Developers, and IT Professionals, our training courses are created and delivered by experienced PostgreSQL experts who will show you how to quickly manage your database responsibilities with ease.

We offer training in 2 convenient formats:

  • Classroom – scheduled, open-enrolment public training batch at a specified city or location
  • On-Site – delivered on-premise at your company location for your team

HANDS-ON EXPERIENCE

Relevant and up-to date material and labs enable you to quickly put your new skills into practice in your own environment. All training includes modularized lessons, lecture, presentation copy, and real hands-on lab exercises.

POSTGRESQL DEVELOPER FUNDAMENTALS :

PostgreSQL Developer Fundamentals is a 2-day instructor-led training that gives you the essential skills for database development in PostgreSQL. Learn about PostgreSQL data types, database objects, indexes, transactions, and working with connectors and drivers, with basic installation.


Training Course Structure:

  • Procedural Languages:
  • What is a Procedural Langauge
  • Introduction to PL/pgSQL
  • Working of PL/pgSQL
  • How to Create PL/pgSQL Functions
  • How to use Control Statements
  • How to Handle Exceptions in PL/pgSQL
  • Declaring and Using Cursors
  • Rules and Triggers:
  • How to define Rules
  • Write Database Trigger Procedures
  • Create Triggers in PostgreSQL
  • Add Triggers on Views
  • SQL Tuning:
  • Statement Processing
  • Common Query Performance Issues
  • SQL Tuning Goals
  • SQL Tuning Steps
    • ‒ Identify slow queries
    • ‒ Review the query execution plan
    • ‒ Optimizer statistics and behaviour
    • ‒ Restructure SQL statements
    • ‒ Indexes
  • Background Worker Processes:
  • What is Background Worker
  • How to Setup Background Worker
  • Examples of Pre-built Background Worker Processes
  • Localization:
  • PostgreSQL Locale Support
  • Working with different Locales
  • PostgreSQL Character Sets
  • Changing Server and Client Encoding
  • Foreign Data Wrappers:
  • What are Postgres
  • Foreign Data Wrappers
  • How to Setup FDWs
  • Example – postgres_fdw
  • Example – file_fdw
  • Full Text Searching:
  • What is Full-Text Search
  • How to store and query Full Text Search data in Postgres
  • Data Encryption:
  • What is Database Security
  • PostgreSQL options for Eata Encryption and Security
  • What is Host Based Access Control
  • How to implement Row level Security
  • Introduction to pg_crypto Extension
  • Working with Geo Data: Postgis
  • What is PostGIS
  • Installation of PostGIS
  • Creation of spatial database
  • Load and retrieve data in a spatial database

Read more

Developer Advanced Training covers advanced skills needed by PostgreSQL database developers in another 2-day instructor-led training. You will learn about using data adapters to interact with additional data sources, a multi-step plan for SQL tuning, and approaches for data security and localization. This is the second part in the PostgreSQL Developers Track and follows PostgreSQL Developer Fundamentals.


Training Course Structure:

  • PostgreSQL Introduction:
  • Introduction to PostgreSQL
  • Describe the sample tables used in the course
  • Installation:
  • Installation Options
  • PostgreSQL Installation
  • PostgreSQL Source Code
  • Database Clusters
  • Start and Stop Postgres
  • pgAdmin III:
  • PgAdmin3
  • PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Command Line Tool: PSQL
  • Command Line Tool: EDB*Plus
  • Transactions and Concurrency:
  • Transaction Definition
  • Effects of Concurrency on Transactions
  • Transaction Isolation Levels
  • Sharing Data Snapshots
  • Locking Modes
  • Multi-Version Concurrency Control Overview (MVCC)
  • Internal Identifiers
  • PostgreSQL Connectors and Extensions:
  • JDBC
  • Installing JDBC Connectors
  • Connecting Java Applications to PostgreSQL
  • .NET Connectors
  • Extensions
  • Database Design:
  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path
  • Data Types:
  • Numeric Types
  • Character Types
  • Date and Time
  • Arrays
  • JSON and JSONB
  • Other Data Types
  • SQL Primer:
  • Tables
  • Constraints
  • Table Inheritance
  • Viewing Data Using SELECT
  • SQL Queries: DML
  • Quoting in PostgreSQL
  • Other Database Objects:
  • Views
  • Materialized Views
  • Sequences
  • Domains
  • Indexes:
  • Types of Indexes
  • Creating an Index
  • Index on Expression
  • Unique Indexes
  • Partial Indexes
  • Removing Indexes
  • Viewing Index Usage
  • Re-indexing
  • SQL Functions:
  • Operators
  • String Functions
  • Date Functions
  • Numeric Function
  • JSON Functions
  • XML Functions
  • Aggregate Functions
  • Data Type Conversion
  • Large Objects:
  • Data Types for large data
  • Adding lo extenstion
  • Using Java File Stream for inserting
  • image in postgres
  • Large Objects:
  • Introduction to PLPGSQL
  • PL/PGSQL
  • Creating Functions using PL/PGSQL
  • PostgreSQL Introduction:
  • Introduction to PostgreSQL
  • Describe the sample tables used in the course
  • Installation:
  • Installation Options
  • Postgres Installation
  • PostgreSQL Source Code
  • Database Clusters
  • Start and Stop Postgres
  • pgAdmin III:
  • PgAdmin3
  • PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Command Line Tool: PSQL
  • Command Line Tool: EDB*Plus
  • Transactions and Concurrency:
  • Transaction Definition
  • Effects of Concurrency on Transactions
  • Transaction Isolation Levels
  • Sharing Data Snapshots
  • Locking Modes
  • Multi-Version Concurrency Control Overview (MVCC)
  • Internal Identifiers
  • PostgreSQL Connectors and Extensions:
  • JDBC
  • Installing JDBC Connectors
  • Connecting Java Applications to PostgreSQL
  • .NET Connectors
  • Extensions
  • Database Design:
  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path
  • Data Types:
  • Numeric Types
  • Character Types
  • Date and Time
  • Arrays
  • JSON and JSONB
  • Other Data Types
  • SQL Primer:
  • Tables
  • Constraints
  • Table Inheritance
  • Viewing Data Using SELECT
  • SQL Queries: DML
  • Quoting in PostgreSQL
  • Other Database Objects:
  • Views
  • Materialized Views
  • Sequences
  • Domains
  • Indexes:
  • Types of Indexes
  • Creating an Index
  • Index on Expression
  • Unique Indexes
  • Partial Indexes
  • Removing Indexes
  • Viewing Index Usage
  • Re-indexing
  • SQL Functions:
  • Operators
  • String Functions
  • Date Functions
  • Numeric Function
  • JSON Functions
  • XML Functions
  • Aggregate Functions
  • Data Type Conversion
  • Large Objects:
  • Data Types for large data
  • Adding lo extenstion
  • Using Java File Stream for inserting
  • image in postgres
  • Large Objects:
  • Introduction to PLPGSQL
  • PL/PGSQL
  • Creating Functions using PL/PGSQL

Read more

The above courses are to be attended together.

Target Audience: For experienced Database Developers who are new to PostgreSQL and want to gain the essential skills required to effectively design and implement PostgreSQL databases for applications while incorporating PostgreSQL features.

Training Pre-requisites:

  • Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

Delivery Approach:

  • Training includes lessons, hands-on labs and follow-up exercises to teach you how to use Postgres.
  • All attendees must attend this class in person. There is no remote access to the training.

Interested? Fill the Inquire Now form.

OR
Write to us on training@ashnik.com.