EncartaLabs

PostgreSQL Advanced Development & Performance Tuning

( Duration: 3 Days )

The PostgreSQL Advanced Development & Performance Tuning training course covers advanced internals knowledge and detailed coverage of how SQL executes, giving a good knowledge of server and application tuning.

To attend this PostgreSQL Advanced Development & Performance Tuning workshop, Participants should know the basics of programming , basics of PostgreSQL database administration , PostgreSQL basics and SQL basics.

COURSE AGENDA

1

Server Architecture & Tuning

2

MVCC, VACUUM and HOT

3

Locking & Concurrency

4

Advanced Development Summary

5

Reading EXPLAINs

6

Workload Analysis & Profiling

7

Join Planning

8

SQL Performance Tips & Tricks

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top