- ~ 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 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: Working with DML Functions
Chapter 9: Working with Multiple Source Queries
Chapter 10: Demystifying Data Types
Chapter 11: Explaining Advanced Query Techniques
Chapter 12: Other Components in SQL
Chapter 13: Explaining XML
Chapter 14: Performance Tuning
Mark Horninger , A+, Net+, Security+, MCSE+I, MCSD, MCAD,MCDBA, MCTS, MCITP, MCPD is President and founder of Haverford Consultants Inc.( http://www.haverford-consultants.com/ ), located in the suburbs of Philadelphia, PA. He develops custom applications and system engineering solutions, specializing primarily in Microsoft operating systems and Microsoft BackOffice products. He is also an adjunct professor at Kaplan University in the Web department. He has over 15 years of computer consulting experience and has passed 50+ Microsoft Certified Exams. During his career Mark has worked on many extensive and diverse projects including database development, application development, training, embedded systems development and Windows NT and 200x project rollout planning and implementations. Mark lives with his wife Debbie and two children in Havertown, PA. He is the author of Configuring and Troubleshooting Windows XP Professional MCSE Windows 2000 Professional Study Guide and Designing SQL Server 2000 Databases for .NET Enterprise Servers.