Course description

Learn to design and develop a Microsoft SQL Server 2016 database.

In this course, you will learn the major tools of the SQL Server 2016 platform, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters and functions. You will also learn procedure coding, such as indexes, triggers, SQL Common Language Runtime (CLR), SQL Server spatial data, and considerations for binary large object (BLOB) data.

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20762: Developing SQL Databases.

Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:

What You'll Learn in Class:

Who Needs to Attend:

Prerequisites:

Follow-On Courses

Course Outline:

1. Introduction to Database Development

2. Designing and Implementing Tables

3. Advanced Table Designs

4. Ensuring Data Integrity through Constraints

5. Introduction to Indexes

6. Designing Optimized Index Strategies

7. Columnstore Indexes

8. Designing and Implementing Views

9. Designing and Implementing Stored Procedures

10. Designing and Implementing User-Defined Functions

11. Responding to Data Manipulation via Triggers

12. Using In-memory Tables

13. Implementing Managed Code in SQL Server

14. Storing and Querying XML Data in SQL Server

15. Working with SQL Server Spatial Data

16. Storing and Querying BLOBs and Text Documents in SQL Server

Labs:

Lab 1: SQL Server Database Development Tasks

Lab 2: Designing and Implementing Tables

Lab 3: Using Advanced Table Designs

Lab 4: Ensuring Data Integrity through Constraints

Lab 5: Implementing Indexes

Lab 6: Designing Optimized Index Strategies

Lab 7: Using Columnstore Indexes

Lab 8: Designing and Implementing Views

Lab 9: Designing and Implementing Stored Procedures

Lab 10: Designing and Implementing User-defined Functions

Lab 11: Responding to Data Manipulation via Triggers

Lab 12: In-memory OLTP

Lab 13: Implementing Managed Code in SQL Server

Lab 14: Storing and Querying XML Data in SQL Server

Lab 15: Working with SQL Server Spatial Data

Lab 16: Storing and Querying BLOBs and Text Documents in SQL Server