Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics Certificate Course
Getting Started
Join our Discord Community (4:23)
How to Ask Questions Throughout the Course
Module 1: Introduction to SQL Basics
1.1 Data, Databases, & SQL (4:27)
1.2 Creating & Querying Tables (5:10)
1.3 SQL Challenge #1 (1:09)
1.4 Aggregating Data (3:05)
1.5 SQL Challenge #2
1.6 SQL Project #1: Superstore Analysis
1.7 Create Your SQL Portfolio (We'll Add Projects Throughout the Course!) (2:51)
1.8 Your First Achievement in SQL
Module 2: Advanced SQL Basics
2.1 Intro to Advanced SQL (0:32)
2.2 Queries with AND/OR (3:50)
2.3 SQL Challenge #3
2.4 Subqueries and "IN" or "NOT IN" Operators (5:12)
2.5 SQL Challenge #4
2.6 The HAVING Clause (5:16)
2.7 SQL Challenge #5
2.8 CASE Statements (5:33)
2.9 SQL Challenge #6
2.10 SQL Project #2: Fortune 500 Analysis
2.11 Your Second SQL Certificate
Module 3: Relational Queries in SQL
3.1 Introduction to SQL Joins (6:45)
3.2 SQL Challenge #7
3.3 Inner, Left, Right, and Full Joins (6:20)
3.4 Challenge #8
3.5 Multiple Joins in One SQL Query (8:49)
3.6 Challenge #9
3.7 Project #3: Netflix Database Analysis (8:19)
3.8 Relational Queries in SQL Certificate
Module 4: SQL Bootcamp
4.0 Welcome to the SQL Bootcamp
4.1 RDBMS: Relational Database Management Systems (2:53)
4.2 SQLite Studio Download & Database Setup
4.3 Customer & Order Analytics Project
4.4 Advanced Data Filtering Techniques in SQL
4.5 SQL Order of Execution
4.6 Advanced Customer & Order Analytics
4.7 Spotify Data Analytics Project
4.8 CTEs: Common Table Expressions ("Temporary Tables")
4.9 More CTE Practice with Bike Lane Data
4.10 How to Solve Unique SQL Problems (Window Functions Practice)
4.11 How to use AI to Debug your SQL Queries (ChatGPT Example)
4.12 Additional Practice & Resources
4.13 Final SQL Project
4.14 SQL Test Study Guide
4.15 SQL Test
4.16 Certificate of Achievement in SQL
Module 5: Using Tableau to Visualize Data
5.1 Intro to Tableau (1:49)
5.2 Connecting Tableau to Data (3:41)
5.3 Building a Tableau Dashboard: World COVID Data Project (29:44)
5.4 Tableau Product & Order Analytics Project
5.5 Tableau Product & Order Analytics Project, Part 2
5.6 Tableau Creator Training: Executive Overview Project
5.7 World Happiness Report Dashboard Project
5.8 Certificate of Achievement in Tableau
5.9 Troubleshooting
Module 6: Bringing It All Together
6.1 Excel for Data Analytics (6:16)
6.2 Corporate Analytics Lingo
6.3 RDBMS & Visualization Tools on the Job
6.4 Cleaning Data and ETL
6.5 Your New Updated Resume
6.6 Data Analytics Projects On the Job (7:05)
6.7 Continue Adding to Your SQL & Tableau Portfolios
Your Certificate & Next Steps
You're Ready to Break Into Tech (0:57)
4.5 SQL Order of Execution
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock