Thursday, July 24, 2014
 
  Implementing Data Integrity

Implementing Data Integrity

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
  Implementing Primary & Foreign Keys

Implementing Primary and Foreign Keys

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





  Implementing Triggers & Transactions

Implementing Triggers and Transactions

In this demonstration you will see how to:

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






Managing and Implementing Data Integrity and Business Rules Using SQL Server

In this module you will learn about naming guidelines for identifiers in schema object definitions, storage and structure of schema objects, implementing data integrity using constraints, and implementing business rules at the database level.

  Working wtih Included Index

Working with Included Index

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
  Working with Table Partitions

Working with Table Partitions

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
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM