Microsoft Certified Solutions Associate SQL Server 2012 - MCSA SQL Server 2012

Enrol today and receive 30% off this course. Hurry, offer ends October 31.

Who is it for?

This course is designed for current or aspiring Database Professionals who perform database installation, configuration and maintenance tasks, write and run queries against SQL Server 2012 databases, and perform data analysis and warehousing.

If you’re looking push your database career to the next level, this globally renowned MCSA certification is the ideal next step.

What jobs will I qualify for?

• Database Developer
• Database Analyst

In these roles, you could earn up to £45,000 per annum (source: reed.co.uk Salary Checker, 2013, UK Only).

When can I start?

You can enrol at any time - start today.

Are there any requirements?

It is recommended that you have a working knowledge of relational databases, ideally from two years’ of experience, in order to get the most from this training.

What skills will I gain?

You'll learn how to:

• Create a Data Warehouse with SQL Server 2012
• Implement ETL (extract, transform, load) with SQL Server Integration Services
• Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Module breakdown

In order to achieve the MCSA SQL Server 2012 certification, you will be required to complete the following three modules of course material and pass the associated exam:

70-461: Querying Microsoft SQL Server 2012 

• Creating Database Objects

• Querying Basics and Modifying Data

• Manipulate Data Using Operators and Functions

• Creating Functions and Triggers

• Creating Programming Objects and Optimising Queries

• Managing XML Data

70-462: Administering Microsoft SQL Server 2012 Databases

• Installation and Upgrade

• Instance Configuration and Database Creation

• Managing Databases and Automating Tasks

• Security Management

• Managing Database Data

• Managing Indexes, Full-Text Search and Partitions 

• Backing Up and Restoring Databases

• Database Monitoring and Performance Tuning

• Configuring High Availability

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

Please note: This module is still under development by SkillSoft and is due to be released in August 2013. If you purchase the full MCSA SQL Server 2012 course, your course material will be automatically updated when this module becomes available. Until this time you will have complete access to the first two modules of this course. 

What support is available?

• Your training takes place through easy-to-navigate video, audio and interactive tutorials
• At the end of each section you will have the opportunity to sit multiple-choice practice tests to check how you are getting on
• LiveChat Mentors, and our Student Support team, will be available to help you along the way

How will I be assessed?

In order to complete this certification you will be required to pass three exams: 70-461, 70-462 and 70-463(to be released). These will require booking and purchasing separately.

Testimonial

Don't take our word for it, hear what students have to say about our service:

'The conversation I had with reed.co.uk's Course Adviser could not have been more helpful, or tailored to me as an individual. I never felt rushed, and everything I wanted to know and more, was answered. They were supportive, genuine and friendly, and I would recommend reed.co.uk as a whole to anyone looking for work, a different job or simply enhancing their CV with a course.'

Steven G. Paterson

What should I do next? For a free consultation call a Microsoft specialist Course Adviser on 0207 980 2842 or enquire online today to request a call back.