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
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. 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
Amazing! Thanks Josep!