Modifying Data

Introduction

The Modifying Data module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

1. Creating and Altering Stored Procedures
2. Modify Data using INSERT, UPDATE and DELETE Statements
3. Combining Data Sets

Exercise 1- Creating and Altering Stored Procedures

In this exercise, you will learn the following using SQL Server 2012:

• Creating a stored procedure with input and output parameters
• Creating a stored procedure to access data from a database
• Altering a stored procedure

Exercise 2- Modify Data using INSERT, UPDATE and DELETE Statements

In this exercise, you will learn the following using SQL Server 2012:

• Using the Insert statement
• Using the Update statement
• Using the Delete statement
• Using the Output statement

Exercise 3- Combining Data Sets

In this exercise, you will learn the following using SQL Server 2012:

• Use UNION and UNION ALL clauses in SELECT queries
• Modify data using MERGE statement