Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics Certificate Program
Getting Started
Join our Discord Community (1:18)
How to Ask Questions Throughout the Program
Module 1: SQL Bootcamp
1.1 Writing Your First SQL (11:00)
1.2 Begin Setting Up Your SQL Portfolio (We'll Add Projects Throughout the Program!) (3:09)
1.3 Additional Beginner SQL Concepts & Practice (0:36)
1.4 Relational Queries (JOINs) (1:01)
1.5 Netflix Data Analytics Project in a New SQL Dialect ("PostgreSQL") (9:26)
1.6 Subqueries (aka "Inner Queries" or "Nested Queries")
1.7 SQLite Studio Download & Database Setup (2:53)
1.8 Customer & Order Analytics Project
1.9 Advanced Data Filtering Techniques in SQL
1.10 Advanced Customer & Order Analytics
1.11 Spotify Data Analytics Project
1.12 CTEs: Common Table Expressions ("Temporary Tables")
1.13 More CTE Practice with Bike Lane Data
1.14 How to Solve Unique SQL Problems (Window Functions Practice)
1.15 Additional Practice & Resources
1.16 Final SQL Project
1.17 SQL Test Study Guide
1.18 SQL Test
Module 2: Using Tableau to Visualize Data
2.1 Intro to Tableau (1:58)
2.2 Connecting Tableau to Data (3:54)
2.3 Building a Tableau Dashboard: World COVID Data Project (31:17)
2.4 Tableau Product & Order Analytics Project
2.5 Tableau Product & Order Analytics Project Part 2
2.6 Tableau Creator Training: Executive Overview Project
2.7 World Happiness Report Dashboard Project
2.8 Troubleshooting
Module 3: Bringing It All Together
3.1 Excel for Data Analytics (7:00)
3.2 Corporate Analytics Lingo
3.3 RDBMS & Visualization Tools
3.4 Cleaning Data and ETL
3.5 Your New Updated Resume
3.6 Data Analytics Projects On the Job (7:18)
3.7 How to Continue Adding to Your SQL & Tableau Portfolios
Your Certificate & Next Steps
You're Ready to Break Into Tech (1:01)
1.2 Begin Setting Up Your SQL Portfolio (We'll Add Projects Throughout the Program!)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock