Modify Data

Welcome to the Modify Data Practice Lab. In this module, you will be provided with the instructions and devices needed to develop your hands-on skills.

Overview

Learning Outcomes:

In this module, you will complete the following exercises:

  • Exercise 1 - Modifying Data using INSERT, UPDATE, and DELETE Statements

  • Exercise 2 - Performing Update Operations on Tables using T-SQL Statements

  • Exercise 3 - Performing Delete Operations on Tables using T-SQL Statements

After completing this lab, you will be able to:

  • Use the INSERT statement

  • Modify a table using UPDATE

  • Modify a table using DELETE

Exam Objectives:

The following exam objective is covered in this lab:

  • 5.3 Summarize methods used to interface with databases.

Note: Our main focus is to cover the practical, hands-on aspects of the exam objectives. We recommend referring to course material or a search engine to research theoretical topics in more detail.

Courses