Course Syllabus Preview
Items below marked with a lock icon require an active enrollment. Enroll or contact an administrator to get access.
Course Curriculum (3 Modules)
7 total learning itemsCourse Downloads & Starter Files (1)
SQL_Cheatsheet_Window_Functions.pdf
190 KBModule 1
SQL Fundamentals & Relational Data Modeling
Core SQL syntax, filtering, joins, aggregations, and subqueries.
3 lessons• 1 resource
1.1
Introduction to Relational Databases & SQL Syntax
video•8 min
Locked
1.2
Joins, Aggregations & Analytical Window Functions
reading•12 min
Locked
1.3
SQL Core Mastery Quiz
assignment•10 min•2 Questions
Locked
Module Resources
SQL_Cheatsheet_Window_Functions.pdf Locked
Module 2
Exploratory Data Analysis with Python & Pandas
Data cleaning, transformation, handling missing values, and exploratory statistics.
2 lessons
2.1
Data Wrangling with Pandas DataFrames
video•15 min
Locked
2.2
Statistical Distributions and Outlier Detection
reading•10 min
Locked
Module 3
Business Intelligence & Executive Dashboards
Building interactive dashboards and metric storytelling in PowerBI and Tableau.
2 lessons
3.1
Interactive KPI Dashboard Architecture
video•14 min
Locked
3.2
Final Capstone Project Guidelines
reading•15 min
Locked