PostgreSQL for Developers Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

This course provides programmatic interaction with PostgreSQL databases and writing PostgreSQL extensions.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • Perl
  • Database
  • SQL
  • Database training
  • Installation
  • Statistics
  • Syntax
  • Writing
  • Programming

Course programme

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

See related categories

PostgreSQL for Developers Training Course

Price on request

The best SQL Server courses

See all

See all