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