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.
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.
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.
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
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 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 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
Really informative & very positive... They cut out all the nonsense and just gave it to me in plain terms: This is what you're going to get - and this is where you'll end up. That's all I wanted really.
David : UK
My advisor told me absolutely everything I needed to know. If I needed to know the specifics of a certain subject, he told me everything about that. He was friendly and really helpful.
Leroy : UK
They seemed very knowledgeable about the course... I made a decision quite easily, based on what they said.
Donna : UK
The advice was good. It wasn't overly complicated, so I wasn't bogged down with words that were unnecessary - and I understood where they were coming from. It was very professional.
Hayley : UK
I'd definitely recommend them. I think the price was very competitive - some of the courses out there were three times the price of what they were offering. To me, it's ideal.
Clive : UK
I feel I got good value for money. If you're a practically minded person, the course is perfect. I've also passed your details onto some other people I work with, because they're also interested in that field.
Lee : UK
I'd give the course 10/10. I've already convinced someone else to do one. I just think it's awesome to be quite honest - as long as you're prepared to put the effort in.
Leroy : UK
The advisor was absolutely brilliant. I felt like he was honest... I just can't fault it really.
Shelley : UK
The advisor was very friendly. He came across as very competent with his knowledge of the industry. He gave me a lot of confidence from that point of view.
Tim : UK
The advisor was fantastic I have to say - the way he described everything and helped me to find the right course. Everything he said made sense.