SQL & Database Full Course Syllabus

• Module 1: Introduction to Databases & SQL
  • What is a Database?
  • Types of Databases (Relational vs Non-Relational)
  • What is SQL?
  • History & Importance of SQL
  • Popular RDBMS
    • MySQL
    • PostgreSQL
    • Oracle
    • SQL Server
  • Installing & Using SQL Tools
• Module 2: Database Basics
  • Tables, Rows, Columns
  • Data Types
    • INT
    • VARCHAR
    • DATE
    • FLOAT
    • BOOLEAN
  • NULL values
  • Schema & Metadata
  • Primary Keys
• Module 3: SQL Commands Overview
  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • DCL (Data Control Language)
  • TCL (Transaction Control Language)
  • DQL (Data Query Language)
• Module 4: Data Definition Language (DDL)
  • CREATE (Database, Table)
  • DROP
  • TRUNCATE
  • ALTER
  • Constraints
    • PRIMARY KEY
    • FOREIGN KEY
    • UNIQUE
    • NOT NULL
    • CHECK
    • DEFAULT
• Module 5: Data Manipulation Language (DML)
  • INSERT
  • UPDATE
  • DELETE
  • SELECT (Basic syntax)
  • Bulk Inserts
• Module 6: Data Query Language (DQL)
  • SELECT with:
    • WHERE
    • DISTINCT
    • ORDER BY
    • LIMIT / TOP
  • Operators
    • Arithmetic
    • Comparison
    • Logical (AND, OR, NOT)
  • Pattern Matching
    • LIKE
    • Wildcards (% , _)
• Module 7: Functions in SQL
  • Aggregate Functions
    • COUNT()
    • SUM()
    • AVG()
    • MIN()
    • MAX()
  • String Functions
    • UPPER(), LOWER()
    • LENGTH()
    • SUBSTRING()
  • Date Functions
    • NOW()
    • DATE()
    • YEAR(), MONTH()
• Module 8: GROUP BY & HAVING
  • GROUP BY clause
  • HAVING vs WHERE
  • Grouping with Aggregate Functions
• Module 9: Joins
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • Self Join
  • Cross Join
• Module 10: Subqueries
  • Single-row Subqueries
  • Multi-row Subqueries
  • Correlated Subqueries
  • IN, EXISTS, ANY, ALL
• Module 11: Views & Indexes
  • Creating Views
  • Updating Views
  • Indexes
    • Creating Index
    • Types of Indexes
    • Performance Optimization
• Module 12: Transactions & TCL
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • ACID Properties
• Module 13: Stored Procedures & Functions
  • Creating Stored Procedures
  • Input & Output Parameters
  • User-Defined Functions
  • Calling Procedures
• Module 14: Triggers
  • Types of Triggers
  • BEFORE & AFTER Triggers
  • Use Cases
• Module 15: Security & DCL
  • GRANT
  • REVOKE
  • User Roles & Privileges
• Module 16: Advanced SQL Concepts
  • Window Functions
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()