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

Conteúdo do 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

Tarefa

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.

Tarefa

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.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 3. Capítulo 12

toggle bottom row

Challenge Having

Tarefa

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.

Tarefa

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.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 3. Capítulo 12

toggle bottom row

Challenge Having

Tarefa

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.

Tarefa

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.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Tarefa

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.

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Seção 3. Capítulo 12

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

some-alt