MCSA: SQL Server 2012 + Exams

MCSA: SQL Server 2012 Course + Exam

MCSA: SQL Server 2012 Certification

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

  1. 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

 

  1. 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

  • Updated Training: SQL Server 2012
  • More hands-on: trial software included
  • Receive a certificate of course attendance
  • 3 x Certification exams worth $618 included
  • Expert trainers: imparting real world experience
  • Small class size: increased instructor interaction
  • Authorised test centre: exams taken at our premises

Exposure to Microsoft Server technologies

Candidates can achieve this certification by passing following exam(s).

  • Microsoft 70-461
  • Microsoft 70-462
  • Microsoft 70-463

The certification exam if included in your course can be registered and attempted within 3 months of course/module completion at Logitrain training centre on weekdays during normal business hours (excludes public holidays)

  • Querying Microsoft SQL Server 2012
  • Administering Microsoft SQL Server 2012 Databases
  • Implementing a Data Warehouse with Microsoft SQL Server 2012

4-14-24-3

(Logitrain Course material provided)

  • Create database objects
  • Work with data
  • Modify Data
  • Troubleshoot and optimise
  • Install and Configure SQL Server
  • Maintain instances and databases
  • Optimise and troubleshoot
  • Manage data
  • Implement security
  • Implement high availability
  • Design and implement a data warehouse
  • Extract and transform data
  • Load data
  • Configure an deploy SSIS solutions
  • Build data quality solutions
  • Database Developers
  • Database Analysts
  • Database support staff
  • Individuals seeking MCSA certification
  • 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
  • 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
  • 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

Learn More

  • This field is for validation purposes and should be left unchanged.
What is included with the MCSA: SQL Server 2012 Course?

Includes Official Exam Fee

Take the certification exam within 3 months of course / module completion

Authorized Test Center

Take the official vendor certification exam at the Logitrain training center

Includes Books & Meals

Course material in hardcopy included for you to keep. Full-time courses include meals

Includes Mock & Test Questions

Mock tests included in full-time courses for 3 months from course completion

Includes Course Retake

Sit through the entire course again to clear any doubts. Included in full-time courses

Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price. Our course has no extra costs

DATES, LOCATIONS & PRICES

LocationTypeDurationPriceDates
LocationTypeDurationPriceDates

Accreditations

OUR SATISFIED CUSTOMERS