Зміст курсу

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

Завдання

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.

Завдання

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.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 3. Розділ 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

Завдання

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.

Завдання

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.

Все було зрозуміло?

Секція 3. Розділ 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

Завдання

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.

Завдання

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.

Все було зрозуміло?

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

Завдання

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.

Секція 3. Розділ 1