PostgreSQL Advanced Development & Performance

IT spetsialistile

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.

After finishing this course student has acquired skills in:

  • Advanced PostgreSQL development
  • Advanced application design
  • Advanced tuning and performance
  • Advanced database architecture with PostgreSQL

Prerequisites

We welcome develeopers and administrators who have basic knowledge of programming, system administration,  PostgreSQL database administration and general postgreSQL and SQL basics.


Investeering: 1150,00 € + km
Lektor: Hannu Krosing
Päevade arv: 3
Tundide arv: 24 akadeemilist tundi

Sihtgrupp:This class is suitable for developers and database administarators.

Programm:
  • 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

Learning methods: Practical exercise, independent work.

Assesment methods: Execution of independent work.

Assesment form: Independent practical tasks on relevant topics.

Price includes coffee breaks in the training center and lunches restoran "Lusikas".



Küsi lisa
Sulge