Home > Store > Certification > Microsoft Certification

Module 3: Modify Data, Downloadable Version

Module 3: Modify Data, Downloadable Version

Downloadable Video

  • Your Price: $49.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2015
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-399550-X
  • ISBN-13: 978-0-13-399550-3

Module 3: Modify Data

In this module, you will learn how to modify data. We start first with understanding the methods to modifying data and moving to more complex combinations of datasets. Finally, we will create and implement routines that are stored in the database, procedures, and functions.

Lesson 10: Modify Data by using INSERT, UPDATE, and DELETE Statements

In this lesson, you will learn methods to insert data. We will then examine methods to update and delete data.

Lesson 11: Combine Datasets

In this lesson, you will learn various means of combining datasets. As we use different operators and statements, we will examine the optimal methods to use.

Lesson 12: Create and Alter Stored Procedures

In this lesson, you will learn how to create and execute stored procedures that use input and output parameters. We will then examine statements that implement branching logic.

Lesson 13: Work with Functions

In this lesson, you will learn the difference between deterministic and nondeterministic functions and apply the knowledge to built-in scalar functions. We will then create and implement user-defined functions (UDFs)

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership