SQL Server 2008 Database Development (70-433) Part 1
Part 1 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality.
What you'll learn
Part 1 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.
Table of contents
- Data Integrity 4m
- Enforcing Data Integrity 7m
- Primary Key Constraint Violation 2m
- Selecting Two-Column Primary Key 6m
- UNIQUE Constraints 7m
- FOREIGN KEY Constraints 9m
- CHECK Constraints 10m
- CHECK Constraints Using GUI 3m
- Constraints: Enabling and Disabling 1m
- Triggers in SQL Server 2008 3m
- DML Triggers 2m
- Creating a Trigger 6m
- Testing Triggers 4m
- Constraints vs. Triggers 3m
- Terminology 1m
- What We Covered 1m
- Introduction 2m
- Stored Procedure Basics 1m
- Types of Stored Procedures 1m
- Creating and Modifying a Simple Stored Procedure 6m
- Benefits of Stored Procedures vs. Transact-SQL 5m
- Creating a More Complicated Stored Procedure 9m
- Modifying a More Complicated Stored Procedure 2m
- Creating a Stored Procedure from a Template 1m
- Stored Procedures vs. Functions 2m
- Table Value Parameters 8m
- Terminology 1m
- What We Covered 1m
About the author
Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK. As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching. Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in... more