SQL-learning-track

This repository tracks my SQL and Excel learning projects.

Lesson 1 - SQL Basics

• Folder: maven-student-grades-db
• Practice files:
  • create_student_grades_db.sql
  • setup_sqlite.sql
  • practice_queries.sql
  • student_grades.csv
  • students.csv
  • student_practice.db
• Description: SQL basics practice for the Maven student grades dataset.

Lesson 2 - Excel / Power Query / Power Pivot / DAX

• Folder: excel-learning-track
• Dataset: Maven+Electronics+Demo+Data
• Files:
  • Products.csv
  • Sales.csv
  • Stores.pdf
• Description: Excel CSV dataset for learning Power Query, Power Pivot, data modeling, and DAX.

Lesson 4 - Python for Data Analysis

• Folder: python-data-analysis-course
• Source: Luke Barousse Python Data Analytics course
• Includes: Jupyter notebooks for Python basics, pandas, matplotlib, seaborn, and a mini project
• Description: Beginner-friendly Python course focused on data analysis with downloadable notebooks and exercises.

Notes

• .gitignore includes .DS_Store.
• Use this repo to keep the lesson files and notes organized for each lesson.