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 VirtualWeekday540.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

How it works

Registration

You may enroll in the course by providing your full name and email address through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. We treat your personal data, including your full name and email address, with strict confidentiality.

Payment Options

We offer multiple payment methods, including credit cardbank transfer, and PayPal. To receive your invoice, please provide your VAT number (when applicable), address, and zip code. Again, you may provide us with this information either through our website's 'add to cart' feature or by sending an email to hello@learningactors.com. Please note that you can typically expect to receive your invoice on the first day of training, unless there are exceptional circumstances that necessitate a different approach. We’re happy to provide you with a pro-forma invoice if this meets your needs.

Expectations

Following registration, you can anticipate an info email from us approximately one week before the course start date. This email will contain course details, such as the title, date, and time, along with a request to complete a pre-course form. Additionally, we will provide the relevant Zoom link, which is  applicable for all our virtual-live courses, and will invite you to the course's Slack channel on the LA Slack workspace (learningactors.slack.com). For specific courses, you will also receive a preparation email that will set you ready for the course.
Finally, after the session concludes, we kindly request that you take a moment to provide us with your feedback, as it is of great importance to us. Additionally, we will ensure that you receive the learning material through Slack, which will be instrumental in keeping your learning journey on track!

Reminders

  • Discounts are available in two scenarios: when a single customer registers for more than three sessions or if the customer is currently unemployed. Contact the LA team to receive a discount coupon if you meet these criteria.
  • All upcoming sessions displayed on our website are guaranteed to proceed once the minimum required number of learners register. In the case that we must cancel a session, a full refund will be issued to those who have pre-paid for that specific session.