Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
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.