Skip to content

CornelliusYW/SQL-Crash-Course

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

41 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SQL Crash Course – From Zero to Hero! 🚀

SQL Crash Course

Hi! You must be here because of our's (Cornellius from Non-Brand Data and Josep from databites.tech) newest 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 build confidence in SQL following the same style as my previous 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

The repository will be updated over time with all the articles and code used in the series, so stay tuned!

Table of Contents

Article Title Article Link Code Script SQL Playground
Launching the SQL Crash Course – From Zero to Hero! 🚀 Read here
#1 What is SQL? Read here
#2 Why learn SQL? Read here
#3 Relational Data & Models Read here
#4 SQL Basic Commands Read here View script Run playground
#5 Sorting & Limiting Read here View script Run playground
#6 Aggregate Functions Read here View script Run playground
#7 JOINs (Left, Right, Inner & Full) Read here View script Run playground
#8 UNION & UNION ALL Read here View script Run playground
#9 Case Expressions Read here View script Run playground
#10 Functions Read here View script Run playground
#11 Subqueries Read here View script Run playground
#12 Common Table Expressions (CTEs) Read here View script Run playground
#13 Recursion Read here View script Run playground
#14 Views Read here View script Run playground
#15 CRUD Operations Read here View script Run playground
#16 Dabase Modifications Read here View script Run playground
#17 Indexing and Optimization Read here View script Run playground
#18 Modular Code Read here View script Run playground
#19 SQL Execution Order Read here View script Run playground
#20 Query Optimization Read here View script Run playground

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published