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
- 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()