MCSA SQL Server 2012 Solutions Associate

COURSE OVERVIEW

Gain skills as a database manager

Earn an MCSA level certification that validates your expertise with SQL Server 2012 and enjoy a lucrative and challenging career.

On-Demand, Bootcamp or Virtual Classroom options

Access online course content, videos, exercises, discussions and chats

Pre and post course assessments

Virtual labs for hands-on experience

Live lab add-ons available

Develop real-life skills you can apply in the workplace with Live Labs

Access to over 25,000 e-books and 30,000 downloadable video tutorials

Expert mentoring and coaching to answer questions and guide your learning

Course completion certificates

Microsoft Career Guide

*
*
*
*
*
 

1

GREAT OPPORTUNITY

Manage your organization’s data and reap the rewards of a gainful and rewarding role as a database manager.

2

LEARN IN-DEMAND SKILLS

There’s a huge demand for those who can manage, store and protect data. Earn the MCSA SQL Server 2012 certification and meet the industry demand.

3

GLOBALLY RECOGNIZED

Microsoft certifications are globally renowned qualifications that provide endless opportunities for database managers.

Course guide

Qualification: MCSA SQL Server 2012 Solutions Associate

Study time: Full time – four days | Part time – 30 hours

Vendor: Microsoft

Student support: Personal Success Advisor and Expert Mentors

Prerequisites: For developers with two+ years experience and good working knowledge of relational databases

Assessment: Exam based – MCSA 70-461, 70-462 + 70-463

Resources: Internet access and email

Ideal for: Database developer, database analyst ETL and data warehouse developers who create business intelligence solutions

Modules

70-461: Querying Microsoft SQL Server 2012
  • Create and alter tables using T-SQL syntax-  simple statements
  • Create tables without using the built in tools ALTER, DROP, ALTER, COLUMN and CREATE
  • Create and alter views
  • Create indexed views
  • Create views without using the built in tools CREATE, ALTER and DROP
  • Query data by using SELECT statements
  • Implement subqueries
  • Identify problematic elements in query plans
  • Pivot and unpivot
  • Apply operator
  • Cte statement with statement
  • Implement data types
  • Query and manage XML data
  • Create and alter stored procedures
  • Modify data by using INSERT, UPDATE, and DELETE statements
  • Given a set of code with defaults, constraints, and triggers, determine the output of a set of DDL
  • Know which SQL statements are best to solve common requirements
  • Use output statement
  • Optimise queries
  • Understand statistics
  • Read query plans
  • Plan guides
  • DMVs hints
  • Statistics IO
  • Dynamic vs. parameterised queries
  • Describe the different join types – HASH, MERGE, LOOP – and describe the scenarios they would be used in managing transactions

70-462: Administering Microsoft SQL Server 2012 Databases

  • Plan installation
  • Evaluate installation requirements
  • Design the installation of SQL server and its components
  • Install SQL server and related services
  • Test connectivity
  • Enable and disable features
  • Install SQL server database engine and SSIS
  • Configure an OS disk
  • Configure additional SQL server components
  • Manage SQL server agent
  • Manage and configure databases
  • Configure SQL server instances
  • Implement a SQL server clustered instance
  • Identify and resolve concurrency problems
  • Audit SQL server instances
  • Implement a security strategy for auditing and controlling the instance
  • Manage different backup models
  • Restore a database secured with TDE
  • Recover data from a damaged DB
  • Restore to a point in time
  • File group restore
  • Page level restore import and export data
  • Transfer data
  • Manage logins and server roles
  • Configure database security
  • Manage users and database roles
  • Implement always
  • Set up mirroring and monitor the performance of database mirroring
  • Troubleshoot replication problem and identify appropriate replication strategy

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

  • Design and implement dimensions
  • Design and implement fact tables
  • Design a data warehouse that supports many to many relationships
  • Define connection managers
  • Plan the configuration of connection managers
  • Package level or project level connection manager
  • Define a connection string and parametisation of connection strings
  • Design and implement data flow
  • Manage SSIS package execution
  • Implement package logic by using SSIS variables and parameters
  • Implement control flow
  • Implement script components in SSIS
  • Troubleshoot data integration issues
  • Install and maintain SSIS components
  • Configure SSIS security settings
  • Install and maintain data quality services
  • Installation prerequisites

Get certified the Learning People way

Professional development that works around you

  • World’s #1 eLearning portal
  • 12 months unlimited access
  • Hands on interactive Practice Labs
  • Expert mentors
  • Test preps
  • Global community of peers
  • Content approved by Microsoft

AVERAGE SALARY

2013
2014
2015
2016
JAN
JUL
JAN
JUL
JAN
JUL
JAN