Modifying Data
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.

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:
- Creating and Altering Stored Procedures
- Modify Data using INSERT, UPDATE and DELETE Statements
- 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
See the full benefits of our immersive learning experience with interactive courses and guided career paths.