MCSE Data Platform SQL 2012

Course code: LE002
Selected Discounted Courses
The offer has expired
Days Hours Minutes Seconds

Enhance your CV with by learning a broad range of computing disciplines.

  • Develop knowledge of Microsoft and computer systems.
  • Learn how to design and implement a Data Warehouse with Microsoft SQL.
  • Learn how to design database solutions for Microsoft SQL.
  • Qualify for a host of jobs such as database analyst and database designer.

Course overview

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.

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 90,000 students who have improved their career prospects by studying with us.

This course is only available to study online.
Course Overview

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

You will receive a certificate of completion in MCSE Data Platform SQL 2012.

Entry Requirements

There are no specific entry requirements for this course.

Assessment

Exam simulations after each module.

Course Content
  • 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
  • Introduction to SQL Server 2012
  • Installing SQL Server
  • Backup and Restore a Database
  • Tracing Access to SQL Server
  • Importing and Exporting Data
  • SQL Server Security
  • Automating SQL Server
  • Monitoring SQL Server
  • Maintaining SQL Server
  • Troubleshooting SQL Server
  • 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
  • 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
  • Working with XML
  • Transactions
  • 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
Extra Info

Assessment

Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. 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.

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. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students.

Course Outcome

Upon successful completion of each of the courses in this bundle, you will receive a certification of completion so you can showcase your achievement to future employers. 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.

Awarding body

Microsoft has certification paths for many technical job roles. Each of these certifications consists of passing a series of exams to earn certification.

Q&As

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

To receive the full certification from Microsoft you will need to sit an exam, at the cost of around £100 at a Pearson Vue centre.

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 Adviser Team a call on 03300 563 100 and they’ll do their best to help.

Enrol now

If you are interested in and you’re looking for a more flexible approach to learning that fits around your life - this is the ideal course for you. Enrol online today by clicking below or speak to one of our advisers for more information.

Enrol on this course