Modifying Data

Practice Labs Module
Time
50 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

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
Learning Partner
Comprehensive Learning

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