Launching the SQL Crash Course – From Zero to Hero! 🚀

SQL Crash Course #0

Hey everyone, this is Josep one more week! 👋🏻

Today I’m teaming up with Cornellius from

Non-Brand Data

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:

1. Introduction – What SQL is and why it matters

2. SQL Fundamentals – Basic commands, filtering, and aggregation

3. Intermediate SQL – Joins, unions, and functions

4. Advanced SQL – Subqueries, CTEs, recursion, and views

5. Database Operations – CRUD, schema changes, and optimization

6. Crafting Good SQL Queries – Best practices for writing efficient queries

7. 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. Filtering and Sorting (ORDER BY, LIMIT)→ Available March 27th ‼️
🔜 #6. Aggregate Functions (SUM, AVG, COUNT, etc.) → Available March 27th ‼️

3️⃣ Intermediate SQL

⏳ #7. JOINS (INNER, LEFT, RIGHT, FULL) →Available April 3rd
⏳ #8. UNION & UNION ALL → Available April 3rd
⏳ #9. Case Expressions → Available April 10th
⏳ #10. Functions (String, Date, Numeric) → Available April 10th

4️⃣ Advanced SQL

⏳ #11. Subqueries →Available April 17th
⏳ #12. Common Table Expressions (CTEs) → Available April 17th
⏳ #13. Recursion → Available April 24th
⏳ #14. Views → Available April 24th

5️⃣ Database Operations

⏳ #15. CRUD operations (INSERT, UPDATE, DELETE) →Available May 1st
⏳ #16. Database modifications (ALTER, DROP, CREATE) → Available May 1st
⏳ #17. Indexing & Optimization → Available May 8th

6️⃣ Crafting Good SQL queries

⏳ #18. Modular Code →Available May 8th
⏳ #19. SQL Execution Order → Available May 15th
⏳ #20. Query Optimization → Available May 15th

---

Let’s dive in and make SQL less scary, more fun, and way more useful! 🚀

Josep & Cornellius