MCSE Data Platform SQL 2012 (70-461, 462, 463, 464 & 465) Online Training Bundle

MCSE Data Platform SQL 2012 (70-461, 462, 463, 464 & 465) Online Training Bundle

Course Outline

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 (70-461, 70-462, 70-463, 70-464 & 70-465) will qualify you for such jobs as database analyst and database designer.

OUR Price

£480.00

£400.00+ VAT

R.R.P.

£834.00

£695.00+ VAT

 

Key Features

  • 12 Months Unlimited 24x7 Online Access
    • 24x7 online access to the course materials - anytime, anywhere, and on any device. Just log-in online and learn the skills you need - all at your own pace.
  • Self-Paced Navigation
    • With all courses arranged via multiple on-demand sections, comprehensive navigation & controls allow you to fast forward, skip, rewind, restart, and effectively control your learning pace. This makes it easy to stop at any time, and then quickly get back to where you left off.
  • Expert Instructor-Led Multimedia Training
    • Get trained with full multimedia materials by the finest expert instructors in IT today. This creates a truly personal learning experience, and simulates all the benefits of classroom based learning - all from the comfort of your own home/office.
  • Multi-Tiered Exam Preparation
    • Objective Testing : Utilising questions that follow a specific module, focusing on specific key skills within that area of knowledge.
    • Full Practice Exams : Broad-base exams that cover multiple modules, or the entire syllabus.
    • Certification Practice : Learn where your strong & weak points exist. Simulators give you the chance to practice an actual certification exam. These simulators adhere to the same format as the actual exam provided by a testing centre.
    • The flexibility of these exam simulators & practice-tests allows you to monitor what you've learned, giving you the confidence required to pass your exams at the first attempt.
MCSE Data Platform SQL 2012 (70-461, 462, 463, 464 & 465) Online Training Bundle

Course Description

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.

As a Microsoft Certified Partner, you can be certain that these comprehensive SQL Server 2012 training courses will provide you with all the tools necessary to successfully prepare for your MCSE Business Intelligence SQL 2012 Certification.

This program covers the following exams:

Microsoft Exam 70-461 - Querying SQL Server 2012 Course Curriculum:

Module 1
Introduction to SQL Server 2012
SQL Instances
Editions and Licensing
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer
Object Scripting
Template Explorer
Query Tabs
Projects and Solutions
Customizing SSDT
Debugging T-SQL
SQLCMD
Exam Scenarios
Module Review

Module 2
T-SQL Overview
T-SQL Elements
Batch Separators
Line Terminator
Variables
Control Flow
Expressions
Functions
Predicates and Operators
SELECT
Column Aliasing
SELECT Execution
Exam Scenarios
Module Review

Module 3
SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module Review

Module 4
Filtering
WHERE Syntax
BETWEEN
WHERE Syntax IN
Filtering NULL Values
LIKE
Data Type Comparison
Filtering Data with WHERE
TOP
OFFSET-FETCH
Exam Scenarios
Module Review

Module 5
Join and Set Operators
Using Joins
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators
Set Operators Demo
Exam Scenarios
Module Review

Module 6
Subqueries and Table Expressions
Subqueries
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS
Common Table Expressions
Temporary Tables
Table Variables
Table Demo
Exam Scenarios
Module Review

Module 7
System Functions
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions
DISTINCT
Aggregation Demo
GROUP BY
HAVING
Conversion Functions
Exam Scenarios
Module Review

Module 8
T-SQL Programming
Logical Functions
IIF, CHOOSE and CASE
Logical Function Demo
Using Views
Stored Procedures
Functions
Triggers
Views Demo
TRY CATCH
Exam Scenarios
Module Review

Module 9
Transactions
Introduction to Transactions
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo
Managing Transactions
XACT_ABORT
Managing Transactions Demo
Exam Scenarios
Module Review

Module 10
Query Performance
Indexing
Index Strategies
Indexes Demo
Execution Plans
Statistics IO
Execution Plans Demo
Exam Scenarios
Module Review
Program Review

Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012 Databases Course Curriculum:

Module 1
Introduction to SQL Server 2012
SQL Server
SQL Server Tools
Management Studio Demo
Data Tools
Exam Scenarios
Module Review

Module 2
Installing SQL Server
SQL Architecture
Hardware Requirements
Software Requirements
Installation Process
Troubleshooting Installation
Upgrading and Unattended Installations
Configuration Demo
Exam Scenarios
Module Review

Module 3
Backup and Restore a Database
Database Architecture
Database Backup
Restoration Process
Restoring System Database
Backup and Recovery Demo
Exam Scenarios
Module Review

Module 4
Tracing Access to SQL Server
Auditing Options
Introduction to SQL Audit
Audit Objects and Implementation
Extended Events
Tracing Activity Demo
Exam Scenarios
Module Review

Module 5
Importing and Exporting Data
Introduction to Data Transfer
ETL Tools
Improving Data Transfer
Copying Database Methods
Transferring Data Demo
Exam Scenarios
Module Review

Module 6
SQL Server Security
Security and Authentication
Server and Database Roles
Permissions
Securing SQL Server Demo
Exam Scenarios
Module Review

Module 7
Automating SQL Server
SQL Server Agent
Database Mail
Operators, Alerts and Jobs
Database Configuration Demo
Exam Scenarios
Module Review

Module 8
Monitoring SQL Server
Dynamic Management Views and Functions
Profiler Trace
Database Tuning Advisor
Activity and Performance Monitor
Data Collection
Monitoring Demo
Exam Scenarios
Module Review

Module 9
Maintaining SQL Server
Checking Database Integrity
Indexing
Ongoing Maintenance
Managing and Maintaining Demo
Exam Scenarios
Module Review

Module 10
Troubleshooting SQL Server
Service Issues
Connectivity Issues
Locking Issues
Troubleshooting Demo
Exam Scenarios
Module Review
Program Review

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

Module 1
Introduction to Data Warehousing
OLTP vs. OLAP
Data Warehouse
Data Warehouse Architecture
Creating a Data Warehouse
Presenting OLAP Data
OLTP and OLAP Comparison Demonstration
Exam Scenarios
Module Review

Module 2
Designing a Data Warehouse
Data Modeling
Data Warehouse Schemas
Time Dimensions
Data Modeling Considerations
Implementing a Data Model
Logical Model
Physical Model
Dimensions and Facts
Exam Scenarios
Module Review

Module 3
ETL with SSIS
Introduction to SSIS
Upgrading SSIS Packages
SSIS Tools
Data Flow Tasks
Data Sources
Transformations
Utilizing SQL Server Data Tools
Data Flow Task
Exam Scenarios
Module Review

Module 4
SSIS Control Flow
Control Flow Tasks
Integration Services Variables
Expressions
Precedence
Containers and Annotation
Transactions
Checkpoints
Control Flow Tasks and Precedence
Exam Scenarios
Module Review

Module 5
Troubleshooting Packages
Overview of Troubleshooting
Debugging
Breakpoints
Error Handling
SSIS Log Providers
Custom Logging
Troubleshooting and Logging
Exam Scenarios
Module Review

Module 6
Advanced Packages
Maintaining a Data Warehouse
Change Data Capture
Slowly Changing Dimensions
Script Components
Incremental Updates
Exam Scenarios
Module Review

Module 7
Data Quality Services
Introduction to Data Quality Services
Data Quality Services Components
Working with Data Quality Services
Exam Scenarios
Module Review

Module 8
Master Data Services
Introduction to Master Data Services
MDS vs. DQS
How MDS Works
Exam Scenarios
Module Review

Module 9
Deployment and Security
Deployment Options
Package Deployment
Securing Packages
Deploying SSIS Packages and Projects
Exam Scenarios
Module Review
Program Review

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

Module 1
Introduction to SQL Server 2012
SQL Instances
SQL Editions
SQL Server Tools
SQL Server Management Studio
SQL Data Tools
SQL Command
Utilizing SQL Server Tools
Exam Scenarios
Module Review

Module 2
Introduction to Data Types and Tables
Collations
Unicode Characters
Null Values
Converting Data Types
Introduction to Tables
Normalization
Temporary Tables
Working with Tables
Schemas
Primary and Foreign Keys
UNIQUE Constraint/Index
In Depth Look
Exam Scenarios
Module Review

Module 3
SQL Server Indexing
Introduction to Indexing
Clustered Indexes
Non Clustered Indexes
Maintaining Indexes
Index Fragmentation
Index Tuning
Creating and Altering Indexes
Exam Scenarios
Module Review

Module 4
Query Performance
Execution Plans
Reading Execution Plans
Execution Plan Operators
Plan Reuse
Query Performance
Exam Scenarios
Module Review

Module 5
Common Language Runtime (CLR) Integration
Assemblies
Permissions
CLR Objects
Integrating the CLR within SQL Server
Exam Scenarios
Module Review

Module 6
Transact-SQL (T-SQL) Error Handling
Error Severity
TRY CATCH Error Handling
TRY PARSE and TRY CONVERT
@@ ERROR
Alerts
Error Handling in T-SQL
Exam Scenarios
Module Review

Module 7
Views and Functions
Types of Views
Working with Views
Introduction to Functions
Working with Functions
Working with Views and Functions
Exam Scenarios
Module Review

Module 8
Stored Procedures and Triggers
Working with Stored Procedures
Introduction to Triggers
Working with Triggers
Stored Procedures and Triggers Demo
Exam Scenarios
Module Review

Module 9
Working with XML
XML Concepts
Schemas and Schema Collections
FOR XML Clause
FLOWR Queries
Working with XML in SQL Server
Exam Scenarios
Module Review

Module 10
Transactions
Implicit Transactions
Explicit Transactions
Locking
Working with Transactions and Locking within SQL
Exam Scenarios
Module Review
Course Review

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

Module 1
Course Introduction
Course Modules
Introduction to SQL Server 2012
SQL Server Instances
SQL Server Editions and Licensing
SQL Server Objects
System Databases
SQL Server Management Studio
SSMS Components
SQL Server Data Tools
SQLCMD
Working with SSMS
Working with SQLCMD
Exam Scenarios
Module Review

Module 2
Introduction to Databases
Database Files
Temp db
Working with Databases
Introduction to Filegroups and Files
Introduction to Log Files
Transactions
Moving Databases
Detaching and Attaching Databases
Backing Up and Restoring Databases
Copy Database Wizard
Database Catalog View
Creating and Configuring Databases
Exam Scenarios
Module Review

Module 3
Introduction to Data Types and Tables
Supported Data Types
Collations and Unicode Characters
Introduction to NULLS
Converting Data Types
Introduction to Tables
Normalization
Temporary Tables
Working with Tables
Schemas
Primary and Foreign Keys
UNIQUE Constraint/Index
Data Types in SQL Server Demonstration
Working with Tables Demonstration
Exam Scenarios
Module Review

Module 4
SQL Server Indexing
Introduction to Indexing
Heaps
Clustered Indexes
Non-Clustered Indexes
Maintaining Indexes
Index Fragmentation
SQL Server Profiler
Index Tuning
Working with Indexes Demonstration
SQL Server Tuning Advisor Demonstration
Exam Scenarios
Module Review

Module 5
Performance Considerations
Partitioning Function
Partition Scheme
Partitioned Table or Index
Introduction to Transaction
Implicit and Explicit Transactions
Locking
Working with Partition Tables, Transaction and Locks
Exam Scenarios
Module Review

Module 6
Backup and Restore
Database Data and Log Files
Recovery Model
Database Backups Types
Backup Compression and Mirrored Media Sets
Verifying Backups
Restoration Process
Restoring Backup Types
Restoring to a Point in Time
WITH STANDBY
Restoring a Database
Restoring System Databases
Restoring the Master Database
Backing Up and Restoring SQL Server
Exam Scenarios
Module Review

Module 7
Views and Functions
Types Of Views
Creating and Altering Views
Updatable and Indexed Views
Partitioned Views
Introduction to Functions
Function Types
Scalar and Table Valued Functions
Working with Views and Functions
Exam Scenarios
Module Review

Module 8
Stored Procedures and Triggers
Types of Stored Procedures
Parameters
Stored Procedure Compilation
Execution Context
Introduction to Triggers
Types of Triggers
Nested and Recursive Triggers
Trigger Firing Order
Working with Stored Procedures and Triggers
Exam Scenarios
Module Review

Module 9
SQL Server Security
SQL Authentication
SQL Logins
Accessing a Database
Authorization Across Servers
Server Roles
Database Roles
Application Roles
Authorizing Access
Configuring Access Using Schemas
Working with SQL Security
Exam Scenarios
Module Review

Module 10
Installing and Upgrading SQL
Server Resources
32 vs. 64 Bit
SQL Requirements
Software Requirements
Collations
Service Accounts
Installing SQL Server
Troubleshooting Installation
Upgrading SQL Server
Unattended Installations
Exam Scenarios
Module Review
Course Review

(Any associated exam costs are not included)
FREE : IT Certification & Career Training Guide