MCSE Database Platform

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.

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.

Topics:

• 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