• CATALOG
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN
University of Houston
Home > Training Programs > Networking > Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
CALL
NOW

855.520.6806

Fill out the form below

Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

mcsa-sql-server-2012
$1,995.00 (USD)

OVERVIEW

OBJECTIVE

DETAILS

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 program will teach you how to create database objects, like tables and design views. It will also teach you how to create and modify constraints, and create and alter DML triggers.

You will learn to query data using select statements, implement sub-queries and data types, aggregate queries, and manage XML data. Modify data by creating and altering stored procedures, using statements like insert, update, and delete, combining datasets, and working with functions. Finally, troubleshoot and optimize SQL Server 2012 by optimizing queries, managing transactions, evaluating row-based operations, and implementing error handling.

Learn the steps involved in installing, managing, monitoring, and maintaining SQL Servers. You will also explore maintenance and management of the SQL server network and application.

Learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions, and build data-quality solutions.

Upon registering, you are given twelve (12) months to complete the program.


OUTLINE

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

University of Houston

102 CN Hilton Hotel - Conference Center
Continuing Education
Houston, TX 77204 US
MAIN CONTENT

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.