Interactive Course

Improving Query Performance in PostgreSQL

Learn how to structure your PostgreSQL queries to run in a fraction of the time.

  • 4 hours
  • 15 Videos
  • 53 Exercises
  • 977 Participants
  • 4,300 XP

Loved by learners at thousands of top companies:

whole-foods-grey.svg
mls-grey.svg
lego-grey.svg
deloitte-grey.svg
paypal-grey.svg
ikea-grey.svg

Course Description

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.

  1. 1

    Bringing Together the Data

    Free

    Bundle up as you dive into the Winter Olympics! You will learn how to join, subquery, and create temporary tables while finding which Olympic athletes brave sub-freezing temperatures to train. You will also learn about the query planner and how its functionality can guide your SQL structure to faster queries.

  2. Using Database Designed Properties

    Zero in on the properties that improve database performance. Discover when your table is not a table but a view. Learn how your database's storage structure (row or column oriented) impacts your query structure. You will explore volcanic smog while using partitions and indexes to speed your queries.

  3. Minimizing Results and Decreasing the Load

    Dig up those past algebra memories while learning the SQL order of operations. Find which countries "should" have the most athletes by looking at population and gross domestic product (GDP) while learning the best way to filter. You will also learn when your query aggregates (sums, counts, etc.) and how you can structure your query to optimize this process.

  4. Assessing Query Performance

    Learn the lingo of the Query Lifecycle and dive into the query planner. Explore how the query planner creates and optimizes the query plan. Find your next vacation locale by looking for countries with recent population growth while also seeing how a join impacts the query steps. Fine tune your optimization techniques by seeing how different filters speed your query times.

  1. 1

    Bringing Together the Data

    Free

    Bundle up as you dive into the Winter Olympics! You will learn how to join, subquery, and create temporary tables while finding which Olympic athletes brave sub-freezing temperatures to train. You will also learn about the query planner and how its functionality can guide your SQL structure to faster queries.

  2. Minimizing Results and Decreasing the Load

    Dig up those past algebra memories while learning the SQL order of operations. Find which countries "should" have the most athletes by looking at population and gross domestic product (GDP) while learning the best way to filter. You will also learn when your query aggregates (sums, counts, etc.) and how you can structure your query to optimize this process.

  3. Using Database Designed Properties

    Zero in on the properties that improve database performance. Discover when your table is not a table but a view. Learn how your database's storage structure (row or column oriented) impacts your query structure. You will explore volcanic smog while using partitions and indexes to speed your queries.

  4. Assessing Query Performance

    Learn the lingo of the Query Lifecycle and dive into the query planner. Explore how the query planner creates and optimizes the query plan. Find your next vacation locale by looking for countries with recent population growth while also seeing how a join impacts the query steps. Fine tune your optimization techniques by seeing how different filters speed your query times.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Amy McCarty
Amy McCarty

Data Analyst

Amy is a data analyst, policy wonk, and all around data nerd. She has a master's degree in policy analytics from Carnegie Mellon and has worked as an analyst in both the nonprofit and for-profit sectors. She loves to learn and shares that passion as an adjunct analytics professor. When not at the computer, Amy stays busy broadening her multicultural culinary prowess and learning to hear all of those silent consonants in the French language.

See More
Collaborators
  • Mona Khalil

    Mona Khalil

  • Becca Robins

    Becca Robins

Prerequisites
Icon Icon Icon professional info