MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 Database Development + CD

Купить бумажную книгу и читать

Название: MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 Database Development

Автор: Mike Hotek, Tobias Thernstrom

ISBN: 0735626391

Издательство: Microsoft Press

Год издания: 2009

Страниц: 652

Язык: English

Формат: PDF

Размер: 81.9 Мб

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

Create and manage database objects

Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity

Create stored procedures, functions, and triggers

Manage transactions, error handling, and change tracking

Tune query performance

Implement database mail, full-text search, Service Broker, scripts

Work with XML and SQLCLR

Table of Contents

Chapter 1. Data Retrieval

Chapter 2. Modifying Data—The INSERT, UPDATE, DELETE, and MERGE Statements

Chapter 3. Tables, Data Types, and Declarative Data Integrity

Chapter 4. Using Additional Query Techniques

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

Chapter 6. Techniques to Improve Query Performance

Chapter 7. Extending Microsoft SQL Server Functionality with XML, SQLCLR, and Filestream

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

Chapter 9. An Introduction to Microsoft SQL Server Manageability Features