MCSM: Database Platform

The pinnacle of professional distinction

In today’s competitive market, data management requirements are more complex and diverse than ever: qualified IT professionals must be able to manage transactional and business intelligence data while providing enhanced data availability, integrity, performance, and security.

Validate your deep product expertise, as well as your ability to design and build the most innovative solutions using Microsoft SQL Server technologies, by earning the MCSM: Data Platform certification.

This MCSM certification requires that you show continued ability to perform in your chosen solution area by completing a recertification exam every three years.

Querying Microsoft SQL Server 2012

  • Module 1: Introduction to Microsoft SQL Server 2012
  • Module 2: Getting Started with SQL Azure
  • Module 3: Introduction to T-SQL Querying
  • Module 4: Writing SELECT Queries
  • Module 5: Querying Multiple Tables
  • Module 6: Sorting and Filtering Data
  • Module 7: Working with SQL Server 2012 Data Types
  • Module 8: Using Built-In Functions
  • Module 9: 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 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Preparing Systems for SQL Server 2012
  • Module 3: Installing and Configuring SQL Server 2012
  • Module 4: Working with Databases
  • Module 5: Understanding SQL Server 2012 Recovery Models
  • Module 6: Backup of SQL Server 2012 Databases
  • Module 7: Restoring SQL Server 2012 Databases
  • Module 8: Importing and Exporting Data
  • Module 9: 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 19: Managing Multiple Servers
  • Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

Implementing a Data Warehouse with Microsoft SQL Server 2012

  • Module 1: Introduction to Data Warehousing
  • Module 2: Data Warehouse Hardware
  • Module 3: Designing and Implementing a Data Warehouse
  • Module 4: Creating an ETL Solution with SSIS
  • Module 5: Implementing Control Flow in an SSIS Package
  • Module 6: Debugging and Troubleshooting SSIS Packages
  • Module 7: Implementing an Incremental ETL Process
  • Module 8: Incorporating Data from the Cloud into a Data Warehouse
  • Module 9: 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 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Working with Data Types
  • Module 3: Designing and Implementing Tables
  • Module 4: Ensuring Data Integrity through Constraints
  • Module 5: Planning for SQL Server 2012 Indexing
  • Module 6: Implementing Table Structures in SQL Server 2012
  • Module 7: Reading SQL Server 2012 Execution Plans
  • Module 8: Improving Performance through Nonclustered Indexes
  • Module 9: 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

Designing Database Solutions for SQL Server 2012

MCSM: Data Platform Knowledge exam

MCSM: Data Platform Lab exam

The duration for MCSM Database Platform is:

Regular Track: 120 Hours (60 Days)

Fast Track: 120 Hours (30 Days)

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.

Exam 88-986: MCSM Data Platform Knowledge Exam

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.

The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.

  • Design a Disaster Recovery Plan and Recover from Disaster (10 %)
  • Manage an Enterprise with Many Servers (23%)
  • Secure the SQL Server Environment and Data (12%)
  • Manage System and Query Performance (22%)
  • Design and Troubleshoot High Availability Solutions (12%)
  • Develop a Database (8%)
  • Design and Maintain a Scalable Solution (7%)
  • Perform Capacity Planning (6%)

Before attending this course, students must have:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Before attending this course, students should have:

  • Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
Name:
Phone:
Email:
Experience:
Current Location:
Preferred Location:
Course Interested in:
Comments:

Enter this code here

Services

Partners