Up next

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

0 Views· 09/15/24
wisdom
wisdom
116 Subscribers
116

Book 1:1 Mentorship - https://topmate.io/zero_analyst
SQL Live Workshop - https://zeroanalyst.com/course/
Excel Live Workshop - https://zeroanalyst.com/course/

Best Data Analytics Course:
Data Analyst Courses by Meta - https://imp.i384100.net/vNRe73
Data Analytics Foundation by Google - https://imp.i384100.net/4PQ610
Microsoft Business Analyst Course - https://imp.i384100.net/NkOArq
Microsoft Power Bi End to End Course - https://imp.i384100.net/KjnkD7


⏰ 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 -
How to Install PostgreSQL in Windows/Mac - https://www.youtube.com/watch?v=x73dpaYzFoY&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc

SQL 30 Days Road Map - [Free Learning Resources]
- https://www.youtube.com/watch?v=4hiukA6L6eA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=4


How Import Data into PostgreSQL (PgAdmin 4) - https://www.youtube.com/watch?v=KIc7VQ3IsTA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=3

Group By Video - https://www.youtube.com/watch?v=4hiukA6L6eA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=4


Get the Complete Project: (Free)
Get the project dataset:
https://github.com/najirh/netflix_sql_project

In this video, we’ll explore how to analyze Netflix’s Movies and TV Shows dataset using SQL by solving 15 real-world business problems! 📊 This project covers various SQL techniques and queries to extract valuable insights from the data, such as:
Counting the number of Movies vs TV Shows
Identifying the most common ratings for each type of content
Finding top countries with the most Netflix content
Exploring content duration and release years
Categorizing content based on keywords like 'Kill' and 'Violence'
This tutorial is perfect for Data Analysts, SQL Beginners, and anyone interested in improving their SQL skills. Whether you're working on a data analysis project or preparing for interviews, this walkthrough will help you practice real-world problem-solving using SQL.




What You'll Learn:
Database Design: Structure databases with tables and relationships.
Data Importing: Properly import data into your database.
SQL Queries: Solve complex business problems, including:
String Function in SQL
Array Function in SQL


1:1 Mentorship - https://topmate.io/zero_analyst
SQL Live Workshop - https://zeroanalyst.com/course/
Excel Live Workshop - https://zeroanalyst.com/course/

Best Data Analytics Course:
Data Analyst Courses by Meta - https://imp.i384100.net/vNRe73
Data Analytics Foundation by Google - https://imp.i384100.net/4PQ610
Microsoft Business Analyst Course - https://imp.i384100.net/NkOArq
Microsoft Power Bi End to End Course - https://imp.i384100.net/KjnkD7


My Other YouTube Videos -
SQL 30 Days Road Map - [Free Learning Resources]
- https://www.youtube.com/watch?v=4hiukA6L6eA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=4

How to Install PostgreSQL in Windows/Mac - https://www.youtube.com/watch?v=x73dpaYzFoY&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc

How Import Data into PostgreSQL (PgAdmin 4) - https://www.youtube.com/watch?v=KIc7VQ3IsTA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=3

Group By Video - https://www.youtube.com/watch?v=4hiukA6L6eA&list=PLF2u7Zn-dIxaCq1J8zapXKGCUQRHJRWRc&index=4



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

Show more

 0 Comments sort   Sort By


Facebook Comments

Up next