TSQL for Beginners (Redgate University)
This free course introduces you to the Transact SQL language implemented in SQL Server and takes you from newbie to a master of SELECT statements.
-
-
The Idempotent TSQL SQLChallenge (28 minutes)
In this challenge, you get multiple TSQL statements and are challenged to make them rerunnable.
-
Who Made That Schema Change? An Event Notification SQLChallenge (27 minutes)
Event Notifications have pros and cons -- learn 'em both in this challenge.
-
Who Made That Schema Change? A DDL Trigger SQLChallenge (28 minutes)
Take a crack at writing a DDL Trigger to track schema changes.
-
A Query Writing SQLChallenge: The Most Unique Names (23 minutes)
Flex your T-SQL: you’re challenged to write four different (but related) queries in this query writing challenge.
-
A Dynamic SQLChallenge (32 minutes)
You need to write a single query loop that calls procedures across multiple databases in this SQL Challenge. What’s the most efficient way to do it?