Skip to content

codemetry-dev/learn-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 

Repository files navigation

📘 Learn SQL — From Beginner to Advanced

Welcome to Learn SQL, a beginner-to-advanced curriculum designed to teach SQL the practical way — using MySQL and real-world query patterns.

This course is structured to help you build a strong foundation in SQL, while progressively guiding you into advanced querying, performance tuning, and relational thinking.

⚡ Course Inspiration

This course is inspired in part by the pedagogical approach of SQL Queries for Mere Mortals by John L. Viescas and Michael J. Hernandez — a widely respected guide known for making SQL approachable and structured for real-world learning.

While this project is independently written and designed, many of the topics and teaching style echo the book’s focus on clarity, relational thinking, and progressive learning.

🎯 Who This Is For

  • Beginners with no SQL experience
  • Developers transitioning into backend or data roles
  • Data analysts and scientists looking to strengthen their SQL
  • Anyone who wants to learn how to write clean, effective SQL queries

🗺️ Curriculum (Progressively Built)

📌 Each module link will become active as the corresponding .md file is added to this repo.

# Topic Status
01 Introduction to SQL & Relational Databases ✅ Ready
02 Thinking in Tables ⏳ Coming Soon
03 Data Definition Language (DDL) ⏳ Coming Soon
04 Basic SELECT Queries ⏳ Coming Soon
05 Filtering and Conditions ⏳ Coming Soon
06 Expressions and Calculated Fields ⏳ Coming Soon
07 Aggregation and Grouping ⏳ Coming Soon
08 Joining Tables ⏳ Coming Soon
09 Subqueries ⏳ Coming Soon
10 Set Operations ⏳ Coming Soon
11 Data Manipulation Language (DML) ⏳ Coming Soon
12 Data Control Language (DCL) ⏳ Coming Soon
13 Advanced Query Design ⏳ Coming Soon
14 Query Optimization ⏳ Coming Soon
15 Practical Projects & Capstone ⏳ Coming Soon
16 Bonus: SQL for Data Analysis ⏳ Coming Soon

🛠️ Tools Used

  • Database: MySQL
  • Editor: MySQL Workbench, DBeaver, or any SQL-compatible IDE
  • Environment: Local or cloud MySQL server (e.g., DB Fiddle, PlanetScale)

🚀 How to Use

  1. Clone or fork the repo
    git clone https://github.com/your-username/Learn-sql.git

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published