๐ฐ BEGINNER
LEVEL (Days 1–10)
“Build the Foundation”
Day |
Topics |
Day 1 |
Introduction to T-SQL, SQL vs T-SQL, SQL Sub-Languages
(DQL, DML, DDL, TCL, DCL), SELECT, WHERE, ORDER BY, DISTINCT, Aliasing |
Day 2 |
Advanced Filtering: AND, OR, NOT, IN, BETWEEN, LIKE, IS
NULL |
Day 3 |
Functions – Scalar Functions: LEN, UPPER, LOWER, GETDATE,
CONVERT |
Day 4 |
Aggregate Functions: COUNT, SUM, AVG, MIN, MAX, GROUP BY,
HAVING |
Day 5 |
Joins Part 1: INNER JOIN, LEFT JOIN – Use with WHERE
& SELECT |
Day 6 |
Joins Part 2: RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN |
Day 7 |
Data Types in SQL Server – INT, VARCHAR, NVARCHAR, DATE,
MONEY, etc. |
Day 8 |
DML: INSERT, UPDATE, DELETE – with conditions &
subqueries |
Day 9 |
DDL: CREATE, ALTER, DROP – Tables, Columns, Constraints |
Day 10 |
TCL & DCL: Transactions, COMMIT, ROLLBACK, GRANT,
REVOKE |
INTERMEDIATE LEVEL (Days 11–20) |
|
“Work Smart with Logic & Structures” |
|
Day 11 |
Constraints in Detail: PRIMARY KEY, FOREIGN KEY, UNIQUE,
CHECK, DEFAULT |
Day 12 |
Subqueries: Scalar, Correlated, EXISTS, IN Subqueries |
Day 13 |
Views: CREATE, ALTER, DROP Views – Security &
Optimization |
Day 14 |
Stored Procedures – Parameters, Execution, Output |
Day 15 |
User-Defined Functions – Scalar & Table-Valued
Functions |
Day 16 |
Error Handling: TRY…CATCH, @@ERROR, THROW |
Day 17 |
Common Table Expressions (CTEs): Basics and Recursive
CTEs |
Day 18 |
Temporary Tables & Table Variables |
Day 19 |
Working with Dates & Time – DATEADD, DATEDIFF, FORMAT |
Day 20 |
String Functions Deep Dive – CHARINDEX, SUBSTRING, STUFF,
REPLACE |
ADVANCED LEVEL (Days 21–30) |
|
“Think Like a T-SQL Pro” |
|
Day 21 |
Window Functions Part 1: ROW_NUMBER, RANK, DENSE_RANK |
Day 22 |
Window Functions Part 2: NTILE, LAG, LEAD, PARTITION BY |
Day 23 |
Pivoting & Unpivoting Data – PIVOT, UNPIVOT Operators |
Day 24 |
JSON in SQL Server – FOR JSON AUTO, FOR JSON PATH |
Day 25 |
XML in SQL Server – FOR XML, Nodes, Value() |
Day 26 |
Performance Tuning Part 1 – Execution Plans, SET
STATISTICS IO/TIME |
Day 27 |
Performance Tuning Part 2 – Indexing (Clustered,
Non-Clustered, Covering) |
Day 28 |
Triggers – AFTER, INSTEAD OF, DML Triggers |
Day 29 |
Security Best Practices – Schemas, Roles, Encryption |
Day 30 |
Capstone Project + Interview Q&A Marathon (50+ Real
Interview Questions) |
Daily Structure (Repeat Format)
Each day will include:
- ๐ฏ Objectives
- ๐ Explanation (with diagrams where needed)
- ๐งชExamples (minimum 2-3)
- ๐ Mini Exercises
- ๐ก Interview Q&A
- ๐ Summary Recap (Text + GIF)
- ✅ Homework Challenges
No comments:
Post a Comment