courseMicrosoft 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.

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.

£599
Buy Now

What's Included

Wiki_tick  Unlimited 12 months access

Wiki_tick  Access anywhere, any time

Wiki_tick  Fast effective training, written and designed by industry experts

Wiki_tick  Unlimited support

Wiki_tick  Save money, time and travel costs

Wiki_tick  Learn at your own pace and leisure

Wiki_tick  Easier to retain knowledge and revise topics than traditional methods

What The Course Will Teach You:

laptop-notebook-working-internet
  • Developing Microsoft SQL Server 2012 Databases
  • Designing Database Solutions for Microsoft SQL Server 2012
  • Querying SQL Server 2012
  • Administering SQL Server 2012 Databases
  • Implementing a Data Warehouse with SQL Server 2012
  • Much more...

£599
Buy Now

Units Of Study

Microsoft MCSE: Data Platform Solutions Expert

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

Training Features

With eCourses4You's e-learning system, certification has never been simpler! You can be starting your IT career or taking your current IT skills to the next level in just a few short weeks. Our award winning learning system gives you all of the benefits of a live class at just a fraction of the cost.

eCourses4You’s courses include:

a1

Expert Instructor-Led Training

eCourses4You uses only the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

a2

Visual Demonstrations & Multimedia Presentations

Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. eCourses4You always focuses on real world scenarios and skill-set development.

a3

Quizzes & Exam Simulators

eCourses4You’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding.

This will allow you to gauge your effectiveness before moving to the next module in your course. eCourses4You Courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam.

a4

Social Learning & Networking

eCourses4You has designed a world class Learning Management System (LMS) This system allows you to interact and collaborate with other students and eCourses4You employees, form study groups, engage in discussions in our NOW@ Forums, rate and “like” different courses and stay up to date with all the latest industry knowledge through our forums, student contributions and announcement features. This LMS is unmatched in the industry and makes learning fun and enjoyable.
a5

Flash Cards & Educational Games

eCourses4You knows that education is not a one size fits all approach. Students learn in different ways through different tools. That is why we provide Flash Cards and Education Games throughout our courses. This will allow you to train in ways that keep you engaged and focused. Each course will have dozens of Flash Cards so you can sharpen your skill-sets throughout your training as well as educational games designed to make sure your retention level of the materials is extremely high.
a6

Navigation & Controls

eCourses4You’s self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.

System Requirements

Minimum specifications for the computer are:

Windows:

Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS:

OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)