We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSE: SQL Server 2012 Data Platform

MCSE: SQL Server 2012 Data Platform Course



  • Microsoft Certified Solutions Expert(MCSE) SQL Certification


  • classroom training. Instructor led hands-on classes.

Certification Exams:

  • 5 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • MCSE SQL Course

Course Length:

  • 7 Weeks or Fast Track 7 Days


  • Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training


  • Liverpool Street, London
  • London Bridge, London
  • Moorgate, London

Flexible Starting Dates:

  • on Weekdays, Weekends and Evenings

Brochure Request

Live Instructor-Led Classes

Virtual Training is the same as Face-to-Face Training

Virtual Classroom is the best option for anyone wishing to get an instructor-led training - while staying in the comfort of their home or office.

Call Us: 0207 256 2268


COVID-19 Statement

We are open and delivering training as normal

Monday 30th June 2020

To all our valued students,

We are all experiencing incredibly confusing and unpredictable times. In consideration of the ongoing uncertainty regarding COVID-19, we wish to reassure you that we are taking necessary precautions to protect the health, safety and well-being of our customers, our employees and our partners.

We will continue to operate our business in accordance with government guidelines. We are accepting new registration and delivering on going training as normal.

We understand the importance of our customers feeling safe and comfortable in their homes. For your peace of mind, we are offering a safe and contact free LIVE online tutor led training too.

We are closely monitoring the advice and information provided by the government and commit to updating you if anything changes. Rest assured, our priority remains providing you with the quality training in the safest possible way.

We would also like to take some time to thank our incredible emergency services and NHS staff for their unbelievable and unprecedented support. We give thanks to those working tirelessly to keep us all safe and healthy. For more information, please click here.

As always our customer services team are available to help with any queries on 0207-256-2268 and through our contact us pages.

We wish good health to you, your friends and your family at this time.

Stay safe.

Training Square Team.

Yes we are open for training with a small number of students per class, considering government guidelines, and with social distancing in place.

- Our opening and closing hours are:
Mon to Fri - 10:00 till 17:00
Saturday - 10:00 till 1700

Yes, we have followed the government guidelines with social distancing. We are providing access to hand sanitizer to all our students, providing disposable masks and keeping the place clean and tidy.

Yes, the majority of our courses can be done LIVE online tutor led. You can join the scheduled classes with the tutor online. The online live classes are the same as the scheduled classes and the only difference is, you will be attending from wherever you wish to, as long as you have reliable internet access.

Finance Available

0% Interest

Spread The Cost of Your Training Across 12 Months

Course Fee: £3000

3 months - £600 Upfront and monthly payments of £800

6 months - £600 Upfront and monthly payments of £400

12 months - £600 Upfront and monthly payments of £200

Enquire Now

Time Table

This is an On-Demand course. Please call us on 0207 256 2268 to arrange the training as per your requirement.

MCSE: SQL Server 2012 Data Platform Course Description

Get trained in MCSE SQL Server 2012 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.

MCSE SQL Server 2012 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSE SQL 2012 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2012 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.

SQL Server 2012 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2012 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large scale data warehousing capabilities, make SQL Server 2012 stands out in the market.

Whether you are novice in database technology or a basic user, we have a well structured classroom based, hands-on, tutor led training on SQL courses in London, delivered by our expert, certified and industry experienced trainers.

We would like to warmly welcome you to our SQL server 2012 course where you would be well equipped with SQL Server industrial skills and eventually be fully prepared for MCSE SQL 2012 Certification.

MCSE: SQL Server 2012 Data Platform Course Highlight

  • EXAM 70-461 - Querying Microsoft SQL Server 2012
  • EXAM 70-462 - Administering Microsoft SQL Server 2012 Databases
  • EXAM 70-463 - Implementing a Data Warehouse with Microsoft SQL
  • EXAM 70-464 - Developing Microsoft SQL Server 2012 Databases
  • EXAM 70-465 - Designing Database Solutions for SQL Server 2012
  • MCSE SQL Course

MCSE: SQL Server 2012 Data Platform

MCSE SQL Exam: Querying Microsoft SQL Server 2012 70-461

Microsoft SQL Server 2012 and Tools

  • Overview Microsoft SQL Server 2012
  • MS SQL Server Management Studio
  • Creating and Managing T-SQL scripts
  • Microsoft SQL Server 2012 architecture

SQL Azure

  • Overview of SQL Azure
  • Features of SQL Azure.
  • Provision a SQL Azure server and configure its security.

T-SQL Querying

  • T-SQL Scripts, Sets, Predicate Logic
  • Logical Order of Operations in SELECT statements
  • SELECT Statements, filter data, sort data using ORDER BY

SELECT Queries

  • SELECT statement, focusing on queries against a single table.
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • CASE Expressions, DISTINCT clause

Querying Multiple Tables

  • Understanding Joins, Inner Joins, Outer Joins, Cross Joins, Self Joins,
  • Multiple-Table Inner Join, self-joins and cross joins queries

Sorting and Filtering Data

  • Sorting Data, WHERE Clause, TOP and OFFSET-FETCH, ORDER BY

Working with SQL Server 2012 Data Types

  • SQL Server 2012 Data Types, Character Data, Character Functions

Using Built-In Functions, Grouping and Aggregating Data

  • Writing Queries with Built-In Functions, Conversion Functions
  • Using Logical Functions, Functions to Work with NULL
  • Using Aggregate Functions, GROUP BY Clause,
  • Filtering Groups with HAVING

Using Subqueries and Table Expressions

  • Correlated Subqueries, Self-Contained Subqueries
  • Using Derived Tables, Common Table Expressions
  • Using Views, Inline Table-Valued Functions

Using Set Operators

  • Using EXCEPT and INTERSECT, Set Operators
  • UNION set operators and UNION ALL multi-set operators
  • CROSS APPLY and OUTER APPLY operators
  • EXCEPT and INTERSECT operators

Pivoting and Grouping Sets


Querying SQL Server Metadata

  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects
  • Querying System Catalog Views
  • Querying System Functions
  • Querying System Dynamic Management Views

Executing Stored Procedures

  • Passing Parameters to Stored Procedures, Dynamic SQL
  • Pass parameters to stored procedures
  • Execute system stored procedures

Programming with T-SQL

  • Controlling Program Flow and Elements
  • Variables and Delimiting Batches, Synonyms, Error Handling, TRY / CATCH Blocks, THROW

Implementing Transactions

  • Transactions and the Database Engine, Controlling Transactions, BEGIN, COMMIT, and ROLLBACK
  • Adding error handling to a CATCH block

Improving Query Performance

  • Factors in Query Performance, Execution Plans, role of indexes

MCSE SQL Exam: Administering Microsoft SQL Server 2012 Databases 70-462

MS SQL Server 2012 and its Toolset

  • SQL Server Platform, Server Tools, SQL Service Services, Component Installation
  • SQL Server New Instance, Name Pipes Protocol, Aias
  • Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port

Preparing Systems for SQL Server 2012

  • SQL Server Architecture, Resource Requirement,
  • Test Server, Memory Configuration

Installing and Configuring SQL Server 2012

  • Installing SQL Server, Upgrading and Automating Installation
  • Install the SQL Server instance, Configure Server Memory

Database, Datafiles and SQL Server 2012 Recovery Models

  • MS SQL Server Databases Data Files, Log files
  • Working with Files and Filegroups
  • Moving Database Files, tempdb configuration, RateTracking datbase
  • Adjust tempdb configuration
  • Create the RateTracking database
  • Attach the OldProspects database
  • Add multiple files to tempdb
  • Backup Strategies, SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy, Recovery Models
  • Plan a backup strategy, Configure Reovery Models
  • Critical concepts surrounding backup strategies.
  • Transaction logging capabilities within the SQL Server database engine.
  • .

Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs, Managing Database Backups
  • Working with Backup Options, Investigate backup compression
  • Differential, Copy-only, Partial backup

Restoring SQL Server 2012 Databases

  • Restoring Databases, Restore Process, Point-in-time recovery
  • Restoring System Databases and Individual Files
  • Restore strategy, STANDBY mode

Importing and Exporting Data

  • Importing & Exporting Table Data, Inserting Data in Bulk
  • Import the Excel spreadsheet, CSV File

Authenticaton and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers, Create and Manage Logins, Database Users vs OS Users

Server and Database Roles

  • Server Roles, Fixed Database Roles, User-defined Database Roles, Check Role Assignments

Authorizing Users to Access Resources

  • User Access to Objects, Execute Code, Permission Schema Level

Auditing SQL Server Environments

  • Auditing Data Access in SQL, SQL Server Audit
  • Audit configuration and create audit

Automating SQL Server 2012 Management

  • Automating SQL Server Management
  • SQL Server Agent, Agent Jobs
  • Troubleshoot a Failing Job
  • SQL Server Agent Security, Configuring Credentials

Monitoring SQL Server 2012 with Alerts and Notifications

  • Configuration of Database Mail, SQL Server Errors
  • Monitoring SQL Server Errors, Alerts and Notifications
  • Configuring Operators, Alerts and Notifications

Performing Ongoing Database Maintenance

  • Ensuring Database Integrity, Maintaining Indexes
  • Check database integrity using DBCC CHECKDB
  • Correct index fragmentation
  • Create a database maintenance plan
  • Investigate table lock performance

Tracing Access to SQL Server 2012

  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Configure SQL Trace

Monitoring SQL Server 2012

  • Monitoring Activity, Capturing and Managing Performance Data
  • Configure Management Data Warehouse
  • Configure Instances for Data Collection
  • Work with Data Collector Reports

Managing Multiple Servers

  • Working with Multiple Servers, Virtualizing, Data-Tier Applications,

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

MS SQL 2012 Data Warehousing

  • Data Warehousing, Data Warehouse Solution, ETL solution
  • Planning and Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances

Designing and Implementing a Data Warehouse

  • Logical Design for a Data Warehouse, Physical Design for a Data Warehouse
  • Implementing a Star Schema, Snowflake Schema and Time Dimension Table

Creating an ETL Solution with SSIS and SSIS Package

  • ETL with SSIS, Source Data, Data, Flow
  • Control Flow, Creating Dynamic Packages
  • Using Containers, Managing Consistency
  • Using Variables and Parameters, Containers, Transactions, Checkpoints

Troubleshooting SSIS Packages

  • Debugging an SSIS Package, Logging, Errors, Event Handler

Implementing an Incremental ETL Process

  • Incremental ETL, Extracting Modified Data
  • Loading Modified Data, Using a DateTime Column to Incrementally Extract Data
  • Using a Change Data Capture, Using Change Tracking
  • Using a Lookup Transformation to Insert Dimension Data
  • Using a MERGE Statement to Load Fact Data

Cloud Data into a Data Warehouse

  • Cloud Data Sources, SQL Server Database
  • The Windows Azure Marketplace, SQL Azure Database

Enforcing Data Quality and Deduplicating Data

  • Data Quality, Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Creating a Matching Policy, DQS Project to Match Data

Using Master Data Services

  • Implement a Master Data Services
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules

Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Planning SSIS Package Execution, Create a SSIS Catalog
  • SSIS Solution
  • Scheduling SSIS Packages with SQL Server Agent

Consuming Data in a Data Warehouse

  • Business Intelligence, Reporting, Data Analysis, PowerPivot

Developing Microsoft SQL Server 2012 Databases 70-464

Designing and Implementing Tables

  • Designing Tables, Working with Schemas
  • Creating and Altering Tables, Table Design
  • Improving the Design of Tables

SQL Server 2012 Indexing

  • Core Indexing Concepts
  • Data Types and Indexes

Implementing Table Structures in SQL Server 2012

  • SQL Server Table Structures, Clustered Indexes,
  • Comparing the Performance of Clustered Indexes vs. Heaps

Designing Effective Nonclustered Indexes

  • Implementing Nonclustered Indexes, Database Engine Tuning Advisor
  • Nonclustered index, SQL Server Profiler and Database Engine Tuning Advisor

Designing and Implementing Views, Stored Procedures

  • Introduction to Views, Creating and Managing Views
  • Performance Considerations for Views
  • Introduction to Stored Procedures, Manage and Implement Stored Procedures
  • Implementing Parameterized Stored Procedures

User-Defined Functions

  • Overview of Functions, Implementing Scalar Functions, Table-Valued Functions

Creating Highly Concurrent SQL Server 2012 Applications

  • Introduction to Transactions, Locks, Deadlocks, Isolation Levels

Responding to Data Manipulation via Triggers

  • Implementing DML Triggers
  • Designing DML Triggers
  • Advanced Trigger Concepts

Implementing Managed Code in SQL Server 2012

  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Storing XML Data and Schemas in SQL Server
  • Introduction to XML and XML Schemas
  • Implementing the XML Data Type
  • XML Data Storage in SQL Server, XML Data in Variables

Querying XML Data in SQL Server

  • Using the T-SQL FOR XML Statement
  • XQuery, Shredding XML
  • Query SQL Server data as XML

Working with Full-Text Indexes and Queries

  • Introduction to Full-Text Indexing, stoplist

Designing Database Solutions for SQL Server 2012 70-465

Designing a Database Server Infrastructure

  • Introduction to Database Server Infrastructure
  • Planning a Database Server Infrastructure
  • Planning for Consolidation, Single Instance, Single Windows Server, Virtual Servers

Designing a Database Solution for BLOB Data

  • Considerations for BLOB Data, Working with FileStream
  • Using Full-text Search, Creating FileTable

Tuning Database Performance

  • Optimizing Query Performance with Indexes,
  • Performance Monitoring and Tuning

Designing Database Security

  • Designing Database-Level Security, Server -Level Security, Transparent Database Encryption
  • Security for MIA-SQL Instance and the Human Resources Database
  • Implementing Security for SQL Server Agent

Monitoring Server Health

  • Using the SQL Server Utility
  • Creating a Utility Control Point, Configuring Health Policies
  • Analyzing Server Health Issues

Managing SQL Server with PowerShell

  • Introduction to PowerShell, Backing up a Database Using PowerShell

Replicating Data

  • SQL Server Replication, Plan and Implementing Replication

Price Info: £3000

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat






Package Offer: Great Savings!!!

Professional Package

£4200Saving £550

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
Oracle 11g OCP - £3500

Total Price £4750

Offer Price £4200

Saving £550


Career Package

£4000Saving £750

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
MCSE SQL Server 2012 - £3000 +
MCSE Server 2012 - £1750

Total Price £4750

Offer Price £4000

Saving £750

Specialised Package

£2700Saving £300

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
MCSE Server 2012 - £1750

Total Price £3000

Offer Price £2700

Saving £300

Trustpilot Training Square Review

The following reviews were taken at the end of the course and are 100% verifiable


Tutor takes his time to explain and uses various examples to clarify a point.



Recommend friends and families? Yes

Consider future courses with us? Yes


Tutor has extensive knowledge of the subject and was very helpful



Recommend friends and families? Yes

Consider future courses with us? Yes


Tutor was very good at explaining concepts and applying real world examples…



Recommend friends and families? Yes

Consider future courses with us? Yes


Tutor was very knowledgeable and answered all questions



Recommend friends and families? Yes

Consider future courses with us? Yes


Tutor was very helpful and professional.



Recommend friends and families? Yes

Consider future courses with us? Yes

Recently Trained Customers

"Your success is our goal"