Saltar al contenido principal
InicioSQLImproving Query Performance in PostgreSQL

Improving Query Performance in PostgreSQL

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

Comience El Curso Gratis
4 horas15 vídeos53 ejercicios
9938 aprendicesTrophyDeclaración de cumplimiento

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.
Group¿Entrenar a 2 o más personas?Pruebe DataCamp para empresas

Preferido por estudiantes en miles de empresas


Descripción del curso

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

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más
Pruebe DataCamp Para EmpresasPara obtener una solución a medida, reserve una demostración.

En las siguientes pistas

SQL para Administradores de Bases de Datos

Ir a la pista
  1. 1

    Bringing Together the Data

    Gratuito

    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.

    Reproducir Capítulo Ahora
    All about joins
    50 xp
    Where are all the athletes from
    100 xp
    Using different joins to explore athletes' regions
    100 xp
    What about the weather
    100 xp
    Subqueries and common table expressions (cte)
    50 xp
    Filtering to freezing with a subquery
    100 xp
    Where winter is white
    100 xp
    Countries with subqueries or CTEs
    100 xp
    Working with temporary tables
    50 xp
    Canadians temp table
    100 xp
    Analyze that temp table
    100 xp
  2. 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.

    Reproducir Capítulo Ahora
  3. 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.

    Reproducir Capítulo Ahora
  4. 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.

    Reproducir Capítulo Ahora
Empresas

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más

En las siguientes pistas

SQL para Administradores de Bases de Datos

Ir a la pista

conjuntos de datos

GDPOlympic AthletesOlympic RegionsAQI

colaboradores

Collaborator's avatar
Mona Khalil
Collaborator's avatar
Becca Robins

requisitos previos

Data Manipulation in SQL
Amy McCarty HeadshotAmy McCarty

Data Analyst

Ver Más

¿Qué tienen que decir otros alumnos?

¡Únete a 14 millones de estudiantes y empieza Improving Query Performance in PostgreSQL hoy mismo!

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.