Uploaded August 2024 | Updated November 2026, 3 hours ago
Learn ADVANCED SQL with 10 PRACTICAL QUERIES in this video.
π₯ Course page π chandoo.org/dac
You will be learning:
How to use WHERE clause in SQL
Work with AND / OR / LIKE / IN operators in SQL
Getting DISTINCT values with SQL
Grouping data with GROUP BY
Using SQL JOINS
Creating Common Table Expressions (CTE)
Business Analysis and Decision Making with SQL
For the purpose of this video, we will be using the Sakila sample database of MySQL. I explain the process of installing MySQL and the sample databases in the previous video of this series here -
youtu.be/Iceaqdy7mEs
The queries we will be developing are:
# 1) All films with PG-13 films with rental rate of 2.99 or lower
# 2) All films that have deleted scenes
# 3) All active customers
# 4) Names of customers who rented a movie on 26th July 2005
# 5) Distinct names of customers who rented a movie on 26th July 2005
# 6) How many rentals we do on each day?
# 7) All Sci-fi films in our catalogue
# 8) Customers and how many movies they rented from us so far?
# 9) Which movies should we discontinue from our catalogue (less than 2 lifetime rentals)
# 10) Which movies are not returned yet?
# H1) How many distinct last names we have in the data?
# H2) How much money and rentals we make for Store 1 by day?
# What are the three top earning days so far?
~
β± VIDEO TOPICS:
===============
0:00 - Introduction to Advanced SQL
0:48 - How to understand the structure of any dataset? (ERD)
4:30 - Primary vs. Foreign Key
7:30 - Let's write SQL queries
7:50 - Query 1
11:32 - Query 2
13:37 - Query 3
14:28 - Homework
14:43 - Query 4
19:32 - Bonus Query
20:34 - Query 5
21:43 - Homework
22:04 - Query 6
24:42 - Query 7
29:15 - Query 8
32:10 - Query 9
35:36 - How to use CTEs (Common Table Expressions)
38:37 - Query 10
42:06 - Homework
42:45 - Limitations of SQL
π Sample data and completed queries:
=================================
For all sample files, completed queries and homework solutions, visit the page below:
chandoo.org/dac
π₯ ADVANCED DATA COURSES BY CHANDOO
======================================
If you want to learn advanced Excel and / or Power BI, consider my paid courses. These in-depth courses cover the entire spectrum of Excel, Power BI, Power Query, Power Pivot and Dashboard reporting in one place with plenty of real-world examples, portfolio projects and completion certificate.
Check out these links:
Advanced Excel Course - chandoo.org/wp/excel-school-program
Advanced Power BI Course - chandoo.org/wp/power-bi-course
~
#sql #database #chandoo #freedataanalystcourse #fdac
Learn ADVANCED SQL with 10 PRACTICAL QUERIES in this video.
π₯ Course page π chandoo.org/dac
You will be learning:
How to use WHERE clause in SQL
Work with AND / OR / LIKE / IN operators in SQL
Getting DISTINCT values with SQL
Grouping data with GROUP BY
Using SQL JOINS
Creating Common Table Expressions (CTE)
Business Analysis and Decision Making with SQL
For the purpose of this video, we will be using the Sakila sample database of MySQL. I explain the process of installing MySQL and the sample databases in the previous video of this series here -
youtu.be/Iceaqdy7mEs
The queries we will be developing are:
# 1) All films with PG-13 films with rental rate of 2.99 or lower
# 2) All films that have deleted scenes
# 3) All active customers
# 4) Names of customers who rented a movie on 26th July 2005
# 5) Distinct names of customers who rented a movie on 26th July 2005
# 6) How many rentals we do on each day?
# 7) All Sci-fi films in our catalogue
# 8) Customers and how many movies they rented from us so far?
# 9) Which movies should we discontinue from our catalogue (less than 2 lifetime rentals)
# 10) Which movies are not returned yet?
# H1) How many distinct last names we have in the data?
# H2) How much money and rentals we make for Store 1 by day?
# What are the three top earning days so far?
~
β± VIDEO TOPICS:
===============
0:00 - Introduction to Advanced SQL
0:48 - How to understand the structure of any dataset? (ERD)
4:30 - Primary vs. Foreign Key
7:30 - Let's write SQL queries
7:50 - Query 1
11:32 - Query 2
13:37 - Query 3
14:28 - Homework
14:43 - Query 4
19:32 - Bonus Query
20:34 - Query 5
21:43 - Homework
22:04 - Query 6
24:42 - Query 7
29:15 - Query 8
32:10 - Query 9
35:36 - How to use CTEs (Common Table Expressions)
38:37 - Query 10
42:06 - Homework
42:45 - Limitations of SQL
π Sample data and completed queries:
=================================
For all sample files, completed queries and homework solutions, visit the page below:
chandoo.org/dac
π₯ ADVANCED DATA COURSES BY CHANDOO
======================================
If you want to learn advanced Excel and / or Power BI, consider my paid courses. These in-depth courses cover the entire spectrum of Excel, Power BI, Power Query, Power Pivot and Dashboard reporting in one place with plenty of real-world examples, portfolio projects and completion certificate.
Check out these links:
Advanced Excel Course - chandoo.org/wp/excel-school-program
Advanced Power BI Course - chandoo.org/wp/power-bi-course
~
#sql #database #chandoo #freedataanalystcourse #fdac
![How many days overlap between two projects [Excel Formula Magic]
Find out quickly how many days both projects overlap using this elegant and simple Excel formula How many days overlap between two projects [Excel Formula Magic]](https://i.ytimg.com/vi/EqALWpxps0I/mqdefault.jpg)

![How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]
Power BIs new Visual Calculation feature allows us to do advanced business logic and analytics without the need for complicated (and often messy) DAX. In this video let me demonstrate the power of visual calculations with a cool month on month comparison chart.
Learn how to build report and perform data analysis from scratch, making your data visualization more impactful.
In the video:
0:00 - Demo of Visual Calculation driven sales report
0:25 - Data model for the report
0:50 - Creating the line chart
1:50 - Creating your first visual calculation in Power BI
3:40 - Converting the line to combination chart
4:30 - Fixing the first value in the chart (to blank)
6:15 - Dynamic coloring of columns - positive is green, negative is red
7:40 - Adjusting the axis scaling issues (advanced concept)
9:30 - Adding Axis Max as a measure for dynamic axis scaling
#powerbi #visualcalcs How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]](https://i.ytimg.com/vi/FCAWIHlknQI/mqdefault.jpg)







