PostgreSQL Training Courses

PostgreSQL Training

PostgreSQL (AKA Postgres) Training courses

Testi...Client Testimonials

PostgreSQL for Administrators

Trainer Subject Knowledge

Julian Pirau - BMO Financials

PostgreSQL for Administrators

How to maintain the database, and how is the orgenazition of the data.

Jiang Chang - NAV CANADA

PostgreSQL for Administrators

I liked everything he taught.

Emily Zhou - Ryerson University

PostgreSQL for Administrators

I wish we could had a lab time, maybe the amount of time of training is tighten, we did not have lab time in class.

Gary Pan - Ryerson University

PostgreSQL Administration and Development

Very in depth knowledge on the subject matter. No "I'll have to look into that and get back to you, just knew it all"

David Marshall - TIO Networks CORP

PostgreSQL Administration

Życiowe przykłady, doświadczenie, głęboka wiedza dotycząca działania bazy i opcji konfiguracyjnych.

Łukasz Picur - Codewise Sp. z o.o. Sp. K.

PostgreSQL Course Outlines

Code Name Duration Overview
pgsqladm PostgreSQL Administration and Development 28 hours This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching. What is PostgreSQL? A Brief History of PostgreSQL Conventions Further Information Bug Reporting Guidelines Introduction to PostgreSQL Installation and Creating Database 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 Server Administration Installation from Source Code Installation from Source Code on Windows Server Setup and Operation Server Configuration Client Authentication Database Roles Managing Databases Localization Routine Database Maintenance Tasks Backup and Restore High Availability, Load Balancing, and Replication Recovery Configuration Monitoring Database Activity Monitoring Disk Usage Reliability and the Write-Ahead Log Regression Tests Client Interfaces libpq - C Library Large Objects ECPG - Embedded SQL in C The Information Schema 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
postgresdev PostgreSQL for Developers 14 hours 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. 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
postgresadmin PostgreSQL for Administrators 14 hours This course covers the administration and performance tuning of PostgreSQL databases.  Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching. What is PostgreSQL? A Brief History of PostgreSQL Conventions Further Information Bug Reporting Guidelines Introduction to PostgreSQL Installation and Creating Database The SQL Language Advanced Features The SQL Language SQL Syntax Data Definition Data Manipulation Queries Data Types Functions and Operators Foreign Data Wrappers Type Conversion Indexes Triggers Full Text Search The Information Schema PL/pgSQL - SQL Procedural Language Concurrency Control Performance Tips How the Planner Uses Statistics Server Administration Source Code vs Distribution-Provided Packages Installation from Source Code Installation from Source Code on Windows Deployment of Binaries Obtained by Compiling Source Code Server Setup, Operation Database Physical Storage Filesystem Durability Requirements and Required Mount Options Server Configuration Special Considerations for Container-Based Deployments Client Authentication Database Roles Managing Databases Localization Routine Database Maintenance Tasks Backup and Restore Recovery Configuration Monitoring Database Activity Monitoring Disk Usage Reliability and the Write-Ahead Log Regression Tests Installation of Third-Party Server Extensions High Availability, Load Balancing, and Replication Brewer's CAP Theorem Synchronous vs Asynchronous Replication Log Shipping (Warm Standby) Streaming Master-Slave Replication (Hot Standby) Trigger-Based Master-Slave Replication with Slony Trigger-Based Multi-Master Replication with Bucardo Connection Pooling and Synchronous Replication with Pgpool Failover Configurations using DRBD Replacing a Failed Server Recovering from Network Partition

Upcoming Courses

Other regions

Weekend PostgreSQL courses, Evening PostgreSQL training, PostgreSQL boot camp, PostgreSQL instructor-led , PostgreSQL coaching, PostgreSQL one on one training , PostgreSQL trainer ,Weekend PostgreSQL training, PostgreSQL private courses, PostgreSQL on-site, PostgreSQL training courses, PostgreSQL instructor, Evening PostgreSQL courses

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Programming in C# Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 4851PLN / 1870PLN
Stress management Gdynia, ul. Ejsmonda 2 Wed, 2017-10-18 09:00 5148PLN / 1530PLN
Nginx Setup, Configuration and Administration Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 6930PLN / 2700PLN
Business Analysis Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-18 09:00 7722PLN / 3774PLN
MATLAB Programming Bydgoszcz, ul. Dworcowa 94 Thu, 2017-10-19 09:00 4356PLN / 1952PLN
Projektowanie stron na urządzenia mobilne Kielce, ul. Warszawska 19 Thu, 2017-10-19 09:00 2624PLN / 1305PLN
Adobe InDesign Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-10-23 09:00 1881PLN / 1027PLN
Adobe Premiere Pro Gdynia, ul. Ejsmonda 2 Mon, 2017-10-23 09:00 3960PLN / 2480PLN
Administration of Linux System Gdynia, ul. Ejsmonda 2 Tue, 2017-10-24 09:00 4950PLN / 3225PLN
Adobe Photoshop Elements Lublin, ul. Spadochroniarzy 9 Wed, 2017-10-25 09:00 1881PLN / 1127PLN
Business Analysis, BABOK V3.0 and IIBA Certification Preparation Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-25 09:00 9405PLN / 5903PLN
Zaawansowana administracja MySQL Poznan, Garbary 100/63 Thu, 2017-10-26 09:00 3416PLN / 2108PLN
Effective working with spreadsheet in Excel Warszawa, ul. Złota 3/11 Thu, 2017-10-26 09:00 2475PLN / 1225PLN
Node.js Olsztyn, ul. Kajki 3/1 Thu, 2017-10-26 09:00 3861PLN / 2431PLN
Advisory & Leadership Skills Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-10-30 09:00 8524PLN / 2983PLN
Excel For Statistical Data Analysis Warszawa, ul. Złota 3/11 Thu, 2017-11-02 09:00 2673PLN / 1291PLN
SQL Advanced in MySQL Warszawa, ul. Złota 3/11 Thu, 2017-11-02 09:00 1881PLN / 1141PLN
Projektowanie stron na urządzenia mobilne Bielsko-Biała, Al. Armii Krajowej 220 Thu, 2017-11-02 09:00 2624PLN / 1605PLN
Symfony 3 Kraków, ul. Rzemieślnicza 1 Mon, 2017-11-06 09:00 6930PLN / 3300PLN
Oracle 11g - SQL language for developers - Workshop Bielsko-Biała, Al. Armii Krajowej 220 Mon, 2017-11-06 09:00 6930PLN / 4140PLN
Programowanie Aplikacji Webowych z Java EE 6 / 7 Zielona Góra, ul. Reja 6 Mon, 2017-11-06 09:00 7722PLN / 3340PLN
Android - The Basics Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 9801PLN / 4180PLN
Java Spring Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 14414PLN / 5970PLN
Test Automation with Selenium Łódź, ul. Tatrzańska 11 Mon, 2017-11-06 09:00 7722PLN / 3474PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Warszawa, ul. Złota 3/11 Tue, 2017-11-07 09:00 3564PLN / 1691PLN
Programming for Biologists Warszawa, ul. Złota 3/11 Tue, 2017-11-07 09:00 11781PLN / 3745PLN
Quality Assurance and Continuous Integration Wrocław, ul.Ludwika Rydygiera 2a/22 Tue, 2017-11-07 09:00 2673PLN / 1737PLN
Oracle Service Bus 11g - Design and Integration Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2017-11-07 09:00 15315PLN / 5391PLN
UML in Enterprise Architect (workshops) Warszawa, ul. Złota 3/11 Wed, 2017-11-08 09:00 5940PLN / 3570PLN
Managing Configuration with Ansible Warszawa, ul. Złota 3/11 Wed, 2017-11-08 09:00 16612PLN / 5634PLN
Tableau Advanced Gdynia, ul. Ejsmonda 2 Wed, 2017-11-08 09:00 7425PLN / 2975PLN
JMeter Fundamentals Warszawa, ul. Złota 3/11 Wed, 2017-11-08 09:00 1871PLN / 824PLN
Adobe Premiere Pro Gdańsk, ul. Powstańców Warszawskich 45 Thu, 2017-11-09 09:00 3960PLN / 2480PLN
Financial analysis in Excel Warszawa, ul. Złota 3/11 Thu, 2017-11-09 09:00 2079PLN / 1093PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Bielsko-Biała, Al. Armii Krajowej 220 Mon, 2017-11-13 09:00 5940PLN / 3730PLN
Data Analysis with Oracle 11g - workshop Gdynia, ul. Ejsmonda 2 Mon, 2017-11-13 09:00 9900PLN / 4664PLN
Nagios Core Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-11-13 09:00 13919PLN / 4968PLN
Visual Basic for Applications (VBA) in Excel - Advanced Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-11-13 09:00 3069PLN / 1773PLN
Website Development in PHP Szczecin, ul. Sienna 9 Mon, 2017-11-13 09:00 2970PLN / 1344PLN
ADO.NET 4.0 Development Warszawa, ul. Złota 3/11 Tue, 2017-11-14 09:00 20176PLN / 6914PLN
Adobe Illustrator Lublin, ul. Spadochroniarzy 9 Tue, 2017-11-14 09:00 2871PLN / 1648PLN
Linux Fundamentals Kraków, ul. Rzemieślnicza 1 Tue, 2017-11-14 09:00 10128PLN / 3869PLN
Visual Basic for Applications (VBA) in Excel - Advanced Warszawa, ul. Złota 3/11 Wed, 2017-11-15 09:00 3069PLN / 1623PLN
Access Basics Szczecin, ul. Sienna 9 Mon, 2017-11-20 09:00 3465PLN / 1550PLN
OCEB2 OMG Certified Expert in BPM - Fundamental Exam Preparation Warszawa, ul. Złota 3/11 Mon, 2017-11-20 09:00 11880PLN / 4760PLN
Introduction to Selenium Poznan, Garbary 100/63 Wed, 2017-12-20 09:00 1871PLN / 824PLN
Adobe Photoshop Warszawa, ul. Złota 3/11 Wed, 2017-12-20 09:00 1881PLN / 1152PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients