Updating Data in SQL Server

Home/Development, SQL Server/Updating Data in SQL Server

Updating Data in SQL Server

$15.00 $4.00

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

Categories: ,

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.