SQL Zero to Hero: Course Syllabus

Welcome to the Complete SQL Roadmap.

This course is designed to take you from absolute beginner to advanced database programming.

If you are looking to learn SQL from scratch, you are in the right place. This is not just a random collection of tips, this is a structured learning path designed to take you from a complete beginner to writing advanced queries.

How to use this course: This course is broken down into modules. I recommend going through them in order. Each lesson includes:

  • The Concept: Simple explanation of the topic.
  • The Code: Real-world examples.
  • The Exercise: A practice task for you to try immediately.

Bookmark this page (Ctrl + D). New lessons are added weekly.


Module 1: The Basics (Data Retrieval)

Building the blocks of database knowledge.

Module 2: Relational Mastery (Connecting Data)

How to combine multiple tables to find insights.

  • Lesson 8: Joins (Inner, Left, Right, Full) (Coming Soon)
  • Lesson 9: Set Operators (UNION, INTERSECT, MINUS) (Coming Soon)
  • Lesson 10: Sub Queries (Single row, Multi-row) (Coming Soon)
  • Lesson 11: CTEs (Common Table Expressions) (Coming Soon)

Module 3: Database Design & Integrity

Structuring your data correctly from day one.

  • Lesson 12: DDL Commands (Create, Alter, Drop, Truncate) (Coming Soon)
  • Lesson 13: Data Integrity Constraints (PK, FK, Unique, Check, Not Null) (Coming Soon)
  • Lesson 14: Normalization (1NF, 2NF, 3NF, BCNF) (Coming Soon)
  • Lesson 15: Denormalization (When to break the rules) (Coming Soon)
  • Lesson 16: DCL & TCL (Grant, Revoke, Commit, Rollback - ACID Properties) (Coming Soon)

Module 4: Performance & Advanced Analysis

Optimization techniques used by pros.

  • Lesson 17: Window Functions (RANK, DENSE_RANK, LEAD, LAG) (Coming Soon)
  • Lesson 18: Views (Simple & Complex) (Coming Soon)
  • Lesson 19: Materialized Views (Coming Soon)
  • Lesson 20: Indexes (B-Tree, Bitmap, Unique) (Coming Soon)
  • Lesson 21: Partitions & Sequences (Coming Soon)
  • Lesson 22: Locks (Row level vs Table level) (Coming Soon)

Module 5: PL/SQL & Advanced Types (Programming)

Writing procedural logic inside the database.

  • Lesson 23: User Defined Datatypes (Records, Tables, Arrays) (Coming Soon)
  • Lesson 24: Introduction to PL/SQL (Block Structure) (Coming Soon)
  • Lesson 25: Exception Handling (Coming Soon)
  • Lesson 26: Cursors (Implicit & Explicit) (Coming Soon)
  • Lesson 27: Stored Procedures & Functions (Coming Soon)
  • Lesson 28: Packages & Triggers (Coming Soon)

Ready to start? Click on Lesson 1 above to begin your journey!

(Note: If a link is not clickable yet, that lesson is currently being written. Stay tuned!)

Comments

Post a Comment

Popular posts from this blog

Lesson 1: What is a Database?

Welcome to the first lesson of your SQL journey. Introduction When I first started learning coding at ThinkByByte, I was confused about where data actually lives. To handle this data efficiently, we use a DBMS (Database Management System). In this lesson, we will understand what DBMS is, why it is needed, and how it works. What is DBMS? DBMS (Database Management System) is a software system that allows users to store, manage, retrieve, and modify data efficiently in a structured format. A Real-Life Example Imagine an organization 🏢: Employee Details = Data Register or Computer System = DBMS Employer or Management = User The DBMS helps management to: Add new employees Update employee data Check employee data Remove resigned/old employees' data Why Do We Need DBMS? In earlier days, data was stored using file systems like text files or Excel documents. This created many problems. Problems with File Systems: ❌ Duplicate Data: The same information is...
Read more

Lesson 2: Introduction to SQL

Welcome to Lesson 2. In the last lesson, we learned that the database is like a "digital filing cabinet." Now, we are going to learn the language used to talk to that cabinet. That language is SQL.  In this Introduction to SQL for beginners , you will learn how to use SQL to fetch data from a database. 1. What is SQL? SQL stands for Structured Query Language . It is the standard language for storing, manipulating, and retrieving data in a relational database. You: "Hey database, show me the names of all employees who joined today." SQL: SELECT emp_name FROM employees; Database: "Here is the list." Important Note: SQL is NOT a database (like Oracle or MySQL). SQL is the language used to talk to those databases. 2. The 3 Golden Rules of SQL Syntax Just like English has grammar rules, SQL has syntax rules. If you break them, the database won't understand you. Rule Explanation 1. Semico...
Read more

Lesson 4: SQL Constraints (Rules for Your Data).

Welcome to Lesson 4. In the last lesson, we learned about Data Types (Text, Numbers, Dates). But simply knowing the type isn't enough. Imagine a "Sign Up" form on a website. What happens if: A user tries to sign up without a password ? Two users try to use the same email address ? The database must stop this! We use Constraints to enforce these rules. 1. What are SQL Constraints? Constraints are rules we apply to columns to ensure the data is accurate and reliable. If you try to insert data that breaks a rule, the database will say "Error" and reject it. 2. The 6 Most Important Constraints Here are the rules you will use in almost every table: Constraint The Rule Real Life Example NOT NULL The column cannot be empty. A user must have a Password. UNIQUE No duplicate values allowed. Two users cannot have the same Email . DEFAULT ...
Read more