Course 10363: Data Integrity Using Constraints in Microsoft SQL Server 2008 R2

Introduction This two-hour course provides you with the knowledge and skills required for implementing data integrity by using constraints in Microsoft SQL Server 2008 R2.

This course covers the following topics.

• Describing data integrity
• Enforcing domain integrity
• Enforcing entity integrity
• Enforcing referential integrity
• Best practices for implementing data integrity by using constraints in Microsoft SQL Server 2008 R2

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:

• A good general knowledge of database concepts.
• Experience working with Windows and programming concepts.
• Understanding of server management concepts such as roles and tracing.
• A basic understanding of XML.

Objectives At the end of the course, students will be able to:

• Describe data integrity.
• Enforce domain integrity.
• Enforce entity integrity.
• Enforce referential integrity.
• List best practices for implementing data integrity by using constraints in Microsoft SQL Server 2008 R2.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Data Integrity Using Constraints in Microsoft SQL Server 2008 R2 Module Overview Describing Data Integrity Describing Data Integrity Types of Data Integrity SQL Server Objects Used for Data Integrity Enforcing Data Integrity Considerations for Using Constraints Self Test Enforcing Domain Integrity Enforcing Domain Integrity Null Constraints Default Constraints Check Constraints Creating Domain Constraints Altering and Dropping Domain Constraints Self Test Enforcing Entity Integrity Enforcing Entity Integrity Primary Keys Unique Constraints Creating Primary Keys and Unique Constraints Altering and Dropping Primary Keys and Unique Constraints Self Test Enforcing Referential Integrity Enforcing Referential Integrity Referential Integrity Foreign Keys Understanding Cascading Referential Integrity Options Using Check Constraints to Complement Referential Integrity Creating Referential Integrity Testing Referential Integrity Self Test Best Practices Best Practices Lab: Data Integrity Using Constraints in Microsoft SQL Server 2008 R2 Lab: Data Integrity Using Constraints in Microsoft SQL Server 2008 R2 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled