1Course Overview

MCSE Data Platform SQL 2012

Course code: LE002

Pay up front:


Save £100 by
paying up front

Free UK delivery

Additional Discounts Available on selected courses until 28th May

  • Days
  • Hours
  • Mins
  • Secs
Enhance your CV with an accredited IT qualification. 

Looking to excel within the IT sector?

This course is ideal for those looking to add to their skill set a knowledge of Microsoft and computer systems.  

  • Develop your skills within a broad range of computing disciplines from designing and implementing a Data Warehouse with Microsoft SQL to designing database solutions for Microsoft SQL.
  • Qualify for a host of jobs such as database analyst and database designer in the comfort of your own home.

With no strict deadlines or timetabling, you can fit this course around your busy lifestyle. Home learning is simple and stress-free! Enrol today and join the 75,000 students who have improved their career prospects by studying with us.

Discounts on selected courses - Until 28th May
2Course Content

Course Content

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 
  • Introduction to SQL Server 2012
  • T-SQL Overview 
  • SELECT Statements
  • Filtering
  • Join and Set Operators 
  • Subqueries and Table Expressions
  • Systems Functions 
  • T-SQL Programming
  • Transactions 
  • Query Performance
Microsoft 70-462: Administering SQL Server 2012 Databases
  • Introduction to SQL Server 2012
  • Installing SQL Server
  • Backup and Restore a Database
  • Tracing Access to SQL Server/li>
  • Importing and Exporting Data
  • SQL Server Security
  • Automating SQL Server
  • Monitoring SQL Server
  • Maintaining SQL Server
  • Troubleshooting SQL Server
Microsoft Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Introduction to Data Warehousing
  • Designing a Data Warehouse
  • ETL with SSIS
  • SSIS Control Flow
  • Troubleshooting Packages
  • Advanced Packages
  • Data Quality Services
  • Master Data Services
  • Deployment and Security
Microsoft Exam 70-464 - Developing Microsoft SQL Server 2012
  • Introduction to SQL Server 2012
  • Introduction to Data Types and Tables
  • SQL Server Indexing
  • Query Performance
  • Common Language Runtime (CLR) Integration
  • Transact - SQL (T-SQL) Error Handling
  • Views and Functions
  • Stored Procedures and Triggers/li>
  • Working with XML
  • Transactions
Microsoft Exam 70-465 - Designing Database Solutions for Microsoft SQL Server 2012
  • Course Introduction
  • Introduction to Databases 
  • Introduction to Data Types and Tables 
  • SQL Server Indexing 
  • Performance Considerations 
  • Backup and Restore 
  • Views and Functions 
  • Stored Procedures and Triggers 
  • SQL Server Security 
  • Installing and Upgrading SQL


3Other Information

Course Duration

With this flexible home learning course you can fast-forward, rewind or repeat all the online classes so you can go at your own pace with no strict deadlines. Two weeks or twelve months, it's completely up to you. 

Study Method

This blended learning solution offers a highly interactive and engaging learning environment with video demonstrations, multimedia presentations and educational games to assist with your study. Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students. 

Course Outcomes

Upon successful completion of each of the courses in this bundle, you will receive a Learn365 Certification of completion. 

Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these. 


Your Questions Answered

What skills do I need to enrol onto this course?

No previous knowledge is required to enrol onto this course, just a basic knowledge of IT. 

Are there any additional costs?

No. Everything you need is included in the price!

What if I still have questions?

That’s not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Support Team a call on 03300 563 100 and they’ll do their best to help.

Finance options

Provided by
Length Of Your Repayment
Your Deposit
Monthly payment:

Deposit to pay:

  • Cash Price:
  • Loan Amount:
  • Loan Repayments:
  • Cost of Loan:
  • Number of Monthly Payments:
  • Total Amount Payable:

The total course fee includes a loan arrangement fee. Your initial deposit payment will be used towards this fee, any remaining fee balance will be added the loan amount.

Provided by

Our finance option is provided in partnership with AffordItNow.
For your finance application to be considered you must meet the following criteria:

  • Be over 18 years old
  • Be employed for at least 16 hours a week or retired and in receipt of a private or company pension. Certain state benefit schemes may also be considered.
  • Be a permanent UK resident with a 3 year address history
  • Have a good credit history with no late payments, debt relief orders or bankruptcies
  • Have a valid email address and can access it

Please note that meeting the above criteria does not guarantee finance acceptance.

Open Study College, 6140 Knights Court, Birmingham Business Park, Birmingham B37 7WY is a licensed credit broker, authorised and regulated by The Financial Conduct Authority (licence number 724179 with FCA).