Module 1: Create Database Objects, Downloadable Version
- By Marilyn White
- Published Jan 12, 2015 by Pearson IT Certification. Part of the LiveLessons series.
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.
