From the course: Microsoft SQL Server 2016: Query Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introducing views - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Introducing views
- [Instructor] In this lesson, we're going to take a look at views. We'll talk a little bit about what views are, the concept of a view in SQL Server, and how we can make use of them. Views are a great way of presenting a restricted, read-only version of data in your database, to external users. So, views are considered to be virtual tables, or at least, that's how I refer to them as, and their contents are defined by a query, so you'll create a query to actually generate the view, and there is a specific sequence and there are keywords such as Create View that allow you to create the view initially. But ultimately, what is in the view is driven by the query that you write for the construction of it. They can look like tables to someone reading the data from them. But again, the thing that I like most about them is, they're a read-only version, so, even if somebody attempts to run an update on a view, it won't succeed in the database, because it's a read-only representation. There are…
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.