Course Description
SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. This course covers how to design and implement the various index types available in SQL Server 2016. In addition, this course covers enhancing usability in SQL Server 2016 by using views. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Learning Objectives
Index Design Guidelines
- start the course
- recognize the basic guidelines to follow when designing and implementing indexes
- describe when to use tables without clustered indexes
- recognize the basic guidelines to follow when designing and implementing indexes
- create clustered indexes
- create nonclustered indexes
- create unique indexes
- create filtered indexes
- create indexes with included columns
- delete indexes
- modify indexes
Designing and Implementing Views
- describe the use of views
- recognize how to design and implement views
- describe the various types of views
- create views
- create an indexed view
- modify views
- modify data using a view
- create partitioned views
- rename and delete a view
Practice: Creating Indexes
- create an index with included columns