SQL Server 2016 Indexes and Views


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
2.1

Lesson Objectives

SQL Server 2016 Indexes and Views

  • 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
  • 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
  • create an index with included columns

    • Course Number:
    df_sqld_a02_it_enus

    Expertise Level
    Expert