Overview

The globally recognized standard for IT professionals
The MCSE: Database platform demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments.Earning an MCSE: Data Platform certification will qualify you for such jobs as database analyst and database designer.This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.
How to upgrade to the MCSE: Data Platform certification
You can upgrade these certifications to the MCSE: Data Platform certification.
MCITP: Database Developer 2008
MCITP: Database Administrator 2008

Topics Covered

Querying Microsoft SQL Server 2012

Module 01: Introduction to Microsoft SQL Server 2012
Module 02: Getting Started with SQL Azure
Module 03: Introduction to T-SQL Querying
Module 04: Writing SELECT Queries
Module 05: Querying Multiple Tables
Module 06: Sorting and Filtering Data
Module 07: Working with SQL Server 2012 Data Types
Module 08: Using Built-In Functions
Module 09: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance


Administering Microsoft SQL Server 2012 Databases

Module 01: Introduction to SQL Server 2012 and its Toolset
Module 02: Preparing Systems for SQL Server 2012
Module 03: Installing and Configuring SQL Server 2012
Module 04: Working with Databases
Module 05: Understanding SQL Server 2012 Recovery Models
Module 06: Backup of SQL Server 2012 Databases
Module 07: Restoring SQL Server 2012 Databases
Module 08: Importing and Exporting Data
Module 09: Authenticating and Authorizing Users
Module 10: Assigning Server and Database Roles
Module 11: Authorizing Users to Access Resources
Module 12: Auditing SQL Server Environments
Module 13: Automating SQL Server 2012 Management
Module 14: Configuring Security for SQL Server Agent
Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
Module 16: Performing Ongoing Database Maintenance
Module 17: Tracing Access to SQL Server 2012
Module 18: Monitoring SQL Server 2012
Module 18: Managing Multiple Servers
Module 18: Troubleshooting Common SQL Server 2012 Administrative Issues


Implementing a Data Warehouse with Microsoft SQL Server 2012

Module 01: Introduction to Data Warehousing
Module 02: Data Warehouse Hardware
Module 03: Designing and Implementing a Data Warehouse
Module 04: Creating an ETL Solution with SSIS
Module 05: Implementing Control Flow in an SSIS Package
Module 06: Debugging and Troubleshooting SSIS Packages
Module 07: Implementing an Incremental ETL Process
Module 08: Incorporating Data from the Cloud into a Data Warehouse
Module 09: Enforcing Data Quality
Module 10: Using Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse


Developing Microsoft SQL Server 2012 Databases

Module 01: Introduction to SQL Server 2012 and its Toolset
Module 02: Working with Data Types
Module 03: Designing and Implementing Tables
Module 04: Ensuring Data Integrity through Constraints
Module 05: Planning for SQL Server 2012 Indexing
Module 06: Implementing Table Structures in SQL Server 2012
Module 07: Reading SQL Server 2012 Execution Plans
Module 08: Improving Performance through Nonclustered Indexes
Module 09: Designing and Implementing Views
Module 10: Designing and Implementing Stored Procedures
Module 11: Merging Data and Passing Tables
Module 12: Designing and Implementing User-Defined Functions
Module 13: Creating Highly Concurrent SQL Server 2012 Applications
Module 14: Handling Errors in T-SQL Code
Module 15: Responding to Data Manipulation via Triggers
Module 16: Implementing Managed Code in SQL Server 2012
Module 17: Storing XML Data in SQL Server 2012
Module 18: Querying XML Data in SQL Server
Module 19: Working with SQL Server 2012 Spatial Data
Module 20: Working with Full-Text Indexes and Queries
Module 21: Designing Database Solutions for SQL Server 2012


The duration for MCSE Database Platform is: :
Regular Track:120 Hours (60 Days)
Fast Track: 120 Hours (30 Days)
Certificate :
Exam 70-461: Querying Microsoft SQL Server 2012

Skills Measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Who should take this exam?
This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.
Exam 70-462: Administering Microsoft SQL Server 2012 Databases

Skills Measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Who should take this exam?
This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Skills Measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Who should take this exam?
This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Exam 70-464: Developing Microsoft SQL Server 2012 Databases

Skills Measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Who should take this exam?
This exam is intended for database professionals who build and implement databases across organizations and ensure high levels of data availability. Responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; insuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Skills Measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Who should take this exam?
This exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects and servers. They create the plan for the environment in which the database solution runs
Prerequisites

You must first earn a prerequisite certification, MCSA SQL Server 2012, which has three certification exams of its own. From there, in order to get certified on MCSE Data Platform, you will need to pass two additional SQL Server 2012 design and development certification exams. As you can imagine, preparing for these examinations requires Microsoft SQL 2012 training focused on the exam objectives. Even if you are an existing database administrator with extensive SQL Server skills, you may need to enroll in MCSE certification training in order to upgrade your skills to the 2012 version and master each of the MCSE certification exam objectives.

Contact Us