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:
Your kit includes:
A Note Regarding the CD or DVD and Practice Files
Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
Dedication; Acknowledgments; Introduction; Using the CD and DVD; Microsoft Certified Professional Program; Technical Support; Evaluation Edition Software; Chapter 1: Data Retrieval; 1.1 Before You Begin; 1.2 Lesson 1: Querying Data; 1.3 Lesson 2: Joining Related Tables; 1.4 Lesson 3: Implementing Aggregate Queries; 1.5 Lesson 4: Combining Datasets; 1.6 Lesson 5: Applying Built-in Scalar Functions; 1.7 Chapter Review; 1.8 Key Terms; 1.9 Suggested Practices; 1.10 Take a Practice Test; Chapter 2: Modifying Data—The INSERT, UPDATE, DELETE, and MERGE Statements; 2.1 Before You Begin; 2.2 Lesson 1: Modifying Data by Using INSERT, UPDATE, and DELETE Statements; 2.3 Lesson 2: Enhancing DML Functionality with the OUTPUT Clause and MERGE Statement; 2.4 Lesson 3: Managing Transactions; 2.5 Chapter Review; 2.6 Key Terms; 2.7 Suggested Practices; 2.8 Take a Practice Test; Chapter 3: Tables, Data Types, and Declarative Data Integrity; 3.1 Before You Begin; 3.2 Lesson 1: Working with Tables and Data Types; 3.3 Lesson 2: Declarative Data Integrity; 3.4 Chapter Review; 3.5 Key Terms; 3.6 Suggested Practices; 3.7 Take a Practice Test; Chapter 4: Using Additional Query Techniques; 4.1 Before You Begin; 4.2 Lesson 1: Building Recursive Queries with CTEs; 4.3 Lesson 2: Implementing Subqueries; 4.4 Lesson 3: Applying Ranking Functions; 4.5 Chapter Review; 4.6 Key Terms; 4.7 Suggested Practices; 4.8 Take a Practice Test; Chapter 5: Programming Microsoft SQL Server with T-SQL User-Defined Stored Procedures, Functions, Triggers, and Views; 5.1 Before You Begin; 5.2 Lesson 1: Stored Procedures; 5.3 Lesson 2: User-Defined Functions; 5.4 Lesson 3: Triggers; 5.5 Lesson 4: Views; 5.6 Chapter Review; 5.7 Key Terms; 5.8 Suggested Practices; 5.9 Take a Practice Test; Chapter 6: Techniques to Improve Query Performance; 6.1 Before You Begin; 6.2 Lesson 1: Tuning Queries; 6.3 Lesson 2: Creating Indexes; 6.4 Chapter Review; 6.5 Key Terms; 6.6 Suggested Practices; 6.7 Take a Practice Test; Chapter 7: Extending Microsoft SQL Server Functionality with XML, SQLCLR, and Filestream; 7.1 Before You Begin; 7.2 Lesson 1: Working with XML; 7.3 Lesson 2: Using SQLCLR and Filestream; 7.4 Chapter Review; 7.5 Key Terms; 7.6 Suggested Practices; 7.7 Take a Practice Test; Chapter 8: Extending Microsoft SQL Server Functionality with the Spatial, Full-Text Search, and Service Broker; 8.1 Before You Begin; 8.2 Lesson 1: Implementing Spatial Data Types; 8.3 Lesson 2: Implementing Full-Text Search; 8.4 Lesson 3: Implementing Service Broker Solutions; 8.5 Chapter Review; 8.6 Key Terms; 8.7 Suggested Practices; 8.8 Take a Practice Test; Chapter 9: An Introduction to Microsoft SQL Server Manageability Features; 9.1 Before You Begin; 9.2 Lesson 1: Integrating Database Mail; 9.3 Lesson 2: Implementing Scripts by Using Windows PowerShell; 9.4 Lesson 3: Tracking Data Changes; 9.5 Chapter Review; 9.6 Key Terms; 9.7 Suggested Practices; 9.8 Take a Practice Test; Case Scenario Answers; Chapter 1: Case Scenario Answers; Chapter 2: Case Scenario Answers; Chapter 3: Case Scenario Answer; Chapter 4: Case Scenario Answer; Chapter 5: Case Scenario Answer; Chapter 6: Case Scenario Answer; Chapter 7: Case Scenario Answer; Chapter 8: Case Scenario Answers; Chapter 9: Case Scenario Answers; Glossary Terms; About the Authors; System Requirements; Hardware Requirements; Software Requirements; Additional Resources for IT Professionals from Microsoft Press; Windows Server; Windows Client; SQL Server 2008; Exchange Server 2007; Scripting; Get Certified—SQL Server 2008; Also See; Exam 70-433: Microsoft® SQL Server® 2008—Database Development;
Overview
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....