Administration, Monitoring & Optimization in PostgreSQL

...
This is a virtual classroom course. You can find more information about our virtual classroom here

This is a 12-hour hands-on workshop on PostgreSQL with ultimate goal to make participants feel comfortable with the operations of Administrating, Monitoring & Optimization of PostgreSQL.

A discount is available when:
  • a single customer proceeds with more than three registrations for a particular session;
  • a learner is not currently employed.
Please contact us to receive your discount coupon if you meet any of the above-mentioned criteria.

Please also note that the upcoming sessions are guaranteed to run once they have a minimum number of learners registered.
Total price:
440.00540.00 final price

Available Sessions

DateTimezoneTraining TypeWeekend-WeekdayDescriptionPrice 
1, 3, 5/7/2024, 10:00 am-2:00 pm (EEST)Europe/AthensLive VirtualWeekday440.00540.00 final price
4, 6, 8/11/2024, 10:00 am-2:00 pm (EET)Europe/AthensLive VirtualWeekday440.00540.00 final price

This is a 12-hour hands-on workshop on PostgreSQL with ultimate goal to make participants feel comfortable with the operations of Administrating, Monitoring & Optimization of PostgreSQL.

Who should attend

Anyone wishing to gain knowledge of PostgreSQL. This includes:

  • DevOps Engineers
  • Site Reliability Engineers (SREs)
  • Software Engineers

Prerequisites

The course will be more valuable for tech professionals with prior experience in using databases.

What will you learn

The course will start with core PostgreSQL architecture elements and then will progress incrementally with real world scenarios to cover the following topics: 

  • Introduction to PostgreSQL Architecture (memory model, filesystem, execution engine) 
  • Database Monitoring (key metrics and ways to collect them) 
  • Table and Index Management (Different Indexing Options, Data layout optimizations, VACUUM operations ) 
  • SQL Performance Tuning using Query Planner and Metrics 
  • Transaction Management for optimizing Latency or Throughput, tuning WAL. 
  • Extensions (installing, managing, operating) 
  • Table Partitioning  
  • Connection Management and Pooling  
  • High Availability Architecture options  
  • Foreign Data Wrappers  
  • Database Security  
  • Upgrading Practices 

We are using a real world instance running to test different scenarios, load data and run queries. 

Date

1, 3, 5/7/2024, 10:00 am-2:00 pm (EEST), 4, 6, 8/11/2024, 10:00 am-2:00 pm (EET)

Timezone

Training Type

Weekend-Weekday