PostgreSQL for Developers Training Course

Description

• Type

  Course

• Methodology

  Online

Description

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.

About this course

Requirements

A working knowledge of SQL and C

Questions & Answers

Add your question

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

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

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

Course programme

What is PostgreSQL?

• A Brief History of PostgreSQL
• Conventions
• Further Information
• Bug Reporting Guidelines

Introduction to PostgreSQL

• Installation from Packages and Creating Database
• Installation from Source Code
• Installation from Source Code on Windows
• The SQL Language
• Advanced Features

The SQL Language

• SQL Syntax
• Data Definition
• Data Manipulation
• Queries
• Data Types
• Functions and Operators
• Type Conversion
• Indexes
• Full Text Search
• Concurrency Control
• Performance Tips

Client Interfaces

• libpq - C Library
• Large Objects
• Special Considerations for Event Loop Based Programs
• Error Handling
• ECPG - Embedded SQL in C
• The Information Schema
• Bindings in Other Programming Languages, e.g. PHP, Perl, Python, Node.js, Go.
• Special Considerations for Asynchronous Python Frameworks (e.g. gevent, asyncio, Twisted, Tornado)
• Support of PostgreSQL in ORM frameworks

Server Programming

• Extending SQL
• Triggers
• The Rule System
• Procedural Languages
• PL/pgSQL - SQL Procedural Language
• PL/Tcl - Tcl Procedural Language
• PL/Perl - Perl Procedural Language
• PL/Python - Python Procedural Language
• Server Programming Interface

Internals

• Overview of PostgreSQL Internals
• System Catalogs
• Frontend/Backend Protocol
• PostgreSQL Coding Conventions
• Native Language Support
• Writing A Procedural Language Handler
• Writing A Foreign Data Wrapper
• Genetic Query Optimizer
• Index Access Method Interface Definition
• GiST Indexes
• GIN Indexes
• Database Physical Storage
• BKI Backend Interface
• How the Planner Uses Statistics

Additional information

14 hours (usually 2 days including breaks)

See related categories

• Installation courses
• Distance learning Installation courses
• Server courses
• Distance learning Server courses
• Electrical installation courses
• Cctv installation courses
• Technical writing courses
• Speed writing courses
• Solar panel installation courses
• Meter installation courses
• Bid writing courses
• Oracle sql courses
• Technical report writing courses
• Medical writing courses
• Travel writing courses
• Legal writing courses
• Science writing courses
• Scientific writing courses
• SQL Server courses
• Distance learning SQL Server courses
• Distance learning Course
• Nobleprog Limited courses