Module 1: Create Database Objects, Downloadable Version

Description

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