Designing & Implementing Views

SQL Server 2016    |    Intermediate
  • 9 videos | 55m 48s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)
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

  • 5m 45s
    Upon completion of this video, you will be able to design and implement views. FREE ACCESS
  • 7m 10s
    After completing this video, you will be able to describe the various types of views. FREE ACCESS
  • Locked
    3.  Types of Views
    5m 12s
    In this video, you will create views. FREE ACCESS
  • Locked
    4.  Creating Views
    8m 37s
    Learn how to create a view with an index. FREE ACCESS
  • Locked
    5.  Creating Indexed Views
    9m 53s
    In this video, you will learn how to modify views. FREE ACCESS
  • Locked
    6.  Modifying Views
    3m 34s
    Learn how to modify data using a view. FREE ACCESS
  • Locked
    7.  Modifying Data Using a View
    6m 24s
    In this video, you will learn how to create views that are partitioned. FREE ACCESS
  • Locked
    8.  Using Partitioned Views
    4m 57s
    In this video, find out how to rename and delete views. FREE ACCESS
  • Locked
    9.  Renaming and Deleting a View
    4m 16s
    In this video, learn how to create an index with included columns. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Database Performance at Scale: A Practical Guide
Course Index Design Guidelines
Rating 4.5 of 97 users Rating 4.5 of 97 users (97)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Nonclustered, In-Memory, & XML Indexes
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Data Nuts & Bolts: Fundamentals of Data
Rating 4.4 of 524 users Rating 4.4 of 524 users (524)