Developing SQL Server 2012 Databases

(70-464)/ISBN:978-1-61691-161-4

This course includes
Lessons
TestPrep

Gain hands-on expertise in the Developing Microsoft SQL Server 2012 Database: 70-464 exam with Developing SQL Server 2012 Databases course and live-lab. Live-lab is a real computer equipment, networked together and conveniently accessible over the internet using virtualization. A live-lab has equipment such as a computer, server, switch or router in it that a user is free to configure. The Developing SQL Server 2012 Databases course and live-lab cover all the objectives of 70-464 exam which include implementing of database and programming objects, designing database objects, optimizing, and troubleshooting queries.

Here's what you will get

The Developing Microsoft SQL Server 2012 Database exam is a part of Microsofts MCSE Database Platform certification. It is a required part to the certification. This certification is targeted at database analyst and database designer who have skills and knowledge for implementing database and programming objects, designing database objects, optimizing, and troubleshoot queries.You have to pass MCSA/MCSE - Querying Microsoft SQL Server 2012, Administering Microsoft SQL Server 2012 Databases, Implementing a Data Warehouse with SQL Server 2012 (70-463), MCSE - Designing Database Solutions for Microsoft SQL Server along with 70-464 exam to achieve MCSE Database Platform certification.

Lessons

4+ Lessons | 301+ Exercises | 102+ Quizzes | 91+ Flashcards | 91+ Glossary of terms

TestPrep

30+ Pre Assessment Questions | 6+ Full Length Tests | 45+ Post Assessment Questions | 270+ Practice Test Questions

Here's what you will learn

Download Course Outline

Lessons 1: Implement Database Objects

  • Create and alter tables
  • Design, implement, and troubleshoot security
  • Design the locking granularity level
  • Maintain indexes
  • Implement data types
  • Create and modify constraints (complex statements)
  • Work with XML data

Lessons 2: Implement Programming Objects

  • Write automation scripts
  • Design and implement stored procedures
  • Design T-SQL table-valued and scalar functions
  • Create, use, and alter user-defined functions (UDFs)
  • Create and alter views

Lessons 3: Design Database Objects

  • Design tables
  • Design for concurrency
  • Create and alter indexes
  • Design data integrity
  • Design for implicit and explicit transactions

Lessons 4: Optimize and Troubleshoot Queries

  • Optimize and tune queries
  • Troubleshoot and resolve performance problems
  • Optimize indexing strategies
  • Capture and analyze execution plans
  • Collect performance and system information

Exam FAQs

There are no technical prerequisites for this certification.

USD 150

Pricing and taxes may vary from country to country.

Microsoft's 70-464 exam is administered by Prometric and Pearson VUE at testing centers worldwide.* For Pearson VUE: Click here to find a testing center near you.* For Prometric: Click here to find a testing center near you.

The exam consists of Linear, Multiple-choice, and fact based questions.

The exam contains 40-60 questions.

120 minutes

In the event that you fail your first attempt at passing the 70-464 examination, Microsofts retake policy is:* If a candidate fails in first attempt, he needs to wait for 24 hours to retake the exam.* If he fails in second, third, and subsequent attempts, he need to wait for 14 days before rescheduling the exam.* If a candidate has passed the examination, he/she cannot retake it again.

The MCSE Data Platform Certification has no expiration. The certification holder is certified for life unless the vendor changes its policy. Click here for more information.