Danny Ma's 8-Week SQL Challenge Study Cases
- Answered several business intelligence-related questions posed by leadership regarding each company's performance.
- Created several MySQL scripts to upload and pre-process the data, perform a thorough exploratory and explanatory analysis, and built several pivot tables to write business reports.
- Created a MySQL script to highlight key SQL skills like rank functions, common table expressions, temporary tables, and case statements.
- Set up a database and SQL editor to interact with the database, upload the schema, and dump tables.
MySQL Version: 8.0.31
You can find the solutions links for the case studies below:
Danny Ma is a Principal AI Engineer at LUMOS. He wanted to create a online community which supports all data professionals who were specifically starting on their SQL learning journey. Thus, the 8 Week SQL Challenge was created.
By completing the challenge, I sharpened my SQL skills by doing through multiple realistic end to end case studies that closely represent the sort of work performed by data analysts. The datasets and case studies in this course gave me experience in the following domains:
- Health analytics
- Marketing analytics
- People analytics
- Financial markets
- Fast moving consumer goods
- Digital marketing
Here are a few of the core SQL skills and techniques required to complete the challenge:
| Where filters and ordering data | Group by aggregates | Identifying and dealing with duplicate data | Common table expressions and subqueries |
| Summary statistics | Exploratory data analysis | Complex table joins | Entity relationship diagrams |
| SQL reverse engineering | Data problem solving techniques | All the window functions | Case When Statements |
| Recursive CTEs | Cumulative aggregates | Simple, weighted and exponential moving metrics | Historical vs Snapshot data analysis techniques |
| Temporary tables, database views and materialized views | Interpret SQL optimizer execution plans | String transformations including Regular Expressions | Date and Timestamp manipulation including timezones |
| Different types of table indexes | Impact of indexes on simple table operations | Loading raw data | Table schemas and data types |
A huge thank you to Danny Ma for volunteering his time to mentor aspiring data analysts on their journey to become more data literate. You can find more information about the 8 Week SQL Challenge here.
#8WeekSQLChallenge