PostgreSQL Training in Област Пловдив (Plovdiv Province)

PostgreSQL Training in Област Пловдив (Plovdiv Province)
PostgreSQL (AKA Postgres) Training courses

Пловдив (Plovdiv)

NobleProg Пловдив (Plovdiv)
bul. "Sankt Peterburg" 38
4000
Bulgaria
BG
Пловдив (Plovdiv)
Plovdiv Airport - 10 km Sofia Airport - 150 kmRead more

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 Course Events - Област Пловдив (Plovdiv Province)

No Course Events scheduled for this location at the moment.
Please choose a different location or Request a Date >>

Course Outlines

Code Name Duration Outline
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
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
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

Other regions

PostgreSQL training courses in Област Пловдив (Plovdiv Province), Weekend PostgreSQL courses in Област Пловдив (Plovdiv Province), Evening PostgreSQL training in Област Пловдив (Plovdiv Province), PostgreSQL instructor-led in Област Пловдив (Plovdiv Province) , PostgreSQL private courses in Област Пловдив (Plovdiv Province), PostgreSQL instructor-led in Област Пловдив (Plovdiv Province), PostgreSQL coaching in Област Пловдив (Plovdiv Province), PostgreSQL one on one training in Област Пловдив (Plovdiv Province), PostgreSQL trainer in Област Пловдив (Plovdiv Province),Weekend PostgreSQL training in Област Пловдив (Plovdiv Province), PostgreSQL boot camp in Област Пловдив (Plovdiv Province), PostgreSQL instructor in Област Пловдив (Plovdiv Province), PostgreSQL on-site in Област Пловдив (Plovdiv Province), Evening PostgreSQL courses in Област Пловдив (Plovdiv Province)

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