T-SQL topics
12 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Stored-program block structure
Demonstrate stored-program block structure in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Variable and parameter declarations
Demonstrate variable and parameter declarations in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Conditional execution
Demonstrate conditional execution in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Loop and record iteration
Demonstrate loop and record iteration in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Stored routines and return values
Demonstrate stored routines and return values in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Query-result handling
Demonstrate query-result handling in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Cursor and row processing
Demonstrate cursor and row processing in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Database exception handling
Demonstrate database exception handling in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Transaction interaction
Demonstrate transaction interaction in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Trigger execution boundaries
Demonstrate trigger execution boundaries in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Routine privilege scope
Demonstrate routine privilege scope in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Stored-program testing and versioning
Demonstrate stored-program testing and versioning in a focused T-SQL example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond T-SQL.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Markup configuration and query languages.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.