Complete Training with Video Resources & AI Learning Prompts
Duration: 30 Days (6 weeks, 5 days/week)
Daily Time: 4 hours
Approach: Alternating Excel & SQL with mirrored
concepts
Complexity: Gradual progression (beginner β
intermediate β advanced)
π HOW TO USE THIS PLAN
Video Resources
Each day includes curated video tutorials to help you learn concepts visually.
AI Learning Prompts
IMPORTANT: These prompts are for understanding concepts only - NOT for solving your assignments!
- β USE prompts to: Learn concepts, understand theory, see different examples
- β DONβT use prompts to: Solve practice problems, complete assignments, cheat
How to use: 1. Copy the prompt (including the backticks) 2. Paste into Claude or ChatGPT 3. Read and understand the explanation 4. Then solve YOUR practice problems yourself!
PROGRAM OVERVIEW
Pacing Strategy:
- Days 1-10: Light (8-10 practice problems) - ONE major concept
- Days 11-20: Medium (12-15 problems) - TWO related concepts
- Days 21-30: Advanced (15-20 problems) - Complex integrated topics
Resources:
Datasets: - Superstore Sales: https://www.kaggle.com/datasets/vivek468/superstore-dataset-final Employee: https://www.kaggle.com/datasets/rhuebner/human-resources-data-set
Software: - Excel: Microsoft Excel 2016+ or LibreOffice Calc - SQL: SQLite Browser ( https://sqlitebrowser.org/ OR SQL Server + SSMS
DAILY LESSONS
Excel - Formulas & Basic Functions Day 2
SQL - SELECT & Basic Queries Day 3
Excel - Conditional Logic & IF Functions Day 4
SQL - WHERE Clause & Filtering Day 5
Excel - VLOOKUP & Reference Functions Day 6
SQL - JOIN Operations Day 7
Excel - Pivot Tables Day 8
SQL - GROUP BY & Aggregates Day 9
Excel - Advanced Functions (SUMIFS, COUNTIFS, Text) Day 10
SQL - Subqueries Day 11
Excel - Date Functions Day 12
SQL - Date & Window Functions Part 1 Day 13
Excel - What-If Analysis Day 14
SQL - Window Functions Part 2 Day 15
Excel - Power Query + Week 3 Test Day 16
SQL - CTEs & Recursive Queries Day 17
Excel - Power Pivot & Data Modeling Day 18
SQL - CASE Statements & PIVOT/UNPIVOT Day 19
Excel - Advanced Charts & Dashboards Day 20
SQL - Views, Stored Procedures + Week 4 Test Day 21
Excel - Statistical Analysis & Forecasting Day 22
SQL - Advanced Aggregations Day 23
Excel - Conditional Formatting & Validation Day 24
SQL - Query Optimization & Performance Day 25
Integration Project: Excel + SQL + Week 5 Test Day 26
Excel - Macros & Automation Basics Day 27
SQL - Advanced Analytics Day 28
Excel - Executive Dashboard Creation Day 29
SQL - Complex Business Scenarios Day 30
Final Project & Comprehensive Assessment