Contenido del Curso

Data Manipulation using SQL

1. Database and Nested Queries

Database SQL In Statement Challenge In Statement SQL Exists Statement

2. SQL Joining Tables

SQL Inner Join SQL Joins SQL Left & Right Join SQL Full Outer Join SQL Union

3. SQL Tasks

Challenge: Albums with Two Songs Challenge: the Biggest Album Challenge: Rating of Singers Challenge: Decades Challenge: Two Singers Challenge: Solo vs Bands Challenge: Solo Albums Challenge: Singers Stats

Challenge: Albums with Two Songs

Congratulations! Now you are ready to create queries in SQL.

We will use the same database with tables songs, singers and albums.

songs

albums

singers

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

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 1

Challenge: Albums with Two Songs

Congratulations! Now you are ready to create queries in SQL.

We will use the same database with tables songs, singers and albums.

songs

albums

singers

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

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 1

Challenge: Albums with Two Songs

Congratulations! Now you are ready to create queries in SQL.

We will use the same database with tables songs, singers and albums.

songs

albums

singers

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

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

¿Todo estuvo claro?

Congratulations! Now you are ready to create queries in SQL.

We will use the same database with tables songs, singers and albums.

songs

albums

singers

Tarea

Find the album's ids (id), titles (title) and release dates (year) with number of songs equal to 2. Order these albums from oldest to newest.

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 1

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