SQL Server 2016 Indexes and Views

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