Overview

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

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.