-
1. What is T-SQL? Why care?
Purpose of T-SQL, where it runs, difference from plain SQL.
-
2. Talking to a Database
Servers, databases, tables. Basic mental model.
-
3. Your First SELECT
Selecting columns, rows, basic filtering idea.
-
4. Filtering Rows with WHERE
Comparison operators, NULL basics.
-
5. Sorting Results with ORDER BY
Ascending, descending, multiple columns.
-
6. Limiting Output (TOP)
Getting only a few rows; why useful.
-
7. Calculated Columns & Aliases
Expressions, basic math, AS alias.
-
8. Working with Text and Dates
Basic string and date functions mindset.
-
9. NULL: The "Unknown" Value
Meaning of NULL, IS NULL, pitfalls.
-
10. Grouping Data (GROUP BY)
Why aggregate, GROUP BY idea.
-
11. Aggregate Functions
COUNT, SUM, AVG, MIN, MAX plain talk.
-
12. Filtering Groups (HAVING)
Difference between WHERE and HAVING.
-
13. Joining Tables: The Core Skill
INNER JOIN concept story.
-
14. Other Join Types
LEFT, RIGHT, FULL, CROSS simplified.
-
15. Subqueries: Query Inside Query
When a subquery helps; types.
-
16. Set Operations (UNION etc.)
UNION, UNION ALL, INTERSECT, EXCEPT idea.
-
17. Basic Data Changes (INSERT)
Adding rows safely.
-
18. Updating and Deleting
UPDATE and DELETE with care.
-
19. Transactions: Keep Data Safe
BEGIN/COMMIT/ROLLBACK in plain words.
-
20. Views and Stored Procedures
Why wrap logic; stable surfaces.
-
21. Stored Procedure Patterns
Parameters, branching, error handling, idempotence.
-
22. Indexing, Jobs & Performance
Indexes, maintenance jobs, basic performance tuning ideas.
