MCSA SQL Server Certification

COURSE OVERVIEW

Gain skills as a database manager with a MCSA SQL Server certification

Earn an MCSA SQL Server certification that validates your expertise with SQL Server 2012/2014 and enjoy a lucrative and challenging career as a database developer or database analyst. The demand for qualified database professionals has never been higher and those who train for success are reaping the rewards. Achieve this associate-level certification and begin a brand-new career in database administration.

Achieving an MCSA: SQL Server certification requires the successful completion of the following exams: 70-461: Querying Microsoft SQL Server, 70-462: Administering Microsoft SQL Server Databases and 70-463: Implementing a Data Warehouse with Microsoft SQL Server.

On-Demand, Bootcamp or Virtual Classroom MCSA SQL Server certification options

Access MCSA: SQL Server course content, videos, exercises, discussions and chats

Pre and post course assessments

Virtual labs for hands-on MCSA SQL Server 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

MCSA SQL Server 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 Certification 2012 Solutions Associate

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

Vendor: Microsoft

Student support: Success Advisors

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 KnowledgeNet 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
2017
JAN
JUL
JAN
JUL
JAN
JUL
JAN
JUL
JAN
DON'T MISS OUT
Ask about our monthly promotions. Save big on training and certifications to sharpen your skills!
First Name * Last Name *
* *
close-link