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.
- 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.
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
- Introduction
- CLR and Managed Code Explained
- CLR Integration
- Languages Supported
- What Is the Base Class Library?
- Registering CLR Assemblies for Use with SQL Server
- Understanding Permission Sets
- Implementing SQL Server Objects Using Managed Code
- Summary of Exam Objectives
- Exam Objectives Fast Track
- Exam Objectives Frequently Asked Questions
- Self Test
- Self Test Quick Answer Key
- 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
- Introduction
- Using @@IDENTITY and NEWID Functions in DML Statements
- Returning Data from DML Operations Using the OUTPUT Clause
- Using the OUTPUT Clause with the MERGE Statement
- Performing Nonlogged DML Operations
- Summary of Exam Objectives
- Exam Objectives Fast Track
- Exam Objectives Frequently Asked Questions
- Self Test
- Self Test Quick Answer Key
-
Chapter 9. MCTS SQL Server 2008 Exam 433: Working with Multiple-Source Queries
- Introduction
- Using Linked Servers
- Using Four-Part Database Names
- The DTC Explained
- OpenQuery, OpenRowSet, and OpenDataSource Explained
- Multiple Sources with SQL Server Integration Services
- Summary of Exam Objectives
- Exam Objectives Fast Track
- Exam Objectives Frequently Asked Questions
- Self Test
- Self Test Quick Answer Key
- Chapter 10. MCTS SQL Server 2008 Exam 433: Demystifying Data Types
-
Chapter 11. MCTS SQL Server 2008 Exam 433: Explaining Advanced Query Techniques
- Introduction
- Implementing CTE (Common Table Expression) Queries
- Creating CTEs
- Applying Ranking Functions
- Controlling Execution Plans
- Managing Internationalization Considerations
- Creating and Altering Tables
- Summary of Exam Objectives
- Exam Objectives Fast Track
- Exam Objectives Frequently Asked Questions
- Self Test
- Self Test Quick Answer Key
- 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
- Chapter 1: New Features in SQL Server 2008
- Chapter 2: Implementing Objects
- Chapter 3: Programming Objects
- Chapter 4: Using the CLR
- Chapter 5: Implementing Error Handling
- Chapter 6: Implementing Transactions
- Chapter 7: Working with DML Queries
- Chapter 8: Using Advanced Functionality with DML
- Chapter 9: Working with Multiple-Source Queries
- Chapter 10: Demystifying Data Types
- Chapter 11: Explaining Advanced Query Techniques
- Chapter 12: Explaining XML
- Chapter 13: Performance Tuning
- Appendix A: Other Components in SQL
- Index
Product information
- Title: The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit
- Author(s):
- Release date: May 2009
- Publisher(s): Syngress
- ISBN: 9780080956916
You might also like
book
The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit
SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the …
book
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)
All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database …
book
MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The …
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
This ebook does not provide access to the CD-ROM files. Covering Microsoft's brand-new SQL 2005 administrator …