Register your product to gain access to bonus material or receive a coupon.
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like:
MCTS Exam Cram: Implementing Database Objects
Download Chapter 3: Implementing Database Objects
Introduction
Self Assessment
Chapter 1: Installing and Configuring SQL Server 2005
Installing and Configuring SQL Server 2005
Installation Requirements
The Installation Process
Installation Preparations
Postinstallation Procedures
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 2: Creating Database Objects
Creating and Defining Databases
Using T-SQL to Create and Alter a Database
The Makeup of a Database
Standard Views, Indexed Views, and Partitioned Views
Miscellaneous SQL Server Objects
Defining SQL Server Tables
Using Types and Schemas
Using Columns with Automated or Calculated Values
Maintaining Order by Using Indexes
Primary/Foreign Keys and Relationships
Using Cascading Actions
Using DML and DDL Triggers
Partitioning Tables
Creating Partitioned Tables
SQL Server Programmability Objects
Stored Procedures
Creating CHECK Constraints
Creating Your Own Functions
English Query Capabilities with Full-Text Catalogs
Objects with Security Context
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 3: Implementing Database Objects
Data Querying and Reporting
Listing the Contents of a Table
Making a Report More Presentable
Querying a Sampling of the Data Stored
Relating Data from Multiple Tables
Applying Conditional Data Filtering
Data Querying Using Full-Text Indexes
Creating and Populating a Catalog
Using System Tables and Views
Getting Information from System Tables
Information Retrieval from System Stored Procedures
Using Dynamic Management Views and Other System Views
Inserting Data
Using UDT and the CLR to Control Data Input
Using the CLR Within Stored Procedures
Inse