Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering SQL For Data Analysis
Introduction & Setup
Introduction to SQL for Data Analysis (4:10)
Introduction to Databases (10:53)
SQL Server Installation (10:30)
SQL Commands (5:08)
Building a Relational Database
Building a Relational Database 1 (3:13)
Building a Relational Database 2 (8:33)
Building a Relational Database 3 (9:16)
Building a Relational Database 4 (12:43)
Building a Relational Database 5 (11:25)
Assignment
Database Querying
Data Retrieval (7:52)
Data Retrieval 2 (6:48)
Data Retrieval 3 (9:29)
Data Retrieval 4 (2:27)
Data Retrieval 5 (7:05)
Data Retrieval 6 (10:33)
Assignment
Operators in SQL
AND Operator (10:18)
OR Operator (3:17)
IN Operator (7:23)
NOT IN Operator (3:19)
BETWEEN Operator (7:05)
LIKE Operator (8:53)
CASE Statement (10:41)
Assignment
Combining Data in SQL
INNER JOIN in SQL (9:38)
LEFT JOIN in SQL (3:58)
RIGHT JOIN in SQL (5:43)
FULL JOIN in SQL (4:44)
Set Operations in SQL (3:43)
Set Operations in SQL 2 (4:50)
Assignment
Subquery and CTEs in SQL
Subquery in SQL 1 (5:21)
Subquery in SQL 2 (9:03)
Subquery in SQL 3 (7:05)
Common Table Expressions in SQL (10:21)
Assignment
Formatting in SQL
Text Formatting 1 (8:32)
Text Formatting 2 (9:51)
Text Formatting 3 (11:46)
Text Formatting 4 (9:50)
Text Formatting 5 (4:09)
Number Formatting (13:50)
Date Formatting 1 (10:22)
Date Formatting 2 (3:38)
Assignment
Stored Procedure in SQL
Stored Procedure (14:35)
Stored Procedure 2 (8:27)
Assignment
Bonus
Best Practices in SQL (3:07)
Common Table Expressions in SQL
Download
Common Table Expressions.sql
Complete and Continue