SQL Server 2016 Indexes and Views

Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisite
None

Expected Duration
125 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.