Here is another popular lab from Hands-On-Lab library: Updating Data in SQL Server.
In Transact-SQL (T-SQL) UPDATE allows us to change the existing data in a table. This lab is divided into seven exercises explaining different ways to update the data. In first exercise we will learn to update a column data using string functions. In second exercise we will learn to update multiple columns for multiple rows at once. In third exercise we will learn to update the rows based on JOIN. In fourth exercise we will learn to update rows based on correlate subquery. In fifth exercise we will learn to update a portion of data for large data types.
Exercise 1: UPDATE a column data using String Functions
Exercise 2: UPDATE multiple columns for multiple rows at once
Exercise 3: UPDATE the rows based on JOIN
Exercise 4: UPDATE rows based on correlated subquery
Exercise 5: UPDATE a portion of data for large data types
Exercise 6: Self-Assessment
Exercise 7: T-SQL Challenge
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.