From the course: Developing Microsoft SQL Server 2016 Databases

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create a view of the data

Create a view of the data - SQL Server Tutorial

From the course: Developing Microsoft SQL Server 2016 Databases

Start my 1-month free trial Buy for my team

Create a view of the data

“

- [Narrator] Once you know how to create a select statement in SQL server, you essentially know how to create a view. Views will streamline the process of querying information out of the database and ensure that you're viewing the results in a consistent manner every time. To get started with this, I first want to switch into the wide world importers database. Then, to get a feel for what views are already inside of this database, let's go ahead and open up the databases folder and then open up the database folder for the wide world importers and then go into the views folder. Currently this database only has three views, website.customers, website.suppliers, and website.vehicletemperatures. To query a view, you'll use the exact same syntax that you would use when you're querying a table. We can pull information out of the website.customers view by just running it as a standard select statement, such as I have on…

Contents