MCSE: SQL Server 2012 Data Platform

Training Square London
Course summary
Professional Training
6 Weeks or Fast Track 6 Days
3,000 GBP

Course description

MCSE: SQL Server 2012 Data Platform - Training Square London

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.

Suitability - Who should attend?

This course is suitable for professionals of all levels - beginning, intermediate and advanced.

Training Course Content

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

  • Microsoft SQL Server 2012 and Tools
  • SQL Azure
  • T-SQL Querying
  • SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In Functions, Grouping and Aggregating Data
  • Using Subqueries and Table Expressions
  • Using Set Operators
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Transactions
  • Improving Query Performance

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

  • MS SQL Server 2012 and its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Database, Datafiles and SQL Server 2012 Recovery Models.
  • Backup of SQL Server 2012 Databases
  • Restoring SQL Server 2012 Databases
  • Importing and Exporting Data
  • Authenticaton and Authorizing Users
  • Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers

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

  • MS SQL 2012 Data Warehousing
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS and SSIS Package
  • Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Cloud Data into a Data Warehouse
  • Enforcing Data Quality and Deduplicating Data
  • Using Master Data Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Developing Microsoft SQL Server 2012 Databases 70-464

  • Designing and Implementing Tables
  • SQL Server 2012 Indexing
  • Implementing Table Structures in SQL Server 2012
  • Designing Effective Nonclustered Indexes
  • Designing and Implementing Views, Stored Procedures
  • User-Defined Functions
  • Creating Highly Concurrent SQL Server 2012 Applications
  • Responding to Data Manipulation via Triggers
  • Implementing Managed Code in SQL Server 2012
  • Querying XML Data in SQL Server
  • Working with Full-Text Indexes and Queries

Designing Database Solutions for SQL Server 2012 70-465

  • Designing a Database Server Infrastructure
  • Designing a Database Solution for BLOB Data
  • Tuning Database Performance
  • Designing Database Security
  • Monitoring Server Health
  • Managing SQL Server with PowerShell
  • Replicating Data


The cost of this course is £3000 per person. Contact the provider to learn more about costs and payment options.

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Training Square London

Training Square London

The internet indeed has changed the world, and we believe every one of us should be fully equipped to be a part of, and lead, that change. Being prepared and ready is half the battle won, and Training Square makes...

Read more and show all courses with this provider

Contact info

Training Square London

 Show phone number


Average rating 5

Based on 1 reviews.

Tutor was very knowledgeable and answered all questions.
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here