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.
Download Course Outline View Schedule/Book OnlineWho 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
Reviews
There are no reviews yet.