From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
What are views? - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
What are views?
- [Instructor] Anytime you pull information out of a SQL server table you'll use a select statement that queries a list of tables and columns and processes the data according to your requirements. Select statements can get very complex, especially when multiple table drawings and filtering criteria are in play. You can save the syntax of a select statement for a future use by creating a view object. SQL server views can typically be thought of as virtual tables. They usually don't store any data themselves only references or pointers to the underlying data tables and columns. However, they can be treated like a table and performing select statements against a view looks identical to performing a select statement against a table. In fact many times the user is unaware if they are referencing a view or a table in a query. The main benefit of using a view, thought, is that it greatly simplifies the syntax required…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.