Microsoft Certified Solutions Expert(MCSE) Microsoft SQL Server 2012/2014

comp name

Earn your MCSE certifications in sql data platform by completing the below exams. Before attempting MCSE you have to pass MCSE Certifications in MS SQL Server 2012/2014 that contains below three exams.

-> Querying Microsoft SQL Server 2012/2014 -- Exam 70-461
-> Administering Windows Server 2012 -- Exam 70-462
-> Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 -- Exam 70-463
After completion of MCSA you have to pass below two exams.
-> Developing Microsoft SQL Server Databases -- Exam 70-464
-> Designing Database Solutions for SQL Server -- Exam 70-465
After completion of MCSE in Data Platform you will qualify for Data analyst, Database designer, Database Developer and etc..

Exam Details

Required Exam(s) : Exam 70-464 and Exam 70-465
Durations : 120 Minutes (40 - 60 Questions)
Question Types : Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees : Each Exam Rs.4800(Approx)
Prerequired Exams Candidates should certified in MCSA before attempting MCSE Data Platform.
Exam Policy : Click here to read the Exam policies.
Recommended Training : To Pass 70-464 exam, its recommended to take traning on Developing Microsoft SQL Server Databases course
To pass 70 - 465 exam, its recommended to take training in Designing Database Solutions for SQL Server

Exam Pattern

Below are the exam objectives for Developing Microsoft SQL Server Databases

This exam will measure your skills and knowledge in the following areas and you must score necessary % in all areas.

1.0 Implement database objects (30–35%)
  • 1.1 Create and alter tables
  • 1.2 Design, implement and troubleshoot security
  • 1.3 Design the locking granularity level
  • 1.4 Implement indexes
  • 1.5 Implement data types
  • 1.6 Create and modify constraints
2.0 Implement programming objects (15-20%)
  • 2.1 Design and implement stored procedures
  • 2.2 Design T-SQL table-valued and scalar functions
  • 2.3 Create, use and alter user-defined functions (UDFs)
  • 2.4 Create and alter views
3.0 Design database objects (25–30%)
  • 3.1 Design tables
  • 3.2 Design for concurrency
  • 3.3 Design indexes
  • 3.4 Design data integrity
  • 3.5 Design for implicit and explicit transaction
4.0 Optimise and troubleshoot queries (25–30%)
  • 4.1 Optimise and tune queries
  • 4.2 Troubleshoot and resolve performance problems
  • 4.3 Optimise indexes
  • 4.4 Capture and analyse execution plans
  • 4.5 Collect performance and system information

Below are the exam pattern of Designing Database Solutions for Microsoft SQL Server .

In this exam you will be tested on following areas and you have to score necessary % in all areas.

1.0 Design a database structure (25–30%)
  • 1.1 Design for business requirements
  • 1.2 Design physical database and object placement
  • 1.3 Design a table and index partitioning strategy
  • 1.4 Design a migration, consolidation and upgrade strategy
  • 1.5 Design SQL Server instances
  • 1.6 Design backup and recovery
2.0 Design databases and database objects (30–35%)
  • 2.1 Design a database model
  • 2.2 Design tables
  • 2.3 Design for concurrency
  • 2.4 Design T-SQL stored procedures
  • 2.5 Design a management automation strategy
  • 2.6 Design for transactions
3.0 Design database security (10–15%)
  • 3.1 Design an application strategy to support security
  • 3.2 Design database, schema and object security permissions
  • 3.3 Design instance-level security configurations
4.0 Design a maintenance strategy for database servers
  • 4.1 Design a maintenance strategy for database servers
  • 4.2 Troubleshoot and resolve concurrency issues
  • 4.3 Design and implement a high availability solution
  • 4.4 Design a solution to monitor performance and concurrency
  • 4.5 Design a monitoring solution at the instance level

Books to Prepare

We Will Update the information Soon

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download

If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions

Other Microsoft certifications

Quick Links Of Others