Designing & Implementing Views

SQL Server 2016
  • 9 Videos | 1h 18s
  • Includes Assessment
  • Earns a Badge
Likes 23 Likes 23
In addition to indexes, SQL Server 2016 uses views to improve the performance of queries and the overall database. Discover how to enhance usability in SQL Server 2016 by using views.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Stored Procedures
Likes 38 Likes 38  
COURSE Monitoring Queries
Likes 28 Likes 28  
COURSE Optimizing Statisitics & Indexes
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Analyzing Query Plans
Likes 18 Likes 18  
COURSE Functions
Likes 16 Likes 16  
COURSE Transactions
Likes 14 Likes 14