SQL Server 2012

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.

Overview

Upon completion of the program, you will be given vouchers to take three Microsoft™ certifying exams.

What Will I Learn?

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.

Possible Careers Include:

  • Database Administrator
  • Business Intelligence Analyst
  • Computer Systems Analyst
  • Database Architect

Learn More


Database Administrators - Employment & Education

Growth in this occupation will be driven by the increased data needs of companies in all sectors of the economy. Database administrators will be needed to organize and present data in a way that makes it easy for analysts and other stakeholders to understand.

Job Stats
Job Outlook: 11% (Faster than average)
Number of jobs, 2016: 119,500
Median pay (May 2017): $87,020 per year
Source: November 13, 2018