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

No comments:

Post a Comment

Popular Posts