SQL Crash Course – Getting into Practice! 👨🏻💻
SQL Crash Course Tehory Ending, and starting of hands-on! 🚀
Hey everyone! Josep and Cornellius one more week of SQL learning! 👋🏻
Can you believe it’s already been 2 months since
(from ) and I (from ) kicked off our SQL Crash Course? 🎉What started as a fun idea quickly turned into a full-blown series — and today, we’re sharing a recap of everything we’ve covered… and what’s coming next! 🙌🏻
🔥 What’s inside the course?
We’ve structured the course into 7 key modules to take you from zero to SQL hero:
Introduction – What SQL is and why it matters
SQL Fundamentals – Basic commands, filtering, and aggregation
Intermediate SQL – Joins, unions, and functions
Advanced SQL – Subqueries, CTEs, recursion, and views
Database Operations – CRUD, schema changes, and optimization
Crafting Good SQL Queries – Best practices for writing efficient queries
Real-world Problems – Applying SQL to practical challenges
✅ What We’ve Covered So Far
We’ve completed Modules 1 through 6 — all the theory and best practices you need.
You can catch up on each lesson here:
1️⃣ Introduction to SQL
2️⃣ SQL Fundamentals
#4. Basic Commands (SELECT, FROM, WHERE) → link
#5. Sorting & Limiting (ORDER BY, LIMIT)→ link
#6. Aggregate Functions (SUM, AVG, COUNT, etc.) → link
3️⃣ Intermediate SQL
#7. JOINS (INNER, LEFT, RIGHT, FULL) → link
#8. UNION & UNION ALL → link
#9. Case Expressions → link
#10. Functions (String, Date, Numeric) → link
4️⃣ Advanced SQL
#11. Subqueries → link
#12. Common Table Expressions (CTEs) → link
#13. Recursion → link
#14. Views → link
5️⃣ Database Operations
#15. CRUD operations (INSERT, UPDATE, DELETE) → link
#16. Database modifications (ALTER, DROP, CREATE) → link
#17. Indexing & Optimization → link
6️⃣ Crafting Good SQL queries
So the following question is…
🔜 What’s Next?
Now it’s time to put theory into practice! Over the next few weeks, we’ll release hands-on exercises and projects to help you apply what you’ve learned:
7️⃣ 7. Real-World Problems (Quick Wins)
Easy-level problems, perfect for 30–60 minutes of practice:
Problem 1 → 29th May
Problem 2→ 29th May
Problem 3 → 5th June
Problem 4→ 5th June
🧪 Mini-Projects (Deeper Dives)
Medium-difficulty projects to consolidate your skills:
Mini-Project 1 → 19th June
Mini-Project 2 → 19th June
💣 Final Projects (End-to-End Challenges)
Advanced, real-life projects released in multiple parts:
Project 1 → 26th June (with multiple issues in the following weeks)
Project 2 → 26th June (with multiple issues in the following weeks)
We’ll share full project briefs and walkthroughs — so stay tuned!
💡 Where to Follow Along?
We’ll continue posting weekly updates in our newsletters:
DataBites (by Josep)
Non-Brand Data (by Cornellius)
👉 Check out the GitHub repo and stay tuned for the first post!
Let’s dive in and make SQL less scary, more fun, and way more useful! 🚀
Josep & Cornellius