Data Manipulation using SQL

Data Manipulation using SQL

0%

1. Database and Nested Queries

We shall take a look at the database we'll work with and how we can create a query inside another query.

SQL In Statement

Challenge In Statement

SQL Exists Statement

2. SQL Joining Tables

Learn how to join and work with multiple tables.

SQL Left & Right Join

SQL Full Outer Join

3. SQL Tasks

Try creating queries with no limits on how you should do that. Use all your knowledge from previous chapters!

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

Course Content

Data Manipulation using SQL

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

SQL Full Outer Join

Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:

All uncompleted fields got the value NULL.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 2. Chapter 4

toggle bottom row

SQL Full Outer Join

Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:

All uncompleted fields got the value NULL.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 2. Chapter 4

toggle bottom row

SQL Full Outer Join

Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:

All uncompleted fields got the value NULL.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:

All uncompleted fields got the value NULL.

Task

For each singer, find the most expensive (price) song and the newest (year) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming, songs.price with price alias, and albums.year with year alias values.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 2. Chapter 4

Switch to desktop for real-world practiceContinue from where you are using one of the options below

some-alt