Advanced SQL Project | Netflix Data Analysis Using SQL (Guided) - Portfolio Series #4/10 - Datasets

Get this project 📁 (Datasets & Readme file)

🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems

🎯 Get Latest SQL Guided Project (1M sales records)

Best Data Analytics Course:

⏰ Timestamps:
Intro: 00:00:00 - 00:01:44
Database Setup: 00:2:00 – 00:19:00
Q1 Solution: 00:23:00 – 0:26:00
Q2 Solution: 0:26:16 – 0:32:45
Q3 Solution: 0:33:00 – 0:35:00
Q4 Solution: 0:35:16 – 0:41:25
Q5 Solution: 0:41:45 – 0:43:10
Q6 Solution: 0:43:40 – 0:46:48
Q7 Solution: 0:47:10 – 0:50:49
Q8 Solution: 0:51:00 – 0:56:56
Q9 Solution: 0:57:15 – 1:00:00
Q10 Solution: 1:01:00 – 1:06:30
Q11 Solution: 1:07:00 – 1:09:30
Q12 Solution: 1:09:45 – 1:10:30
Q13 Solution: 1:11:46 – 1:12:15
Q14 Solution: 1:12:31 – 1:16:30
Q15 Solution: 1:17:00 – 1:23:30
Project Publish Guide: 1:24:00 - 1:28:52

My Other YouTube Videos -

SQL 30 Days Road Map - [Free Learning Resources]

🐍 All Python Projects:
Python ETL - Data Cleaning Project

🛢All SQL Projects
Project 1:

Project 2:

Project 3: (Advanced SQL)
🎯 Zomato Food Company Data Analysis

Project 4:
🎯 Netflix Movies Data Analysis

Project 5:
🎯 Amazon Sales Analysis (Advanced SQL)

Project 6:
🎯 Spotify Data Analysis

Project 7: (Advanced SQL)
🎯 Apple Retail Sales Analysis - 1M Sales Records

Project 8: (Real Business Problems)
🎯 Monday Coffee Extensions Analysis

#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject

[zero_analyst]

🎯 Get Latest SQL Guided Project (1M sales records)

🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems

🐍 All Python Projects:
Python ETL - Data Cleaning Project

[pavankumar]

I CAN SAY ONE THING: Your channel is one of the Best not, THE BEST channel for SQL; you will cover all. appreciate your efforts for the yt community

[nowshadktasin]

In question number 4, a TRIM () function should be used wrapping the UNNEST(), or else it will show duplicate values (eg. in your query it shows United States twice)

[rohit_vora]

que :5
select title, substring(duration, 1, position ('m' in duration)-1)::int duration
from Netflix
where type = 'Movie' and duration is not null
order by 2 desc
limit 1

[salimmuhammed]

Question number 5:
select * from
(select distinct title as movie,
split_part(duration, ' ', 1):: numeric as duration
from netflix
where type ='Movie') as subquery
where duration = (select max(split_part(duration, ' ', 1):: numeric ) from netflix)

[echodelta]

Good dataset for teaching and well presented. The wording of the query-10 could have been better, and query-14, clearer, but overall nice exposure for candidates. Appreciate your efforts.🥂

[LoneKim]

Thank you for this project I'm really grateful to you...

And I would like to advice you to make your personal playlist as private to make your account more professional ❤

[ManishaSenapati]

Thankyou fr bringing this out, i was soo scared to learn sql but your way of teaching is making it easier . Thank you for all the efforts and time you have put to bring this 💖💯

[shawonalam]

Hi @Zero Analyst
Your qs 5. "Max duration of the longest Movie " ans(99 min) is wrong.

[NaveenNaveen-gdfi]

It is very useful for us, put video like this bro

[andreafrillian]

bro i think in #4 we have to "TRIM" our query so that {'United States'} and {' United States'} can be combine into single {'United States'} ~~

[rohit_vora]

there are some space that needed to remove for correct count in que 09 :
select *, count(1) cnt
from
(select trim(unnest(string_to_array(listed_in, ', '))) content
from Netflix)
group by 1
order by 2 desc

[Handle.smiles]

bro ans 5 is wrong as there are movies with ttime more than 100 min and
also there is no data cleaning in show_id 5542, 5795, & 5814 the duration is written on rating column

[gospelmoto]

Nice Video! Im learning alot, TYVM. However, I have a question -Why not import directly the csv dataset without needing to define the table columns? Could it be done this way?

[novicewater]

how can we solve question 4 using mysql, i am not able to find solution to split cell into multiple rows, Pls guide.

[AmanSharma-tndy]

I think you have done a wrong query in Q5.
we have a movie name 'Black Mirror: Bandersnatch' which is of 312 min
select top 1
title,
type,
cast(Replace(duration, 'min', '') as int) as duration
from Netflix where type='Movie' order by duration desc
If I am wrong, pls correct me.

[pinkythanu]

So, i am from different background in IT and want to switch to Data analyst role... Will these kind of projects consider as mini project in resume or what can i do for my small project experience...Pls guide

[MOTIVATIONALQUOTE-wtde]

hlo sir,
can you tell how you move all the table name to right indentation ?
like in video you select all the things and then you move it in right. but how?

[ravikanth]

Bro I thought you would help me to build logic for sql queries but aap toh dusre hi direction me jaa rahe ho. 😊

[bhojrajgaddam]

Hey bro, could you please adjust your camera and screen so they're aligned? Turning your head so often might strain your neck over time. It would be great if you could set them up in a way where you don’t have to keep turning your head