Under Construction

All course tracks

Databases and SQL · 30 lessons · up to 10 minutes each

SQL Server and T-SQL

A planned SQL Server path that keeps T-SQL distinct from other SQL dialects.

Coming Soon

One-time purchase · USD

Choose what to unlock

Access is attached to your account after payment is verified. No subscription.

One lesson

An individual lesson

This track has no lesson ready to buy yet. Each lesson becomes available only after it is built and reviewed.

$5.00Not available yet

Full category

SQL Server and T-SQL

Permanent access to the lessons published in this track when you buy. Future lessons are not included. 0 of 30 lessons are published; 0 are in owner review and 30 are Coming Soon.

$29.0030 lessons still in progress

Beginner

Lessons 1–10

  1. 01

    SQL Server and T-SQL: Sketch T-SQL SELECT shape

    Topic: T-SQL SELECT shape

    Draw a small map of T-SQL SELECT shape in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner4 minComing Soon
  2. 02

    SQL Server and T-SQL: Name the parts of variables and batch scope

    Topic: variables and batch scope

    Label the main pieces in variables and batch scope in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner5 minComing Soon
  3. 03

    SQL Server and T-SQL: Trace an example of joins and APPLY

    Topic: joins and APPLY

    Follow one input through joins and APPLY in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner6 minComing Soon
  4. 04

    SQL Server and T-SQL: Compare choices for aggregates and window functions

    Topic: aggregates and window functions

    Write down one practical difference between aggregates and window functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner7 minComing Soon
  5. 05

    SQL Server and T-SQL: Find the boundary in date and string functions

    Topic: date and string functions

    Mark where date and string functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner8 minComing Soon
  6. 06

    SQL Server and T-SQL: Inspect an example of stored procedure inputs

    Topic: stored procedure inputs

    Annotate a minimal example of stored procedure inputs in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner9 minComing Soon
  7. 07

    SQL Server and T-SQL: Connect TRY and CATCH errors to a neighboring concept

    Topic: TRY and CATCH errors

    Show how TRY and CATCH errors in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner10 minComing Soon
  8. 08

    SQL Server and T-SQL: Spot a failure mode in transactions and isolation

    Topic: transactions and isolation

    Describe one likely failure for transactions and isolation in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner3 minComing Soon
  9. 09

    SQL Server and T-SQL: Read an official example of execution plans and indexes

    Topic: execution plans and indexes

    Summarize an official example of execution plans and indexes in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner5 minComing Soon
  10. 10

    SQL Server and T-SQL: Choose a use case for SQL Server 2025 documentation checks

    Topic: SQL Server 2025 documentation checks

    Match one small use case to SQL Server 2025 documentation checks in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Beginner6 minComing Soon

Intermediate

Lessons 11–20

  1. 11

    SQL Server and T-SQL: Build an example with T-SQL SELECT shape

    Topic: T-SQL SELECT shape

    Create a small working example that uses T-SQL SELECT shape in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate4 minComing Soon
  2. 12

    SQL Server and T-SQL: Compose variables and batch scope with another component

    Topic: variables and batch scope

    Combine variables and batch scope in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate5 minComing Soon
  3. 13

    SQL Server and T-SQL: Configure joins and APPLY for a small case

    Topic: joins and APPLY

    Set up joins and APPLY in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate6 minComing Soon
  4. 14

    SQL Server and T-SQL: Validate inputs around aggregates and window functions

    Topic: aggregates and window functions

    Add a check around aggregates and window functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate7 minComing Soon
  5. 15

    SQL Server and T-SQL: Use date and string functions in a short workflow

    Topic: date and string functions

    Add date and string functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate8 minComing Soon
  6. 16

    SQL Server and T-SQL: Refactor stored procedure inputs into a reusable unit

    Topic: stored procedure inputs

    Extract stored procedure inputs in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate9 minComing Soon
  7. 17

    SQL Server and T-SQL: Exercise TRY and CATCH errors with sample data

    Topic: TRY and CATCH errors

    Run sample data through TRY and CATCH errors in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate10 minComing Soon
  8. 18

    SQL Server and T-SQL: Observe transactions and isolation outputs

    Topic: transactions and isolation

    Capture the result of transactions and isolation in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate3 minComing Soon
  9. 19

    SQL Server and T-SQL: Recover from a execution plans and indexes failure

    Topic: execution plans and indexes

    Handle one expected failure from execution plans and indexes in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate5 minComing Soon
  10. 20

    SQL Server and T-SQL: Document SQL Server 2025 documentation checks behavior

    Topic: SQL Server 2025 documentation checks

    Write a short usage note for SQL Server 2025 documentation checks in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Intermediate6 minComing Soon

Advanced

Lessons 21–30

  1. 21

    SQL Server and T-SQL: Test a boundary around T-SQL SELECT shape

    Topic: T-SQL SELECT shape

    Add an edge-case test for T-SQL SELECT shape in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced4 minComing Soon
  2. 22

    SQL Server and T-SQL: Harden variables and batch scope

    Topic: variables and batch scope

    Add the relevant access, safety, or validation control to variables and batch scope in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced5 minComing Soon
  3. 23

    SQL Server and T-SQL: Measure joins and APPLY

    Topic: joins and APPLY

    Record a small baseline for joins and APPLY in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced6 minComing Soon
  4. 24

    SQL Server and T-SQL: Reduce cost in aggregates and window functions

    Topic: aggregates and window functions

    Change one measurable cost in aggregates and window functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced7 minComing Soon
  5. 25

    SQL Server and T-SQL: Diagnose a date and string functions failure

    Topic: date and string functions

    Use an observable signal to explain a failure in date and string functions in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced8 minComing Soon
  6. 26

    SQL Server and T-SQL: Make stored procedure inputs repeatable

    Topic: stored procedure inputs

    Show that rerunning stored procedure inputs in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced9 minComing Soon
  7. 27

    SQL Server and T-SQL: Review trade-offs in TRY and CATCH errors

    Topic: TRY and CATCH errors

    Compare two documented approaches to TRY and CATCH errors in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced10 minComing Soon
  8. 28

    SQL Server and T-SQL: Improve transactions and isolation maintainability

    Topic: transactions and isolation

    Refine transactions and isolation in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced3 minComing Soon
  9. 29

    SQL Server and T-SQL: Verify execution plans and indexes end to end

    Topic: execution plans and indexes

    Check that a complete small flow using execution plans and indexes in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced5 minComing Soon
  10. 30

    SQL Server and T-SQL: Audit SQL Server 2025 documentation checks against its source docs

    Topic: SQL Server 2025 documentation checks

    Check the implementation of SQL Server 2025 documentation checks in the context of SQL Server T-SQL queries, execution plans, and transaction behavior; save a short example or check that demonstrates the result.

    Advanced6 minComing Soon

Reference documentation

References support the selected track topics while its lesson content is built and reviewed progressively.

This track is a catalog outline only. Each lesson remains unavailable until it is built and personally reviewed.