Overview

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Duration

5 Days

Target Audience

The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.

Topics

Introduction to Database Development

Designing and Implementing Tables

Advanced Table Designs

Ensuring Data Integrity through Constraints

Introduction to Indexes

Designing Optimized Index Strategies

Columnstore Indexes

Designing and Implementing Views

Designing and Implementing Stored Procedures

Designing and Implementing User-Defined Functions

Responding to Data Manipulation via Triggers

Using In-Memory Tables

Implementing Managed Code in SQL Server

Storing and Querying XML Data in SQL Server

Storing and Querying Spatial Data in SQL Server

Storing and Querying BLOBs and Text Documents in SQL Server

SQL Server Concurrency

Performance and Monitoring

A more comprehensive course outline is available in the Course Download section, to the right of this page.