MCSA: SQL Server 2012

Course Description

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification shows that you have the primary set of SQL Server 2012 skills.

Earning an MCSA: SQL Server 2012 certification will qualify you for a position as a database developer or database analyst.

The MCSA: Windows Server 2012 qualification is a prerequisite for two MCSE designations, as follows:
MCSE: Data Platform
MCSE: Business Intelligence

To be awarded the MCSA: SQL Server 2012 designation, students must pass a total of 3 individual Microsoft examinations.

Course Content

Querying Microsoft SQL Server 2012 – (Test 70-461)
Create database objects; Work with data; Modify data; Troubleshoot and optimise databases.

Administering Microsoft SQL Server 2012 Databases
– (Test 70-462)
Install and configure SQL databases; Maintain instances and databases; Optimise and troubleshoot databases; Manage data; Implement security; Implement high availability.

Implementing a Data Warehouse with Microsoft SQL Server 2012 – (Test 70-463)
Design and implement a data warehouse; Extract and transform data; Load data; Configure and deploy SSIS solutions; Build data quality solutions.

pdf Printable course details

Prerequisites

CompTIA A+ or equivalent knowledge.

Course Duration

300 hours

Study Methods Available

Individual Tuition
Please contact us.

Follow-on Courses

MCSE: Data Platform
MCSE: Business Intelligence

All Courses

Click here to see all our courses.

Further Information

Enquiry Form
OCR
  Cisco

Sage

CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo