DataBites

DataBites

Home
Become a member ✨
Josep's Notes πŸš€
Cheatsheets 🧩
SQL crash course πŸ”’
Getting Started ⬆️
TheGuestBites πŸŽ™οΈ
About πŸ™‹πŸ»β€β™‚οΈ

Share this post

DataBites
DataBites
SQL Crash Course – Getting into Practice! πŸ‘¨πŸ»β€πŸ’»
SQL crash course πŸ”’

SQL Crash Course – Getting into Practice! πŸ‘¨πŸ»β€πŸ’»

SQL Crash Course Tehory Ending, and starting of hands-on! πŸš€

Josep Ferrer's avatar
Cornellius Yudha Wijaya's avatar
Josep Ferrer
and
Cornellius Yudha Wijaya
May 23, 2025
15

Share this post

DataBites
DataBites
SQL Crash Course – Getting into Practice! πŸ‘¨πŸ»β€πŸ’»
5
Share
Cross-post from DataBites
Love to see you guys continuing our SQL Crash Course! -
Cornellius Yudha Wijaya

Hey everyone! Josep and Cornellius one more week of SQL learning! πŸ‘‹πŸ»

Can you believe it’s already been 2 months since

Cornellius Yudha Wijaya
(from
Non-Brand Data
) and I (from
DataBites
) 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:

  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

βœ… 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

  • #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

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

DataBites is a reader-supported publication. To receive new posts and support my work, consider becoming a free or paid subscriber.

15

Share this post

DataBites
DataBites
SQL Crash Course – Getting into Practice! πŸ‘¨πŸ»β€πŸ’»
5
Share

No posts

Β© 2025 Josep Ferrer
Privacy βˆ™ Terms βˆ™ Collection notice
Start writingGet the app
Substack is the home for great culture

Share