Microsoft MCSE Data Platform Solutions Expert

Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments.

Offer Price: £99  (RRP £599)

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, creation of plans and designs for database structure, storage, objects in a Microsoft SQL 2012 environment.

The following courses are included in this bundle

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Module 1: SQL 2012 And The 464 Test

1.1 Introduction
1.2 Intro To SQL Server 2012­ Part 1
1.3 Intro To SQL Server 2012­ Part 2
1.4 Management Studio Demo ­Part 1
1.5 Management Studio Demo­ Part 2
1.6 Management Studio Demo­ Part 3
1.7 Other SQL Server Tools

Module 2: Working With Data Types

2.1 Working With Data Types­ Part 1
2.2 Working With Data Types­ Part 2
2.3 Working With Data Types ­Part 3
2.4 Other Data Types

Module 3: Tables

3.1 Tables
3.2 Creating Tables

Module 4: Data Constraints

4.1 Data Constraints­ Part 1
4.2 Data Constraints ­Part 2

Module 5: Planning In Indexing

5.1 Planning In Indexing ­Part 1
5.2 Planning In Indexing ­Part 2
5.3 Planning In Indexing ­Part 3
5.4 Planning In Indexing ­Part 4

Module 6: Table Structures

6.1 Table Structures
6.2 Working With Clustered Indexes
6.3 Clustered Indexes
6.4 Designing Effective Clustered Indexes

Module 7: Improving Performance with Non­Clustered Indexes

7.1 Improving Performance With Non­Clustered Indexes­ Part 1
7.2 Improving Performance With Non­Clustered Indexes­ Part 2
7.3 Improving Performance With Non­Clustered Indexes­ Part 3

Module 8: Using Indexes And Execution Plans

8.1 Using Indexes
8.2 Execution Plans ­Part 1
8.3 Execution Plans Demo
8.4 Execution Plans­ Part 2

Module 9: Working with Views

9.1 Working With Views ­Part 1
9.2 Working With Views­ Part 2

Module 10: Designing and Implementing Stored Procedures

10.1 Designing And Implementing Stored Procedures ­Part 1
10.2 Designing And Implementing Stored Procedures ­Part 2
10.3 Designing And Implementing Stored Procedures ­Part 3

Module 11: Merging Data and Passing Tables

11.1 Merging Data And Passing Tables ­Part 1
11.2 Merging Data And Passing Tables­ Part 2
11.3 Merging Data And Passing Tables­ Part 3

Module 12: Designing and Implementing User Functions

12.1 Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

13.1 Creating Highly Concurrent SQL Server Applications ­Part 1
13.2 Creating Highly Concurrent SQL Server Applications­ Part 2
13.3 Creating Highly Concurrent SQL Server Applications­ Part 3

Module 14: Handling Errors in TSQL

14.1 Handling Error In T­SQL ­Part 1
14.2 Handling Error In T­SQL­ Part 2

Module 15: Triggers

15.1 Triggers

Module 16: Implementing Managed Code

16.1 Implementing Managed Code­ Part 1
16.2 Implementing Managed Code­ Part 2
16.3 Implementing Managed Code ­Part 3

Module 17: Storing XML in SQL

17.1 Storing XML In SQL­ Part 1
17.2 Storing XML In SQL­ Part 2
17.3 Storing XML In SQL ­Part 3

Module 18: Querying XML

18.1 Querying XML­ Part 1
18.2 Querying XML­ Part 2
18.3 Querying XML­ Part 3

Module 19: Working with the Spatial Data

19.1 Working With Spatial Data­ Part 1
19.2 Working With Spatial Data­ Part 2
19.3 Working With Spatial Data­ Part 3

Module 20: Working With Full­Text Indexes and Queries

20.1 Working With Full­ Text Indexes And Queries ­Part 1
20.2 Working With Full­ Text Indexes And Queries ­Part 2
20.3 Working With Full­ Text Indexes And Queries ­Part 3
20.4 Outro

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

This course prepares students for the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam. The course teaches students how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. The course describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Module 1: Designing A Database Server Infrastructure

1.1 Introduction
1.2 Desiging A Database Server Infrastructure Part 1
1.3 Desiging A Database Server Infrastructure Part 2
1.4 Desiging A Database Server Infrastructure Part 3
1.5 Desiging A Database Server Infrastructure Part 4
1.6 Considerations For Database Server Consolidation
1.7 Managing Server Resources

Module 2: Designing A Logical Database Scheme

2.1 Designing A Logical Database Scheme Part 1
2.2 Designing A Logical Database Scheme Part 2
2.3 Designing A Logical Database Scheme Part 3
2.4 Designing A Logical Database Scheme Part 4
2.5 Designing A Logical Database Scheme Part 5

Module 3: Designing A Physical Database Implementation

3.1 Designing A Physical Database Implementation Part 1
3.2 Designing A Physical Database Implementation Part 2
3.3 Designing A Physical Database Implementation Part 3

Module 4: Incorporating Data Files Into the Database

4.1 Incorporating Data Files Into The Database Part 1
4.2 Incorporating Data Files Into The Database Part 2
4.3 Incorporating Data Files Into The Database Part 3
4.4 Incorporating Data Files Into The Database Demo
4.5 Searching Data Files
4.6 Searching Data Files Demo

Module 5: Tuning Database Performance

5.1 Tuning Database Performance Part 1
5.2 Tuning Database Performance Part 2
5.3 Tuning Database Performance Part 3
5.4 Working With Query Plans Part 1
5.5 Working With Query Plans Part 2
5.6 Working With Query Plans Part 3
5.7 Working With Query Plans Part 4

Module 6: Designing Database Security

6.1 Designing Database Security Part 1
6.2 Designing Database Security Part 2
6.3 Contained Databases
6.4 Protecting Data With Encryption

Module 7: Policy Based Management

7.1 Policy Based Management
7.2 Policy Based Management Demo

Module 8: Monitoring Server Health

8.1 Monitoring Server Health
8.2 Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

9.1 Designing Database Backup Solution Part 1
9.2 Designing Database Backup Solution Part 2
9.3 Designing Database Backup Solution Part 3
9.4 Designing Database Backup Solution Part 4
9.5 Disaster Recovery Plan Part 1
9.6 Disaster Recovery Plan Part 2

Module 10: Automating Multi Server Maintenance

10.1 Automating Multi Server Maintenance
10.2 Managing Multiple Servers

Module 11: Managing SQL Server With Windows Powershell

11.1 Managing SQL Server WIth Windows Powershell
11.2 Windows Powershell Lab

Module 12: Replicating Data

12.1 Replicating Data Part 1
12.2 Replicating Data Part 2
12.3 Replicating Data Part 3

Microsoft 70-461: Querying SQL Server 2012

This course provides students with the technical skills required to be prepared for the 70-461 Querying SQL Server 2012 exam. Students will acquire the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.

Lesson 1: Getting Started with SQL Server 2012
Lesson 2: Working with T-SQL
Lesson 3: Writing SELECT Queries
Lesson 4: Working with SQL Data Types
Lesson 5: Sorting and Filtering Data
Lesson 6: Querying Data from Multiple Tables
Lesson 7: Modifying Data
Lesson 8: Working with SQL Server Built-in Functions
Lesson 9: Programming in T-SQL
Lesson 10: Implementing Stored Procedures
Lesson 11: Working with Subqueries and Table Expressions
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
Lesson 14: Managing Error Handling and Transactions
Lesson 15: Querying SQL Server System
Lesson 16: Optimizing Query Performance

Microsoft 70-462: Administering SQL Server 2012 Databases

This course is preparation for the 70-462 Administering SQL Server 2012 exam. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database, and focuses on teaching students how to use SQL Server 2012 product features and tools related to maintaining a database.

Lesson 1: Identifying the SQL Server Platform
Lesson 2: Deploying SQL Server
Lesson 3: Configuring SQL Server
Lesson 4: Managing Databases in SQL Server 2012
Lesson 5: Managing SQL Server Security
Lesson 6: Implementing Advanced Security Settings
Lesson 7: Applying Encryption and Compression
Lesson 8: Working with Indexes and Log Files
Lesson 9: Working with Backup and Restore
Lesson 10: Implementing High Availability
Lesson 11: Optimizing Server Performance
Lesson 12: Troubleshooting Issues and Recovering Databases Lesson 13: Performing Advanced Database Management Tasks

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

This course is preparation for the 70-463 Implementing a Data Warehouse with SQL Server 2012 exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Module 1: Introduction to Data Warehouses

1.1 Overview of Data Warehouses
1.2 Examine Data Warehousing Concepts
1.3 Introduction to Data Analysis and Reporting Concepts

Module 2: Creating Dimensions and Changing Granularity of Dimensions

2.1 Create Dimensions
2.2 Change Granularity

Module 3: Creating Fact Tables and Columnstore Indexes

3.1 Create Fact Tables
3.2 Create Columnstore Indexes

Module 4: Implementing Data Warehouses in SQL Server 2012

4.1 Overview of Data Warehouse Components
4.2 Install Integration Services

Module 5: Working with Integration Services

5.1 Create an SSIS Project
5.2 Add Packages to an SSIS Project

Module 6: Managing Control Flow

6.1 Deploy a Control Flow
6.2 Execute Packages from Different Control Flow

Module 7: Working with Dynamic Variables

7.1 Create Expressions with Variables
7.2 Create Package Templates

Module 8: Implementing Data Flow

8.1 Add Data Flow Components to a Data Flow Task
8.2 Perform Transformation Tasks
8.3 Track Changed Data

Module 9: Managing Data Flow

9.1 Add Script Tasks and Script Components to an SSIS Package
9.2 Profile OLTP Data
9.3 Cleanse Data Using DQS

Module 10: Managing SSIS Package Execution

10.1 Execute SSIS Packages on the Server
10.2 Configure the Package Execution Strategy

Module 11: Debugging and Troubleshooting Packages

11.1 Debug Package Execution Components
11.2 Troubleshoot Package Failures

Module 12: Deploying Packages

12.1 Deploy SSIS Packages
12.2 Examine MSI Packages

Module 13: Securing Packages and Databases

13.1 Secure Packages
13.2 Secure Databases

Module 14: Working with MDS and Windows Azure

14.1 Configure MDS
14.2 Work with MDS Databases
14.3 Work with Windows Azure