Hey everyone, this is Josep one more week! 👋🏻
Today I’m teaming up with Cornellius from
to bring you something special—a brand-new SQL Crash Course! 🎉Whether you're just starting out or looking to sharpen your SQL skills, this series will take you from zero to hero with a structured, easy-to-follow approach. Each post will break down essential SQL concepts, helping you crash into SQL with confidence, following the same style of my previous SQL courses.
🔥 What’s in the course?
We will structure the series into seven key topics to guide you step by step:
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
🎯 Who is this course for?
This SQL Crash Course is designed for two main audiences:
- Juniors & Beginners
If you're new to SQL or want to crash into the world of databases, this course will guide you step by step, making SQL easy and approachable.
- Seasoned Professionals & Seniors
In the later editions, we’ll tackle real-world projects and develop end-to-end solutions that you can add to your portfolio, helping you level up your skills and showcase practical experience.
No matter where you are in your SQL journey, this course will help you learn, apply, and master SQL with real examples and structured learning.
🗓️ When will it be available?
We’ll post the first two issues this Thursday, 13th March! ⚠️
Afterwards, every Thursday, you will have two new issues right in your inbox!
Make sure to subscribe to both databites.tech and Non-Brand Data!! 👀
💡 Where to find it?
We’ll be publishing weekly issues in both our newsletters:
Databites.tech (By Josep)
Non-Brand Data (By Cornellius)
We will make it open-source on GitHub so you can follow along, experiment, and contribute!
👉 Check out the GitHub repo and stay tuned for the first post!
📚 SQL Crash Course – Published Articles
1️⃣ Introduction to SQL
✅ #1. What is SQL? → link
✅ #2. Why Learn SQL? → link
✅ #3. Relational Data & Models → link
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
✅ #18. Modular Code → link
✅ #19. SQL Execution Order → link
✅ #20. Query Optimization → link
Let’s dive in and make SQL less scary, more fun, and way more useful! 🚀
Josep & Cornellius
 | A guest post by
|
Amazing! Thanks Josep!