Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 - Online

ID : 13198   
« back to classes page
As businesses continue to rally for data-driven decision making, employees with database knowledge are in high demand. This program will prepare you for database administration and development, learning the standards set forth to manage SQL Server 2012.As you work towards preparing for your MCSA: SQL Server 2012, you will learn how to create database objects, constraints, and alter DML triggers. You’ll learn to query and modify data, as well as how to work with functions. To further your expertise, you will also explore troubleshooting and optimizing SQL Server 2012 and the steps to install, manage, and maintain SQL servers.This program will round out your knowledge by teaching design and implementation of a data warehouse and deployment of SSIS solutions. To gain further understanding, you will learn to install, configure, and manage SQL Server 2012 with virtual, hands-on labs that give step-by-step instructions. Upon completion of the program, you will be given vouchers to take three Microsoft™ certifying exams; MCSA certification exams 70-461, 70 -462, and 70-463, which qualify you for the MCSA: SQL Server 2012 Certification.

 

Prerequisite: 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+. 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. Mac users must have BootCamp working with a compatible Windows OS, or another method to simulate a Windows OS for the duration of their enrollment. 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

Learning Objectives:

  • Instal SQL Management Studio and Database.

  • Query, filter, sort, and combine data and datasets.

  • Create tables and table constraints.

  • Utilize XML and T-SQL.

  • Create, modify, and alter data.

  • Understand advanced optimization and full-text.

  • Administer Microsoft SQL Server 2012 Databases.

  • Identify, troubleshoot, and resolve concurrent problems.

  • Configure and maintain a backup strategy to manage data.

  • Implement a Data Warehouse with Microsoft SQL Server 2012.

Materials included: • 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)

View the course syllabus

For our online course refund policy, click here.

You will receive a password and log-in information via email within 3-5 business days of registering for this course. Course materials are included and will be mailed to you within 10 business days. You have 12 months to complete this course. You must make a 70 or higher as your final grade to successfully complete the course and receive a certificate of completion. There are no refunds for this course.

If you have questions about this course, please contact the online coordinator at 470-578-3355 or online@kennesaw.edu.

Class Details

90 Sessions
Weekly - Sun, Mon, Tue, Wed, Thu, Fri, Sat

Location
ccpe.kennesaw.edu/online

Instructor
Online Instructor 

CEUs : 36

Fee: 

$2,395.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
1/1/2017 - 3/31/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor