Advanced SQL Full Course | Master Joins, Window Functions, Subqueries, CTEs in SQL
This SQL Full Course is a comprehensive guide to learning SQL, covering both beginner and advanced topics. In this 2-hour tutorial, you will gain a solid understanding of SQL joins, subqueries, set operations, window functions, and data manipulation techniques. Whether you are new to SQL or looking to enhance your skills, this course provides a structured approach to mastering essential SQL concepts.
🧑💻 Why Watch This SQL Full Course?
This course explains the fundamentals of SQL in a clear and structured way. It covers SQL joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and CROSS JOIN. Advanced topics like subqueries, Common Table Expressions (CTEs), and window functions are also included. You’ll also learn about set operations like UNION, INTERSECT, and EXCEPT, with real-world examples using datasets such as the World Leaders Database and the European Soccer Database. The course includes hands-on exercises to help you practice and apply what you’ve learned.
🧠 What You’ll Learn in This SQL Tutorial:
You will learn how to perform SQL joins to combine data from multiple tables, use subqueries for filtering and restructuring data, and apply window functions to calculate rankings and running totals. The course also teaches how to optimize SQL queries using Common Table Expressions (CTEs) and demonstrates real-world data analysis examples to reinforce key concepts.
Video Highlights 📕
00:00 Introduction
00:24 Inner Joins
04:48 Defining Relationships
07:49 Multiple Joins
11:15 Left and Right Joins
15:03 Full Joins
17:44 Cross Joins
19:26 Self Joins
22:00 Set Theory
26:20 Using Intersect
29:18 Using Except
30:45 Semi Joins & Anti Joins
34:50 Subqueries in Select and Where
37:25 Subqueries inside From
39:40 Joining Data Wrap-Up
40:52 We'll take the CASE
45:19 In CASE things get more complex
50:00 CASE WHEN with aggregate functions
54:38 WHERE are the Subqueries?
59:28 Subqueries in FROM
1:03:27 Subqueries in SELECT
1:07:26 Subqueries everywhere! And bes
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from DataCamp · DataCamp · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
SQL Server Tutorial: Date manipulation
DataCamp
R Tutorial: Intermediate Interactive Data Visualization with plotly in R
DataCamp
R Tutorial: Adding aesthetics to represent a variable
DataCamp
R Tutorial: Moving Beyond Simple Interactivity
DataCamp
Python Tutorial: Why use ML for marketing? Strategies and use cases
DataCamp
Python Tutorial: Preparation for modeling
DataCamp
Python Tutorial: Machine Learning modeling steps
DataCamp
R Tutorial: The prior model
DataCamp
R Tutorial: Data & the likelihood
DataCamp
R Tutorial: The posterior model
DataCamp
R Tutorial: An Introduction to plotly
DataCamp
R Tutorial: Plotting a single variable
DataCamp
R Tutorial: Bivariate graphics
DataCamp
Python Tutorial: Customer Segmentation in Python
DataCamp
Python Tutorial: Time cohorts
DataCamp
Python Tutorial: Calculate cohort metrics
DataCamp
Python Tutorial: Cohort analysis visualization
DataCamp
R Tutorial: Building Dashboards with flexdashboard
DataCamp
R Tutorial: Anatomy of a flexdashboard
DataCamp
R Tutorial: Layout basics
DataCamp
R Tutorial: Advanced layouts
DataCamp
Python Tutorial: Time Series Analysis in Python
DataCamp
Python Tutorial: Correlation of Two Time Series
DataCamp
Python Tutorial: Simple Linear Regressions
DataCamp
Python Tutorial: Autocorrelation
DataCamp
R Tutorial: The gapminder dataset
DataCamp
R Tutorial: The filter verb
DataCamp
R Tutorial: The arrange verb
DataCamp
R Tutorial: The mutate verb
DataCamp
R Tutorial: What is cluster analysis?
DataCamp
R Tutorial: Distance between two observations
DataCamp
R Tutorial: The importance of scale
DataCamp
R Tutorial: Measuring distance for categorical data
DataCamp
Python Tutorial: Plotting multiple graphs
DataCamp
Python Tutorial: Customizing axes
DataCamp
Python Tutorial: Legends, annotations, & styles
DataCamp
Python Tutorial: Introduction to iterators
DataCamp
Python Tutorial: Playing with iterators
DataCamp
Python Tutorial: Using iterators to load large files into memory
DataCamp
SQL Tutorial: Introduction to Relational Databases in SQL
DataCamp
SQL Tutorial: Tables: At the core of every database
DataCamp
SQL Tutorial: Update your database as the structure changes
DataCamp
Python Tutorial: Classification-Tree Learning
DataCamp
Python Tutorial: Decision-Tree for Classification
DataCamp
Python Tutorial: Decision-Tree for Regression
DataCamp
Python Tutorial: Census Subject Tables
DataCamp
Python Tutorial: Census Geography
DataCamp
Python Tutorial: Using the Census API
DataCamp
R Tutorial: A/B Testing in R
DataCamp
R Tutorial: Baseline Conversion Rates
DataCamp
R Tutorial: Designing an Experiment - Power Analysis
DataCamp
R Tutorial: Introduction to qualitative data
DataCamp
R Tutorial: Understanding your qualitative variables
DataCamp
R Tutorial: Making Better Plots
DataCamp
SQL Tutorial: OLTP and OLAP
DataCamp
SQL Tutorial: Storing data
DataCamp
SQL Tutorial: Database design
DataCamp
Python Tutorial: Introduction to spaCy
DataCamp
Python Tutorial: Statistical Models
DataCamp
Python Tutorial: Rule-based Matching
DataCamp
More on: SQL Analytics
View skill →
Related AI Lessons
Chapters (22)
Introduction
0:24
Inner Joins
4:48
Defining Relationships
7:49
Multiple Joins
11:15
Left and Right Joins
15:03
Full Joins
17:44
Cross Joins
19:26
Self Joins
22:00
Set Theory
26:20
Using Intersect
29:18
Using Except
30:45
Semi Joins & Anti Joins
34:50
Subqueries in Select and Where
37:25
Subqueries inside From
39:40
Joining Data Wrap-Up
40:52
We'll take the CASE
45:19
In CASE things get more complex
50:00
CASE WHEN with aggregate functions
54:38
WHERE are the Subqueries?
59:28
Subqueries in FROM
1:03:27
Subqueries in SELECT
1:07:26
Subqueries everywhere! And bes
🎓
Tutor Explanation
DeepCamp AI