MCSA SQL Server 2012/2014

Speak to us about 0% finance.

MCSA SQL Server 2012/2014

Course Information

MCSA SQL Server 2012/2014

Course Details

Certification: MCSA SQL Server
Vendor: Microsoft
Course prerequisite: There are no prerequisites for studying the SQL Server 2012 R2 course.
Study time: 20-30 hours per course
Practical learning: Practice labs are available for the MCSA: SQL Server 2012/2014 courses.

Certification Details

For the MCSA: SQL Server 2012 R2 certification, you will need to write two mandatory exams and a third exam of your own choosing from the list of electives provided.

Mandatory exam courses:

70-461: Querying Microsoft SQL Server
70-462: Administering Microsoft SQL Server Databases

Choose one elective exam course:

70-411: Administering Windows Server 2012
70-412: Configuring Advanced Windows Server 2012 Services
70-463: Implementing a Data Warehouse with Microsoft SQL Server

To earn your MCSA: SQL Server 2012 R2 qualification, you will need to pass three Microsoft exams in total – the two mandatory and one elective. This is an internationally recognised certification awarded by Microsoft.

Career Path Opportunities

SQL Server Administrator
Database Developer
Database Administrator
Database Analyst
Data Storage Engineer
Data Warehouse Developer
SQL Server Developer
C# Programmer
Software Developer
Systems Administrator

What's Included

  • Mandatory: Querying Microsoft SQL Server 2012 Course (70-461)
  • Mandatory: Administering SQL Server 2012 Databases Course (70-462)
  • Elective: Implementing a Data Warehouse with SQL Server 2012 Course (70-463)
  • Elective: Administering Windows Server 2012 Course (70-411)
  • Elective: Configuring Advanced Windows Server 2012 Services Course (70-412)
  • 12 months unlimited access
  • Student mentor
  • Student care team
  • Career support

Why Learn With Us

Let us help you become the best you can be.

Career Support

Students receive access to our recruitment resource pack which includes our CV review guide, enabling you to showcase your new skills.

Learn more

Student Support

Our dedicated student support team is only a phone call or email away, to answer your questions and help you prepare for exams.

Learn more

Flexible Finance

Our 0% interest finance plans are fully flexible and range from 6 to 12 months, allowing you to enrol on your course with complete peace of mind.

Learn more

Partnered with Leaders

We partner with the world’s leading course providers to make sure you have high-quality learning materials that will accelerate your learning.

Learn more

Expert Team

Our team undergo daily training for the latest updates and demands in the industry, to help find you the perfect role to begin your career.

Learn more

Get This Qualification On Your CV

Transform your career today

Validate your technical expertise with industry recognised certifications from the world's biggest software maker, Microsoft

Course Curriculum

MCSA SQL Server 2012/2014

Exam 70-461: Querying Microsoft SQL Server 2012
  1. Getting Started with SQL Server 2012 
  2. Working with T-SQL 
  3. Writing SELECT Queries 
  4. Working with SQL Data Types 
  5. Sorting and Filtering Data 
  6. Querying Data from Multiple Tables 
  7. Modifying Data 
  8. Working with SQL Server Built-in Functions 
  9. Programming in T-SQL 
  10. Implementing Stored Procedures 
  11. Working with Subqueries and Table Expressions 
  12. Working with Set Operators, Conditional Operators and Window Functions 
  13. Working with PIVOT, UNPIVOT and Grouping Sets 
  14. Managing Error Handling and Transactions 
  15. Querying SQL Server System 
  16. Optimizing Query Performance 
Exam 70-462: Administering SQL Server 2012 Databases
  1. Identifying the SQL Server Platform 
  2. Deploying SQL Server 
  3. Configuring SQL Server 
  4. Managing Databases in SQL Server 2012 
  5. Managing SQL Server Security 
  6. Implementing Advanced Security Settings 
  7. Applying Encryption and Compression 
  8. Working with Indexes and Log Files 
  9. Working with Backup and Restore 
  10. Implementing High Availability 
  11. Optimizing Server Performance 
  12. Troubleshooting Issues and Recovering Databases 
  13. Performing Advanced Database Management Tasks
Exam 70-463: Implementing a Data Warehouse with SQL Server 2012
  1. Introduction to Data Warehouse 
  2. Creating Dimensions and Changing Granularity of Dimensions 
  3. Creating Fact Tables and Column Store Indexes 
  4. Implementing Data Warehouse in SQL Server 2012 
  5. Working with Integration Services 
  6. Managing Control Flow 
  7. Working with Dynamic Variables 
  8. Implementing Data Flow 
  9. Managing Data Flow 
  10. Managing SSIS Package Execution 
  11. Debugging and Troubleshooting 
  12. Deploying Packages 
  13. Securing Packages and Databases 
  14. Working with MDS and Windows

Why Get Qualified?

Gain new skills and knowledge

Thinking ahead and learning the skills needed to move forward in your current career path will mean you are more likely to be considered for future roles.

Gain credibility early in your career

A certification from IT Online Learning shows prospective employees that you have the right skills and credentials needed to succeed in your career.

Increase your opportunity for promotion

Gaining the right set of qualifications will increase your chances of moving into a supervisory or management role, giving you the opportunity to increase your salary.

Average Salary Projection

Source: Adzuna
Average Salary
Database Developer
Average Salary
You Can Earn
Average Salary
C# Programmer

Salary Projection

Average Salary

Database Administrator


You can earn an average of £38k a year

Enquire About MCSA SQL Server 2012/2014

  • This field is for validation purposes and should be left unchanged.

Learn more about how we use your data.