MCSA: SQL Server 2012 + Exams

Microsoft SQL Server 2012 is the cutting-edge Microsoft database server offering in the IT world. The MCSA SQL 2012 certification displays the IT professional has a deep understanding of installing and configuring the Microsoft SQL Server 2012 product. We offer high quality, low cost MCSA SQL Server 2012 training in Sydney and Melbourne.

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification proves the certification holder possesses main SQL Server 2012 skills across diverse areas.

1. Course 20461 (Exam Microsoft 70-461)

           In this course, you will learn about Querying Microsoft SQL Server 2012.

           Course Outline:

• 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

• Query data by using SELECT statements

• Implement sub-queries

• Implement data types

• Implement aggregate queries

• Query and manage XML data

• Create and alter stored procedures (simple statements)

• Modify data by using INSERT, UPDATE and DELETE statements

• Combine datasets

• Work with functions

• Optimise queries

• Manage transactions

• Evaluate the use of row-based operations vs. set-based operations

• Implement error handling

2. Course 20462 (Exam Microsoft 70-462)

           In this course, you will learn about Administering Microsoft SQL Server Databases.

           Course Outline:

• Plan installation

• Install SQL Server and related services

• Implement a migration strategy

• Configure additional SQL Server components

• Manage SQL Server Agent

• Manage and configure databases

• Configure SQL Server instances

• Implement an SQL Server clustered instance

• Manage SQL Server instances

• Identify and resolve concurrency problems

• Collect and analyse troubleshooting data

• Audit SQL Server instances

• Configure and maintain a backup strategy

• Restore databases

3. Course 20463 (Exam Microsoft 70-463)

In this course, you will learn about Implementing a Data warehouse with Microsoft SQL Server.

          Course Outline:

• Implement and maintain indexes

• Import and export data

• Manage logins and server roles

• Manage database permissions

• Manage users and database roles

• Troubleshoot security

• Implement AlwaysOn

• Implement database mirroring

• Design and implement dimensions

• Design and implement fact tables

• Define connection managers

• Design data flow

• Implement data flow

• Manage SSIS package execution

• Implement script tasks in SSIS

• Design control flow

• Implement package logic by using SSIS variables and parameters

• Implement control flow

• Implement data load options

• Implement script components in SSIS

• Troubleshoot data integration issues

• Install and maintain SSIS components

• Implement auditing, logging and event handling

• Deploy SSIS solutions

• Configure SSIS security settings

• Install and maintain data quality services

• Implement master data management solutions

• Create a data quality project to clean data