Designing & Implementing Views
SQL Server 2016
| Intermediate
- 9 Videos | 55m 48s
- Includes Assessment
- Earns a Badge
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 viewsdescribe the various types of viewscreate viewscreate an indexed viewmodify views
-
modify data using a viewcreate partitioned viewsrename and delete a viewcreate an index with included columns
IN THIS COURSE
-
1.Views5m 45sUP NEXT
-
2.Designing a View Structure7m 10s
-
3.Types of Views5m 12s
-
4.Creating Views8m 37s
-
5.Creating Indexed Views9m 53s
-
6.Modifying Views3m 34s
-
7.Modifying Data Using a View6m 24s
-
8.Using Partitioned Views4m 57s
-
9.Renaming and Deleting a View4m 16s
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.