India

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

Learn to install, configure, and manage SQL Server 2012 with hands-on labs that give step-by-step instructions
Temecula, CA P.O. Box 760,, Temecula, CA 92593
(951) 9723600

Course at a Glance

Mode of learning : Online - Instructor Lead(LVC)

Domain / Subject : Engineering & Technology

Function : Information Technology(IT)

Trainer name : Vincent DiFillipo

Duration : 360 Hours

Difficulty : Medium

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 program enables you to take your professional database career to a new level. This program validates the primary set of SQL Server 2012 skills, relevant across multiple solution areas in business environments. You will prepare to manage a database environment as a database developer and as a database analyst.

With the MCSA: SQL Server 2012 certification, you can deliver more business value to your organization. This program prepares you for the standards set forth by Microsoft for earning the MCSA: SQL Server 2012 Certification and prepares you to take the Microsoft 70-461, 70-462, and 70-463 certification exams. Upon passing all three exams, you will receive the MCSA: SQL Server 2012 Certification.

In this program, you will learn to install, configure, and manage SQL Server 2012 with hands-on labs that give step-by-step instructions. The applied learning labs prepare you to walk into an interview with marketable skills.

Objectives

Upon completion of this program, you will be able to do the following:

  • Create Database Objects
  • Maintain instances and databases
  • Install, Configure, Optimize, and troubleshoot
  • Manage, modify, extract, and load data
  • Implement security and high availability
  • Design and implement a data warehouse
  • Configure and deploy SSIS solutions
  • Build data quality solutions

You’ll also be prepared to take the following Microsoft exams:

  • 70-461: Querying Microsoft SQL Server 2012
  • 70-462: Administering Microsoft SQL Server 2012 Databases
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Requirements

This program can be taken on a Mac or a PC. On a PC, it is compatible with Windows XP and later operating systems and IE 7 and later browsers.

On a Mac, the program is compatible with Mac OS X 10.6 and later operating systems, Firefox, Chrome, and Safari 5.1.9 or later browsers.

We highly recommend that you use Chrome and Firefox in place of other web browsers. Adobe Flash Player and Adobe Acrobat Reader are required for this program.

To complete the labs, you must install and configure VirtualBox (instructions provided in program):

  • VirtualBox runs on most 32-bit or 64-bit operating systems
  • 6 GB of RAM is recommended, 4 is the minimum        
  • 10 GB of Hard Drive space is recommended

Upon registering, you will receive the following materials:

  • Querying Microsoft SQL Server 2012 (70-461 Training Kit)
  • Administering Microsoft SQL Server 2012 Databases (70-462 Training Kit)
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463 Training Kit)

Prerequisites

Students should have a basic understanding of how to use a computer, in addition to basic networking skills. These skills can be learned in programs such as CompTIA A+ and Network+.

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace.

Course Content

  • Querying Microsoft SQL Server 2012 Intro
    • T-SQL and Stored Procedures
    • Select, Data Types, Subqueries, Data Sets, and Aggregates
    • XML Data, Tables and Views
    • Modify Data, Stored Procedures, Triggers and Functions
    • Optimization
  • Administering Microsoft SQL Server 2012 Databases
    • Install and Configure SQL Server 2012
    • Maintain Instances and Databases
    • Optimize and Troubleshoot
    • Manage Data
    • Implement Security
    • Implement High Availability
  • Implementing a Data Warehouse with Microsoft SQL Server 2012
    • Dimensions and Fact Tables
    • Data Flow, Variables and Parameters, Package Logic
    • Logging and SSIS
    • Troubleshooting, Debugging and Data Quality
    • Scripting and Master Data Services
    • Fuzzy Transformations

Photos

Write Your Own Review


Write your review here (required)


Consider:
Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?


Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at