You are previewing The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit.
O'Reilly logo
The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit

Book Description

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005, and it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization. The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit prepares readers for the Microsoft Certified Technology Specialist exam: SQL Server 2008, Database Development. This is a new exam in the SQL Server product family, and is comprised of some objectives from exam 70-431 from SQL Server 2005, and covers new, expanded query capabilities in SQL Server 2008. According to Microsoft:
  • Exam 70-431 for SQL Server 2005 was passed by over 35,000 people.
  • ~ 150,000 people passed a similar exam for SQL Server 2000.

Additionally, this exam is a pre-requisite for those going on to obtain the MCITP: Database Developer 2008:

  • Successful candidates for the SQL Server 2005 MCITP ~ 2,500.

The Prep Kit offers practice exams via the book's companion site.



  • This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success.
  • Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.
  • Complete study package offers Syngress proven pedagogy including practice exams via the book’s companion site

Table of Contents

  1. Cover image
  2. Title page
  3. Table of Contents
  4. Copyright
  5. Technical Editor
  6. Lead Authors
  7. Contributing Authors
  8. Chapter 1. MCTS SQL Server 2008 Exam 433: New Features in SQL Server 2008
    1. Introduction
    2. New Feature Overview
    3. Reporting Services
    4. Summary of Exam Objectives
    5. Exam Objectives Fast Track
    6. Exam Objectives Frequently Asked Questions
    7. Self Test
    8. Self Test Quick Answer Key
  9. Chapter 2. MCTS SQL Server 2008 Exam 433: Implementing Objects
    1. Introduction
    2. Understanding DDL and DML Language Elements
    3. Working with Tables, Constraints, and Indexes
    4. Viewing and Modifying Data
    5. Summary of Exam Objectives
    6. Exam Objectives Fast Track
    7. Exam Objectives Frequently Asked Questions
    8. Self Test
    9. Self Test Quick Answer Key
  10. Chapter 3. MCTS SQL Server 2008 Exam 433: Programming Objects
    1. Introduction
    2. Implementing Functions
    3. Implementing Stored Procedures
    4. Summary of Exam Objectives
    5. Exam Objectives Fast Track
    6. Exam Objectives Frequently Asked Questions
    7. Self Test
    8. Self Test Quick Answer Key
  11. Chapter 4. MCTS SQL Server 2008 Exam 433: Using the CLR
    1. Introduction
    2. CLR and Managed Code Explained
    3. CLR Integration
    4. Languages Supported
    5. What Is the Base Class Library?
    6. Registering CLR Assemblies for Use with SQL Server
    7. Understanding Permission Sets
    8. Implementing SQL Server Objects Using Managed Code
    9. Summary of Exam Objectives
    10. Exam Objectives Fast Track
    11. Exam Objectives Frequently Asked Questions
    12. Self Test
    13. Self Test Quick Answer Key
  12. Chapter 5. MCTS SQL Server 2008 Exam 433: Implementing Error Handling
    1. Introduction
    2. Understanding Errors
    3. Managing and Raising User-Defined Errors
    4. Handling Errors
    5. Summary of Exam Objectives
    6. Exam Objectives Fast Track
    7. Exam Objectives Frequently Asked Questions
    8. Self Test
    9. Self Test Quick Answer Key
  13. Chapter 6. MCTS SQL Server 2008 Exam 433: Implementing Transactions
    1. Introduction
    2. Transactions Explained
    3. ACID
    4. Isolation Level Explained
    5. Locking
    6. Deadlocking
    7. Transaction Traps
    8. Troubleshooting Transactions
    9. Summary of Exam Objectives
    10. Exam Objectives Fast Track
    11. Exam Objectives Frequently Asked Questions
    12. Self Test
    13. Self Test Quick Answer Key
  14. Chapter 7. MCTS SQL Server 2008 Exam 433: Working with DML Queries
    1. Introduction
    2. Using the INSERT Statement
    3. Using the UPDATE Statement
    4. Using the DELETE Statement
    5. Using the MERGE Statement
    6. Summary of Exam Objectives
    7. Exam Objectives Fast Track
    8. Exam Objectives Frequently Asked Questions
    9. Self Test
    10. Self Test Quick Answer Key
  15. Chapter 8. MCTS SQL Server 2008 Exam 433: Using Advanced Functionality with DML
    1. Introduction
    2. Using @@IDENTITY and NEWID Functions in DML Statements
    3. Returning Data from DML Operations Using the OUTPUT Clause
    4. Using the OUTPUT Clause with the MERGE Statement
    5. Performing Nonlogged DML Operations
    6. Summary of Exam Objectives
    7. Exam Objectives Fast Track
    8. Exam Objectives Frequently Asked Questions
    9. Self Test
    10. Self Test Quick Answer Key
  16. Chapter 9. MCTS SQL Server 2008 Exam 433: Working with Multiple-Source Queries
    1. Introduction
    2. Using Linked Servers
    3. Using Four-Part Database Names
    4. The DTC Explained
    5. OpenQuery, OpenRowSet, and OpenDataSource Explained
    6. Multiple Sources with SQL Server Integration Services
    7. Summary of Exam Objectives
    8. Exam Objectives Fast Track
    9. Exam Objectives Frequently Asked Questions
    10. Self Test
    11. Self Test Quick Answer Key
  17. Chapter 10. MCTS SQL Server 2008 Exam 433: Demystifying Data Types
    1. Introduction
    2. Built-in Data Types
    3. Functions
    4. Cast
    5. Convert
    6. Len
    7. RIGHT and LEFT Functions
    8. Replace
    9. Charindex
    10. Patindex
    11. Computed Columns
    12. Boxing and Unboxing: The Cost
    13. Summary of Exam Objectives
    14. Exam Objectives Fast Track
    15. Exam Objectives Frequently Asked Questions
    16. Self Test
    17. Self Test Quick Answer Key
  18. Chapter 11. MCTS SQL Server 2008 Exam 433: Explaining Advanced Query Techniques
    1. Introduction
    2. Implementing CTE (Common Table Expression) Queries
    3. Creating CTEs
    4. Applying Ranking Functions
    5. Controlling Execution Plans
    6. Managing Internationalization Considerations
    7. Creating and Altering Tables
    8. Summary of Exam Objectives
    9. Exam Objectives Fast Track
    10. Exam Objectives Frequently Asked Questions
    11. Self Test
    12. Self Test Quick Answer Key
  19. Chapter 12. MCTS SQL Server 2008 Exam 433: Explaining XML
    1. Introduction
    2. Retrieving and Transforming XML Data
    3. OPENXML, sp_xml_preparedocument, and sp_xml_removedocument
    4. XQuery and XPath
    5. XML Indexes
    6. XML Schema
    7. Well-Formed XML
    8. Summary of Exam Objectives
    9. Exam Objectives Fast Track
    10. Exam Objectives Frequently Asked Questions
    11. Self Test
    12. Self Test Quick Answer Key
  20. Chapter 13. MCTS SQL Server 2008 Exam 433: Performance Tuning
    1. Introduction
    2. Working with Query Execution Plans
    3. Tracing with SQL Profiler
    4. Working with Database Tuning Advisor
    5. Using Dynamic Management Views
    6. Summary of Exam Objectives
    7. Exam Objectives Fast Track
    8. Exam Objectives Frequently Asked Questions
    9. Self Test
    10. Self Test Quick Answer Key
  21. Appendix A: The Real MCTS SQL Server 2008 Exam 433: Other Components in SQL
    1. Introduction
    2. Database Mail
    3. Full-Text Search
    4. Service Broker
    5. SQL Server Management Objects
    6. LINQ
    7. Summary of Exam Objectives
    8. Exam Objectives Fast Track
    9. Exam Objectives Frequently Asked Questions
    10. Self Test
    11. Self Test Quick Answer Key
  22. Appendix B: The Real MCTS SQL Server 2008 Exam 433: Self Test Appendix
    1. Chapter 1: New Features in SQL Server 2008
    2. Chapter 2: Implementing Objects
    3. Chapter 3: Programming Objects
    4. Chapter 4: Using the CLR
    5. Chapter 5: Implementing Error Handling
    6. Chapter 6: Implementing Transactions
    7. Chapter 7: Working with DML Queries
    8. Chapter 8: Using Advanced Functionality with DML
    9. Chapter 9: Working with Multiple-Source Queries
    10. Chapter 10: Demystifying Data Types
    11. Chapter 11: Explaining Advanced Query Techniques
    12. Chapter 12: Explaining XML
    13. Chapter 13: Performance Tuning
    14. Appendix A: Other Components in SQL
  23. Index