Performing Data Aggregation using SQL Aggregate Functions

4.8
estrellas

60 calificaciones

ofrecido por

2898 ya inscrito

En este proyecto guiado, tú:
2 hours
Intermedio
No se necesita descarga
Video de pantalla dividida
Inglés (English)
Solo escritorio

In this 2-hour long project-based course, you will learn how to retrieve data from tables in a database using SQL SELECT statement with SQL Aggregate functions. The aggregate functions we will consider in this project are COUNT, SUM, MIN, MAX and AVG. Aggregate functions are used to summarize data from rows of a table into a single value. In addition, you will learn how to set conditions on the output of an aggregate function using the HAVING clause. Finally, you will learn how to tidy up the result set of aggregate functions using the ROUND function. Note: You do not need to be a data administrator or data analyst to be successful in this guided project, just a familiarity with querying databases using SQL SELECT statement suffice for this project. If you are not familiar with SQL and want to learn the basics, start with my previous guided projects titled “Performing Data definition and Manipulation in SQL." and “Querying Databases using SQL SELECT statement”

Habilidades que desarrollarás

  • Data Management

  • Data Manipulation

  • Relational Database

  • Postgresql

  • Data Aggregation

Aprende paso a paso

En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:

Cómo funcionan los proyectos guiados

Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.

En un video de pantalla dividida, tu instructor te guía paso a paso

Reseñas

Principales reseñas sobre PERFORMING DATA AGGREGATION USING SQL AGGREGATE FUNCTIONS

Ver todas las reseñas

Preguntas Frecuentes