Self-Paced Training Kit (Exam 70-433) Microsoft SQL Server 2008 Database Development (MCSA)

by Thernstrom, Tobias; Hotek, Mike; Weber, Ann; GrandMasters

• ISBN13: 9780735626393
• ISBN10: 0735626391
• Edition: 1st
• Format: Paperback
• Copyright: 2009-05-20
• Publisher: Microsoft Press

Summary

Maximize your performance on 70-433, a required exam for the new MCTS: Microsoft SQL Server 2008 Database Development certification. This all new, 2-in-1 SELF- PACED TRAINING KIT includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. The kit is packed with the tools and features exam candidates want most including in-depth, self-paced training based on final exam content; rigorous, objective- by-objective review; exam tips from expert, exam- certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Work at your own pace through the lessons and lab exercises in the official study guide.

Author Biography

Tobias Thernstr¿m has 13+ years’ experience with SQL Server, serves as program manager on the SQL Engine Platform Team at Microsoft, and helped develop several Microsoft certifications for SQL Server. Ann Weber, MCITP, MCSE, is an instructor, consultant, and author with more than 12 years' experience with SQL Server. A Microsoft Certified Trainer, Ann has developed several courses and other learning materials for Microsoft.

Table of Contents

Dedication

Acknowledgments

Introduction

Data Retrieval

Modifying Data-The INSERT, UPDATE, DELETE, and MERGE Statements

Tables, Data Types, and Declarative Data Integrity

Using Additional Query Techniques

Programming Microsoft SQL Server with T-SQL User-Defined Stored Procedures, Functions, Triggers, and Views

Techniques to Improve Query Performance

Extending Microsoft SQL Server Functionality with XML, SQLCLR, and Filestream

Extending Microsoft SQL Server Functionality with the Spatial, Full-Text Search, and Service Broker

An Introduction to Microsoft SQL Server Manageability Features

Case Scenario Answers

Glossary Terms

About the Authors

System Requirements

Additional Resources for IT Professionals from Microsoft Press

Get Certified-SQL Server 2008

Exam 70-433: Microsoft® SQL Server® 2008-Database Development

Table of Contents provided by Publisher. All Rights Reserved.