Background Image

Microsoft's professional qualification

MCSA

SQL Server 2012

Would you like us to send you information on this certification and be informed of any future updates and retirements?

Name*

Email*

Phone*

Course Information

Certification summary

The Microsoft Certified Solutions Associate (MCSA) SQL Server 2012 certification is an entry-level SQL Server certification. Demonstrate to potential hiring managers your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments by achieving the MCSA: SQL Server 2012 certification

Exam Information

Exams summary

To get a MCSA: Windows Server 2012 certification there are three exams to complete:

Exam 461: Querying Microsoft SQL Server 2012
Exam 462: Administering Microsoft SQL Server 2012 Databases
Exam 463: Implementing a Data Warehouse with Microsoft SQL Server 2012

A closer look...

MCSA gives you the primary set of Windows Server 2012 skills, relevant across multiple solution areas in a business environment, to reduce IT costs and deliver more business value. Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst and many more.

Career & Job Opportunities

The Microsoft Certified Solutions Associate (MCSA) is a globally recognised qualification across the Finance, Telecoms and Banking industry. As of 2015, the average salary of a Microsoft MCSA Professional is £35,000pa with more than 90% being offered a salary of more than £25,300pa. The average salary for a MCSA graduate is estimated to be £21,300pa. After graduation, you can find work in roles such as Support Engineer and Database Analyst with relative ease. Below is a short list of the starting range of career opportunities offered to MCSA Windows Server 2012:

Free MCSA Windows Server training

Start the MCSA SQL Server 2012 with a trial

We are offering a trial of this course for free with no purchase necessary, just sign up below to instantly receive your login details.

Name

Email

Phone

Comment

jobs for the MCSA Windows Server

We will work with you to ensure that you can find work in IT after completing your Microsoft course

Working with JobcentrePlus and our Recruitment Partners across the UK, we will work with you to ensure that you can find work in IT (an not in any job) through job interviews and applications. We aim to get you in an IT job role on completion of your MCSA. If you have no qualification or background in IT, we will provide you with the necessary training for the experience required. For existing MCSA professionals, we can upgrade your qualifications and improve your career prospects. Do not allow your lack of experience or self-confidence deny you from a career in I.T - it is a lot easier (and enjoyable too) than most people think, once you learn the basics.

  • ↘ Take on a new adventure with the MCSA interactive video demos

    • Promotions. Gain access to the MCSA and Microsoft course library for 10 days.

  • ↘ Contact us about our Microsoft student placement service

    • If your aim is employment/career advancements through IT training, see how you can achieve this together with your tutor.

83.8%

of MCSA Windows Server technicians are being offered a salary of more than £28,000pa in the UK.

The three exams

The MCSA SQL Server 2012 is the latest generation in Microsoft server technology and as such there is no current retirement plan for its exams. Below is a breakdown of the exams for this certification and how they are made up.

More Exam Information

Exam 461

This exam measures your ability to accomplish the technical tasks listed:

- Create database objects.
- Work with data .
- Modify data.
- Troubleshoot and optimize.

X

Exam 461

This exam measures your ability to accomplish the technical tasks listed: Create database objects, Work with data, Modify data, Troubleshoot and optimize . Here are the percentages that make up the final mark for this exam using these technical tasks:

  • Create database objects (24%)
    • Create and alter tables using T-SQL syntax (simple statements)
    • Create and alter views (simple statements)
    • Design views
    • Create and modify constraints (simple statements)
    • Create and alter DML triggers
  • Work with data (27%)
    • Query data by using SELECT statements
    • Implement sub-queries
    • Implement data types
    • Implement aggregate queries
    • Query and manage XML data
  • Modify data (24%)
    • Create and alter stored procedures (simple statements)
    • Modify data by using INSERT, UPDATE, and DELETE statements
    • Combine datasets
    • Work with functions
  • Troubleshoot and optimize (25%)
    • Optimize queries
    • Manage transactions
    • Evaluate the use of row-based operations vs. set-based operations
    • Implement error handling

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

More Exam Information

Exam 462

This exam measures your ability to accomplish the technical tasks listed:

- Install and configure.
- Maintain instances and databases.
- Optimize and troubleshoot.
- Manage data.
- Implement security.
- Implement high availability.

X

Exam 462

This exam measures your ability to accomplish the technical tasks listed: Install and configure, Maintain instances and databases, Optimize and troubleshoot, Manage data, Implement security, Implement high availability. Here are the percentages that make up the final mark for this exam using these technical tasks:

  • Install and configure (19%)
    • Plan installation
    • Install SQL Server and related services
    • Implement a migration strategy
    • Configure additional SQL Server components
    • Manage SQL Server Agent
  • Maintain instances and databases (17%)
    • Manage and configure databases
    • Configure SQL Server instances
    • Implement a SQL Server clustered instance
    • Manage SQL Server instances
  • Optimize and troubleshoot (14%)
    • Identify and resolve concurrency problems
    • Collect and analyse troubleshooting data
    • Audit SQL Server instances
  • Manage data (19%)
    • Configure and maintain a back-up strategy
    • Restore databases
    • Implement and maintain indexes
    • Import and export data
  • Implement security (18%)
    • Manage logins and server roles
    • Manage database permissions
    • Manage users and database roles
    • Troubleshoot security
  • Implement high availability (12%)
    • Implement AlwaysOn
    • Implement database mirroring

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

More Exam Information

Exam 463

This exam measures your ability to accomplish the technical tasks listed:

- Design and implement a data warehouse.
- Extract and transform data.
- Load data.
- Configure and deploy SSIS solutions.
- Build data quality solutions.

X

Exam 463

This exam measures your ability to accomplish the technical tasks listed: Design and implement a data warehouse, Extract and transform data, Load data, Configure and deploy SSIS solutions, Build data quality solutions. Here are the percentages that make up the final mark for this exam using these technical tasks:

  • Design and implement a data warehouse (11%)
    • Design and implement dimensions
    • Design and implement fact tables
  • Extract and transform data (23%)
    • Define connection managers
    • Design data flow
    • Implement data flow
    • Manage SSIS package execution
    • Implement script tasks in SSIS
  • Load data (27%)
    • Design control flow
    • Implement package logic by using SSIS variables and parameters
    • Implement control flow
    • Implement data load options
    • Implement script components in SSIS
  • Configure and deploy SSIS solutions (24%)
    • InstTroubleshoot data integration issues
    • Install and maintain SSIS components
    • Implement auditing, logging, and event handling
    • Deploy SSIS solutions
    • Configure SSIS security settings
  • Build data quality solutions (15%)
    • Install and maintain data quality services
    • Implement master data management solutions
    • Create a data quality project to clean data

Try this course online, login via providing some basic student details below

Name*

Email*

Phone*

This course is suitable for...

Training for a fresh career

School leavers

A fun and enjoyable way to build a fresh career

Training for teachers and IT professionals

Teachers & IT professionals

A prestigious qualification which will distinguish you from the crowd of 21st century geeks

Training for anyone looking to start a new career

Anyone else...

Looking to start a healthy, rewarding & lucrative career in I.T

Is this course right for you?

But is this course right for you?

Will it provide you with the skills that you need, or the career you'd like to explore? If you are not 100% sure that it's correct for you then we highly recommend that you experience our trial courses and assessments to get an accurate insight to the MCSA certification. You can sign up for this below or use it to ask our lecturers some questions. You can also call us on 0800 622 69 69 and speak to one of our course advisers and they will help you choose the perfect certification tailored to your needs.

Name*

Email*

Phone*

More Information

Request more info on the MCSA: SQL Server 2012 course

Exam tips and syllabus

Get the MCSA: SQL Server 2012 exam syllabus aswell as helpful tips

What our students say

See what our students have to say about the MCSA: SQL Server 2012