Updating Data in SQL Server

Updating Data in SQL Server

Original price was: $15.00.Current price is: $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

Reviews

There are no reviews yet.

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

Content missing

Title

Go to Top