MCSE Data Platform (Microsoft Certified Solutions Expert including Exam Vouchers)

Includes all 5 Microsoft Exam Vouchers

Get the new in-demand MCSE Data Platform Certification (SQL 2012) on your CV.

Who is the MCSE suited to?

The MCSE Data Platform (SQL 2012) study package is suited to IT professionals who want to benefit by having the latest SQL 2012 skills and be at the forefront of new technologies. Choose this certification if you want to validate and learn the skills needed for creating database files, data types, tables, the creation of plans and designs for database structure, storage, objects in a Microsoft SQL 2012 environment.

Try the training for Free

You can try the courses first with a free trial to make sure the MCSE is suited to your current experience level. You can explore the courses and get an exact idea of how the training is delivered.

Description

Earn your MCSA whilst studying for the MCSE

The MCSE consists of the following 5 exam courses:

• Microsoft 70-461: Querying SQL Server 2012
• Microsoft 70-462: Administering SQL Server 2012 Databases
• Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

After completing these 3 exams, you will earn your MCSA (Microsoft Certified Solutions Associate): SQL Server 2012 Certification.

• Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
• Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Once you have completed all 5 exams, you will have earned the Microsoft Certified Solutions Expert (MCSE): Data Platform certification.

Get Practical Experience:

As a bolt-on option, we offer Live Labs so you can practice on real live servers, routers and switches from wherever you are studying. You have unlimited access to the Labs for 1 year and can practice freely or follow set exercises that mirror the exam courses. Live Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

Need Help?

Our friendly Advisors can answer any questions you have.

------------------------------------------------------------

------------------------------------------------------------

Microsoft Exam 70-464: Developing Microsoft SQL Server 2012 Databases

Instructor Introduction
Course Outline
Module 1: SQL 2012 And The 464 Test
Module 2: Working With Data Types
Module 3: Tables
Module 4: Data Constraints
„Module 5: Planning In Indexing
Module 6: Table Structures
Module 7: Improving Performance with Non-Clustered Indexes
Module 8: Using Indexes And Execution Plans„
Module 9: Working with Views
Module 10: Designing and Implementing Stored Procedures
Module 11: Merging Data and Passing Tables
Module 12: Designing and Implementing User Functions
„Module 13: Creating Highly Concurrent SQL Server Applications
Module 14: Handling Errors in T-SQL
Module 15: Triggers
Module 16: Implementing Managed Code
Module 17: Storing XML in SQL
Module 18: Querying XML
Module 19: Working with the Spatial Data
Module 20: Working With Full Text Indexes and Queries

Microsoft Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Instructor Introduction
Course Outline
Module 1: Designing A Database Server Infrastructure
Module 2: Designing A Logical Database Scheme
Module 3: Designing A Physical Database Implementation
Module 4: Incorporating Data Files Into the Database
Module 5: Tuning Database Performance
Module 6: Designing Database Security
Module 7: Policy Based Management
Module 8: Monitoring Server Health
Module 9: Designing Database Backup Solution
Module 10: Automating Multi Server Maintenance
Module 11: Managing SQL Server With Windows Powershell
Module 12: Replicating Data
Module 13: Planning High Availability
Module 14: Review of SQL Statements
Module 15: Eleven Rules of Database Design