This repository serves as a personal learning log and version controlled archive of all the lessons, exercises and practice files I completed while learning MySQL. Every file, commit and timestamp reflects my actual study progression as I worked through the material.
I enrolled in the Data Analyst Course on AnalystBuilder.com, created by Alex The Analyst.
Creator: Alex The Analyst
YouTube Channel: Alex The Analyst
Platform: AnalystBuilder.com (paid course)
Although Alex provides a large amount of free SQL and analytics content on YouTube, the material there is not fully structured or organized in a clear progression. Because of that, I chose to take the paid version of the course on AnalystBuilder.com. The content is well organized, includes exercises and provides a more systematic approach for learning SQL from the basics to more advanced concepts.
This repository tracks every lesson I completed, organized into modules that follow the structure of the course.
Foundational SQL statements such as
- SELECT
- WHERE
- Comparison operators
- Logical operators
- BETWEEN and IN
- Aliasing
- ORDER BY and LIMIT
Covers essential data handling
- Numeric and string data types
- CASE and IF
- CAST and CONVERT
- Date and date formatting
- String functions
- Date functions
Working with grouped datasets
- Aggregate functions (COUNT, SUM, AVG and others)
- GROUP BY
- HAVING vs WHERE
- ROLLUP
Core SQL join concepts
- INNER, LEFT, RIGHT, FULL OUTER JOIN
- SELF JOIN
- CROSS JOIN
- NATURAL JOIN
- Joining multiple tables
- Joining on multiple conditions
- USING keyword
- UNION
- Practical join use cases
Intermediate SQL skills
- Basic subqueries
- Subqueries in SELECT and FROM
- EXISTS
- ANY and ALL operators
Advanced analytical SQL
- OVER and PARTITION BY
- ROW_NUMBER
- RANK and DENSE_RANK
- LAG and LEAD
- Practical window function analyses
Pattern matching in SQL
- Regex methods
- Regex metacharacters
- Real examples and use cases
Importing and exporting files
- Importing CSV data into MySQL
- Exporting data
- Example CSV and JSON files used for exercises
Practical data cleanup techniques
- Handling NULL values
- Standardizing data
- Removing duplicates
- Breaking out columns
- Renaming columns
- Deleting columns
This repository serves to
- Track my personal SQL learning progress
- Document every lesson I practiced
- Organize the course material with clean version history
- Create a structured reference I can return to
- Maintain a chronological log of my MySQL learning journey
As I continue the course and expand into other areas such as Python, Tableau, Excel and Power BI, I may
- Create additional repositories for each new topic
- Build project based repositories to demonstrate applied skills
- Share dashboards, analyses and SQL case studies
Thank you to Alex The Analyst for creating accessible and practical educational material for aspiring data analysts. His structured course, combined with his free content on YouTube, made learning SQL straightforward and enjoyable.