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

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?