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: Intermediate SQL
2.1 Intro to Intermediate SQL (0:32)
2.2 WHERE: AND/OR (3:50)
2.3 SQL Challenge #3: Bank Database
2.4 WHERE: IN, LIKE, and %
2.5 SQL Challenge #4: Bank Database, Part 2
2.6 Calculations (1:43)
2.7 CASE Expressions (3:50)
2.8 SQL Challenge #5: Healthcare Billing
2.9 HAVING and the Order of Execution (5:16)
2.10 SQL Challenge #6: Healthcare Billing, Part 2
2.11 SQL Project #2: Fortune 500 Analysis
2.12 Your Second SQL Certificate!
Module 3: Advanced SQL
3.1 Intro to Advanced SQL
3.2 Relational Databases
3.3 Subqueries (5:12)
3.4 SQL Challenge #7: Telecom Customers
3.5 Introduction to SQL Joins
3.6 INNER JOIN
3.7 Challenge #8: Logistics Company
3.8 JOIN Type Overview (6:20)
3.9 Challenge #9: Logistics Company, Part 2
3.10 Multiple Joins in One SQL Query
3.11 Challenge #10: EdTech Data
3.12 SELF JOIN
3.13 Challenge #11: EdTech Data, Part 2
3.14 Subquery vs. JOIN
3.15 Project #3: Climate Conference Analysis
3.16 Advanced 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)
6.1 Excel for Data Analytics
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock