SQL Tutorial for Beginners

SQL Tutorial for Beginners

0%

1. Database & Introduction to Syntax

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

Select the Songs!

SQL Select Column

Challenge Where

SQL And, Or, Not

2. SQL Aggregate Functions

Move forward to functions.

SQL Min and Max

Challenge Min and Max

SQL Count, Sum, Avg

Challenge Count

3. Filtering Statements

Learn how to filter your selected data.

Challenge Order By

Challenge Group By

SQL Top and Limit

Challenge Having

Contenido del Curso

SQL Tutorial for Beginners

SQL Tutorial for Beginners

1. Database & Introduction to Syntax

Meet the SQL Select the Songs!SQL Select Column SQL Distinct SQL Where Challenge Where SQL And, Or, Not

2. SQL Aggregate Functions

SQL Min and Max Challenge Min and Max SQL Count, Sum, Avg Challenge Count

3. Filtering Statements

SQL Null SQL Like Challenge Like SQL Between SQL Order By Challenge Order By SQL Group By Challenge Group By SQL Top and Limit SQL Aliases SQL Having Challenge Having SQL Comments

Challenge Having

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 3. Capítulo 12

toggle bottom row

Challenge Having

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 3. Capítulo 12

toggle bottom row

Challenge Having

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Tarea

Let's find the total value of each album with more than 1 song. To do that, you should group songs by their albums and count the total price of songs. Display the album, the number of songs in it, and the price of the album, starting with the most expensive.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

Sección 3. Capítulo 12

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

some-alt