Designing & Implementing Views

SQL Server 2016    |    Intermediate
  • 9 Videos | 1h 18s
  • 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 Memory-optimized Tables & Native Stored Procedures
Likes 11 Likes 11  
COURSE Analyzing Query Plans
Likes 21 Likes 21  
COURSE Stored Procedures
Likes 38 Likes 38  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Azure SQL Database
Likes 78 Likes 78  
COURSE T-SQL Queries
Likes 173 Likes 173  
COURSE Analyzing Query Plans
Likes 21 Likes 21