Advanced Development & Performance

This class covers important Intermediate and Advanced level details for developers interacting with PostgreSQL, starting with the overall database architecture, and following with details about crucial features like MVCC or locking, and what consequences that has on applications or maintenance. The course also discusses how to analyze execution plans of queries, indexing options and other tips or tricks related to performance and database tuning. Suitable for both database administrators and application developers using Java, PHP, Python, perl, .Net or any other client languages.

Prerequisites Topics Acquired skills

• Basics of programming

• Basics of systems administration

• Basics of PostgreSQL database administration

• PostgreSQL basics

• SQL basics

We recommend you attend ‘PostgreSQL Database Administration’ course before attending this course.

• Server Architecture & Caching

• Tuning Parameters

• MVCC, VACUUM and HOT

• Locking & Concurrency

• Database design alternatives

• Advanced Development Summary

• Reading EXPLAINs

• Workload Analysis, Benchmarking and Profiling

• Join Planning

• Indexes

• SQL Performance Tips & Tricks

• Advanced PostgreSQL development

• Advanced application design

• Advanced tuning and performance

• Advanced database architecture with PostgreSQL

Tags: Database Administration, Database Development

Code: PGADPEN
Length: 3.00 days
Price: £ 1800

Upcoming related events


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.