The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit

Database Design

Mark Horninger

• Publisher: Syngress
• Year: 2009
• ISBN:
  9780080956916
• Topic: Computer Science
• Subtopic: Cyber Security
• Index: Computer Science

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.

• 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.

Chapter 1

MCTS SQL Server 2008 Exam 433: New Features in SQL Server 2008

Exam objectives in this chapter

New Feature Overview

Reporting Services

Exam objectives review

Summary of Exam Objectives

Exam Objectives Fast Track

Exam Objectives Frequently Asked Questions

Self Test

Self Test Quick Answer Key

Introduction

Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008.

SQL Server 2008 is a fantastic product when you think about all it does. I’ve worked with SQL Server since the days of 6.5, and it’s come a long way since then.

In this chapter, we will briefly review the new features in SQL Server 2008. There are quite a few enhancements to SQL Server, many of which will make the job of the DBA much easier. One of these, the new performance data management system, allows for database statistics and performance information to be automatically captured across an enterprise.

While this chapter covers the new features in SQL Server 2008, bear in mind many of the “basic” features of SQL will also be covered on the test. This book will not only cover the new features but also the topics from earlier versions of SQL Server that have not changed, as you will also need to know these items.

Head of the Class…

Know and Understand All SQL Server 2008 Features

Be sure you understand all of the topics in this book before attempting the test. It will cover old and new features, so don’t limit your studying to just the new features. This will help you not only when it comes to the test, but also in using SQL Server 2008 in general.

A Word About the Test

On your testing day, make sure you arrive rested and ready to sit for the exam. Be calm and read each question carefully. Microsoft doesn’t try to trick you; however, the questions and answers are presented in such a way that you should think about each question before answering it.

When you take your exam, be sure to leave no question unanswered. Most questions are multiple choice, so if you can narrow it down to two possible answers, you have a 50–50 chance at getting the question right—although this book will do an excellent job of preparing you for the exam.

If you are not sure of the answer to a question, sometimes it’s good to skip that question and move on and come back to it. Another question may jog your memory, and when you come back to the first question the answer is much clearer.

When you go in for your test, don’t bring pagers, laptops, cell phones, and so on. They will not allow you to bring them in. Also be sure to bring two forms of ID. Most testing centers have video cameras, and you are taped during the exam to deter cheating.

Be sure to r...

Table of contents

• Cover image
• Title page
• Table of Contents
• Copyright
• Technical Editor
• Lead Authors
• Contributing Authors
• Chapter 1. MCTS SQL Server 2008 Exam 433: New Features in SQL Server 2008
• Chapter 2. MCTS SQL Server 2008 Exam 433: Implementing Objects
• Chapter 3. MCTS SQL Server 2008 Exam 433: Programming Objects
• Chapter 4. MCTS SQL Server 2008 Exam 433: Using the CLR
• Chapter 5. MCTS SQL Server 2008 Exam 433: Implementing Error Handling
• Chapter 6. MCTS SQL Server 2008 Exam 433: Implementing Transactions
• Chapter 7. MCTS SQL Server 2008 Exam 433: Working with DML Queries
• Chapter 8. MCTS SQL Server 2008 Exam 433: Using Advanced Functionality with DML
• Chapter 9. MCTS SQL Server 2008 Exam 433: Working with Multiple-Source Queries
• Chapter 10. MCTS SQL Server 2008 Exam 433: Demystifying Data Types
• Chapter 11. MCTS SQL Server 2008 Exam 433: Explaining Advanced Query Techniques
• Chapter 12. MCTS SQL Server 2008 Exam 433: Explaining XML
• Chapter 13. MCTS SQL Server 2008 Exam 433: Performance Tuning
• Appendix A: The Real MCTS SQL Server 2008 Exam 433: Other Components in SQL
• Appendix B: The Real MCTS SQL Server 2008 Exam 433: Self Test Appendix
• Index