The Idempotent TSQL SQLChallenge (28 minutes)

When writing TSQL, it’s often useful to make your TSQL idempotent – a fancy word, which in the case of databases really just means: you can run the command again and again and it will make sure that you have the intended effect, without causing problems by being run more than once.

In this challenge, you’ll get multiple TSQL statements and be challenged to make them idempotent.

Course scripts are here: https://github.com/LitKnd/SQLWorkbooks/tree/main/itempotent_tsql_challenge

A FUN THING: This SQLChallenge uses Jupyter Notebooks in Azure Data Studio (that’s the files with the ipynb extensions). Azure Data Studio is a free client from Microsoft which works on Windows, mac, and Linux.

Lessons

Setup and Challenge - Idempotent TSQL (13 minutes)

Sample Solutions (15 minutes)