T-SQL Training Roadmap

🔰 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

Previous                                                                                                                     Next