Before starting, prepare resources - IoT hub and Edge device - in Microsoft Azure. In Azure Portal, create IoT Hub resource. (Please proceed wizards and create a resource.) Next we prepare for a ...

-- Step 1: The current manager of the Development department ('d005') is retiring today. -- We must "close" their active record by changing their to_date to today. UPDATE dept_manager SET to_date = ...