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 Database Performance Settings
Likes 42 Likes 42  
COURSE Data Types & Normalization
Likes 67 Likes 67  
COURSE Querying & Manipulating Data
Likes 112 Likes 112  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Becoming an Accountable Professional
Likes 1151 Likes 1151  
COURSE Columnstore Indexes
Likes 25 Likes 25  
COURSE SQL 2016 Tables
Likes 405 Likes 405