DataCamp
FreeImproving Query Performance in PostgreSQL
4.8(425)13k studentsINTERMEDIATEEnglish
Korshub's take
Overview
This intermediate database course teaches how to optimize and restructure slow PostgreSQL queries for high efficiency. By analyzing datasets covering Olympic participation, climate statistics, GDP, and volcanic air quality in Hawaii, you learn how filtering methods, subqueries, the query planner, and SQL order of operations influence execution speed in row-oriented databases.
Who It Is For
Intermediate SQL users, PostgreSQL database developers, and data analysts looking to accelerate database queries and improve code structure.
Key Takeaways
- Analyze query execution using the PostgreSQL query planner and SQL order of operations.
- Optimize query speed through efficient filtering techniques and subquery restructuring.
- Understand row-oriented database storage mechanics to write clean, high-performance SQL.
About this course
Losing time on slow queries? Hesitant to share your queries with more seasoned coworkers? In this course, you will learn how to structure your PostgreSQL to run in a fraction of the time. Exploring intertwined data relating Olympic participation, country climate, and gross domestic product, you will experience firsthand how changes in filtering method and using subqueries impact query performance. You will learn the properties of a row oriented database while also seeing how Hawaii's volcanos impact air quality. Restructuring your queries with the query planner and the SQL order of operations, you will soon be dazzling your coworkers with your effortless efficiency.
Price
Free
This course is free to enrol.
Advertisement
