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

Includes 100% Pass Guarantee

Walk away with the certification. Included in full-time courses. Click here for more Info

Includes Career Counselling

Career Counselling is an integral part of job hunting, it is included with this course

Includes Trainer & Lab Support

6 month support with full-time courses, 3 month support with part-time courses

Includes Official Exam Fee

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

Includes Mock & Test Questions

Unlimited mock tests in full-time; 1 mock test in part-time to boost your confidence

Includes Books & Meals

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

Includes Course Retake

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

Authorized VUE Test Center

Take the official vendor certification exam at the Logitrain training center

Upgrade Your Course Benefits

Add Pass Guarantee, extra support, retake in part-time course with a full-time fee

Our Price Beat Guarantee

We will beat competitor’s advertised price. Our course has no extra costs

Our Flexible Training Options

Attend classroom courses weekdays, weeknights, weekends or join from anywhere

Delivering Training Since 2004

There is no substitute for experience, we have trained 3000+ students. Train with the best

DATES, LOCATIONS & PRICES

CAN’T MAKE IT TO CLASS? GET CLASSROOM EXPERIENCE THROUGH OUR LIVE ONLINE TRAINING

LocationTypeDurationPriceDates
LocationTypeDurationPriceDates

Accreditations

OUR SATISFIED CUSTOMERS