MSFT 116 - Microsoft SQL Design and Implementation

Course Description
This SQL design and implementation course is designed to develop your skills in developing databases using Microsoft SQL Server. With an introduction to SQL Server and SQL Server data types, you will proceed to learn how to: design tables and ensure data integrity, plan and work with indexes, work with and improve SQL Server query execution plans, develop views and work with stored procedures, merge data and work with functions, use transactions and locks, handle errors, use triggers and implement SQL CLR integration, work with XML and use Fulltext indexing by working with SQL Server spatial data types.

0 Credits:

Prerequisite(s):

MSFT 115

© 2015-2018, Southern Alberta Institute of Technology (SAIT). All Rights Reserved.
Domestic Fee
995
International Fee
995
Registration Statement
To view course dates and times choose the Non-Credit 2019-2020 term.