Developing Microsoft SQL Server 2016 Database

Overview

This five-day instructor-led course provides participants with the knowledge and skills to develop a Microsoft SQL Server 2016 database.

The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Who Should Attend

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database. The secondary audience for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

Course Objectives

After completing this course, participants will be able to:

• Design & Implement Tables
• Describe advanced table designs
• Ensure Data Integrity through Constraints
• Describe indexes, including Optimized & Columnstore indexes
• Design & Implement Views
• Design & Implement Stored Procedures
• Design & Implement User Defined Functions
• Respond to data manipulation using trigger
• Design & Implement In-Memory Tables
• Implement Managed Code in SQL Server
• Store & Query XML Data
• Work with Spatial Data
• Store & Query Blobs & Text Documents

Course Prerequisites

Before attending this course, participants must have, in addition to their professional experience:

• A working knowledge of relational databases
• A working knowledge of Transact-SQL
• Basic knowledge of the Microsoft Windows operating system and its core functionality