Designing & Implementing Views

SQL Server 2016    |    Intermediate
  • 9 Videos | 55m 48s
  • Includes Assessment
  • Earns a Badge
Likes 40 Likes 40
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 Index Design Guidelines
Likes 33 Likes 33  
COURSE Columnstore Indexes
Likes 25 Likes 25  
COURSE Querying & Manipulating Data
Likes 61 Likes 61  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Azure SQL Database
Likes 78 Likes 78  
COURSE Columnstore Indexes
Likes 25 Likes 25  
COURSE SQL 2016 Tables
Likes 166 Likes 166