Home > Store > Microsoft

Module 1: Create Database Objects, Downloadable Version

Module 1: Create Database Objects, 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-399548-8
  • ISBN-13: 978-0-13-399548-0

Module 1: Create Database Objects

In this module, you will learn how to create database objects. We will start with exploring how to create and alter tables using T-SQL syntax before designing, creating, and altering views. We will then see how to create and modify constraints, and finally we will create and alter DML triggers.

Lesson 1: Create and Alter Tables Using T-SQL Syntax

In this lesson, you will learn how to create tables and specify columns and column data types. We will examine best practices and guidelines for naming database objects. Finally, we will see how to modify tables and columns.

Lesson 2: Design, Create, and Alter Views

In this lesson, you will learn how to create views and implement indexes views. We will then examine how to modify a view and use it to update data in a table.

Lesson 3: Create and Modify Constraints

In this lesson, you will learn how to define constraints and use them to enforce data integrity. We will implement primary key, foreign key, unique, check, and default constraints

Lesson 4: Create and Alter DML Triggers

In this lesson, you will learn how to create and implement both AFTER and INSTEAD OF triggers. We will then examine performance implications when using triggers.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership