Boost your PostgreSQL^® skills: Beginner's guide to SQL optimization.

What's in the Workshop Recipe?

SQL optimization is essential for efficient database management, especially when dealing with complex queries and large datasets. In this workshop, you'll familiarize with the fundamentals of SQL optimization with a focus on PostgreSQL®. This hands-on session will guide you through key techniques and best practices to enhance the performance of your SQL queries.

We'll look at how PostgreSQL processes queries, helping you spot any bottlenecks and areas that need improvement. You'll learn how to use indexes effectively to speed up your queries without overdoing it. We'll also explore the best ways to use joins in your queries, when to use them for the best performance.

We'll discuss how PostgreSQL handles data changes, what table bloat is, and why regular vacuuming is crucial for keeping your database in good shape. Plus, we’ll show the usage of AI tools to identify and troubleshoot common query performance issues using practical examples.

You'll get plenty of hands-on experience. It's going to be a fun and informative session, so don't miss out!

What You'll Learn

In this workshop, we’ll cover the following topics:

• Understanding the query execution flow and path of the query.
• Using tools such as ANALYSE and EXPLAIN
• Efficient usage of indexing
• To join or not to join that is the question
• Spotting query issues
• Reason behind the table bloat and why we need to vacuum the data
• Applying UI Tools

Prerequisites

• A web browser.
• An Aiven account, using our free trial. We will lead you through setting that up in the workshop, if you don’t already have one.
• A GitHub account. Here’s the GitHub repository we’ll be using.
• We’ll use GitHub Codespaces as our working environment.