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.

To be awarded the qualification, 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 Management and Analytics

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