70-451 : MCITP - Designing Database Solutions Using SQL Server 2008

Retired. This product is no longer available.

The Microsoft Certified IT Professional (MCITP): Database Developer 2008 certification is an industry recognized credential. The certification is proof of a person's competence across a spectrum of skills which includes designing programming objects, designing transaction and concurrency strategy, designing XML strategy, etc.
38 38
70-451
MCITP - Designing Database Solutions Using SQL Server 2008

Here's what you will get

The PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 is part of Microsoft's Certified IT Professional (MCITP): Database Developer 2008 certification which comprises of two exams. It is a required piece to the certification. The certification is targeted at professional involved with designing program and database.

Lessons
Lessons
7+
Exercises
260+
Quizzes
126+
Flashcards
76+
Glossary of terms
76+
TestPrep
Pre-assessment Questions
15+
Full Length Tests
5+
Post-Assessment Questions
50+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
2+
Minutes
02+
Exam FAQs
What is the exam registration fee? USD 150
Where do I take the exam? The MCITP - Designing Database Solutions Using SQL Server 2008 is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What are the pre-requisites of the exam? While there are no official prerequisites to take the Microsoft Certified IT Professional (MCITP): Database Developer 2008 certification, both Microsoft and uCertify strongly recommend that the candidate should have experience of writing transact SQL queries, programming the database and many more.
How many questions are asked in the exam? The exam contains 50 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 70%

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 exam, Microsoft's retake policy is:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least a 24-hour period before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time. Click here for more information.
What is the validity of the certification? Microsoft Certified IT Professional (MCITP): Database Developer 2008 certification has no expiration. The certification holder is certified for life unless the vendor changes their policy.
Where can I find more information about this exam? To know more about the 70-451, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

A Microsoft Certified IT Professional (MCITP): Database Developer 2008 certification has several career opportunities open up to them, including:

  • Database Developer
  • Database Administrator

Here's what you will learn

  • Overview
  • Identify which SQL Server components to use to support business requirements
  • Design a database model
  • Design a data model by using the Entity Framework
  • Design an application strategy to support security
  • Design a solution by using Service Broker
  • Design a Full-Text Search strategy
  • Identify the appropriate usage of new data types
  • Design tables
  • Design data integrity
  • Design T-SQL stored procedures
  • Design views
  • Design T-SQL table-valued and scalar functions
  • Design Common Language Runtime (CLR) table-valued and scalar functions
  • Design CLR stored procedures, aggregates, and types
  • Evaluate special programming constructs
  • Design the locking granularity level
  • Design for implicit and explicit transactions
  • Design for concurrency
  • Design XML storage
  • Design a strategy to query and modify XML data
  • Design a query strategy by using FOR XML
  • Design a strategy to transform XML into relational data
  • Optimize and tune queries
  • Analyze execution plans
  • Evaluate the use of row-based operations vs. set-based operations
  • Optimize indexing strategies
  • Design scalable database solutions
  • Resolve performance problems by using plan guides
  • Design a table and index compression strategy
  • Design a table and index partitioning strategy