Data With Danny - Serious SQL Masterclass
The 8 Week SQL Challenge is a part of Data With Danny virtual data apprenticeship program!
Creator of the Case Studies - Danny Ma
Linkedin - https://linkedin.com/in/datawithdanny
Course - https://www.datawithdanny.com/courses/serious-sql
Start with Serious SQL Start by building a strong data foundation
Learn SQL by doing! Solve multiple realistic end to end case studies and challenging data analytics projects from the following domains:
- Health analytics
- Marketing analytics
- People analytics
- Financial markets
- Fast moving consumer goods
- Digital marketing
Serious SQL is fully complete and all videos and tutorial content can be accessed on demand.
Access to mentors from the Data With Danny team and further SQL support is available to all students on our private Discord community.
Live Training & Q&A
Danny holds live SQL training and career Q&A sessions on Zoom every Saturday 9:30PM to 11PM EST. These live classes recommence from the 29th of January 2022.
All live sessions are recorded and can be viewed anytime inside the course player, including 4 previous sessions from late 2021 covering the initial data exploration section of the course.
Cover many core SQL skills and techniques required for data analysis from beginner to advanced levels including:
- 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
- Window functions
- Case When Statements
- Recursive CTEs
- Cumulative aggregates
- Simple, weighted and exponential moving metrics
- Historical vs Snapshot data analysis techniques
- Temp tables and views
- String transformations
- Regular Expressions
- Datetime manipulation
Gain familiarity with popular programming tools such as Docker, Markdown, GitHub and the command line interface (CLI) Learn how to setup your own GitHub Pages project portfolio page with a guided step-by-step guide Access to solutions for all 8 Week SQL Challenge case studies with explanations and further exercises
Get access to our members only Discord for technical support and participate in valuable community initiatives including:
- Formal study groups
- Live SQL training events
- Regular Q&A town hall broadcasts
- SQL interview exercises
- Resume reviews
- Mock interviews
- 1:1 mentoring opportunities
All database and SQL interface infrastructure are Docker based with detailed instructions to install WSL2 and Docker Desktop on Windows and quick-start guides for Mac and Linux systems.
Installation and setup of all required databases and systems is fast and runs on all machine types that support Docker Desktop including Windows, Ubuntu and all Macs including the latest generation of Apple M1 Macs.