Skip to main content

Module 9: Managing Schema Objects

In this module, you will learn the following:

  • Naming guidelines for identifiers in schema object definitions
  • Storage and structure of schema objects
  • Implementing data integrity using constraints
  • Implementing business rules at the database level using triggers and sequences

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 14 Minutes 19 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.


Module 9: Demo 1

In this demonstration you will see how to:

  • Define a table with a Primary Key
  • Validate with Foreign Keys
  • Insert data and view an exception and a success

Video Download
WMV

Length: 4 Minutes 36 seconds


Module 9: Demo 2

In this demonstration you will see how to:

  • Define a trigger
  • Validate and auto commit or rollback transaction (insert)

Video Download
WMV

Length: 4 Minutes 35 seconds


Module 9: Demo 3

In this demonstration you will see how to:

  • Create an Included Index with SSMS
  • Compare execution plans and results
  • Create the Included Index with T-SQL
  • Rebuild the Index

Video Download
WMV

Length: 14 Minutes 53 seconds


Module 9: Demo 4

In this demonstration you will see how to:

  • Define a partition function
  • Define a partition scheme
  • Assign an Index to a partition scheme
  • Rebuild an Index for a single partition

Video Download
WMV

Length: 10 Minutes 27 seconds