T-SQL Tutorial - Complete Course
Working with Multiple Tables
Using Built-in Functions
Scalar Functions (String, Date, and Mathematical)
Conversion Functions (CAST, TRY_CAST, CONVERT)
Conditional Functions (IIF, CHOOSE)
Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
Ranking Functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE)
Using Functions with GROUP BY and HAVING
Subqueries and Derived Tables
Data Modification Statements
Stored Procedures, Functions, and Triggers
Advanced Query Techniques
Database Security, Optimization, and Best Practices
Case Studies and Practical Projects