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 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 45sUpon completion of this video, you will be able to design and implement views. FREE ACCESS
-
7m 10sAfter completing this video, you will be able to describe the various types of views. FREE ACCESS
-
3. Types of Views5m 12sIn this video, you will create views. FREE ACCESS
-
4. Creating Views8m 37sLearn how to create a view with an index. FREE ACCESS
-
5. Creating Indexed Views9m 53sIn this video, you will learn how to modify views. FREE ACCESS
-
6. Modifying Views3m 34sLearn how to modify data using a view. FREE ACCESS
-
7. Modifying Data Using a View6m 24sIn this video, you will learn how to create views that are partitioned. FREE ACCESS
-
8. Using Partitioned Views4m 57sIn this video, find out how to rename and delete views. FREE ACCESS
-
9. Renaming and Deleting a View4m 16sIn 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.
