30-Day Excel & SQL Training Plan

Guru Charan Pathalla

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!

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:

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

Day 1
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

Have feedback or questions?