From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create views

Create views - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Create views

“

So if you've gone through any of the other lessons in this series, you'll see that we've often referenced tables and we've pulled data in and out of tables, and they are truly the heart of a database. That is where everything lives. But the other piece of using a database is you're constantly trying to read data in and out of said database, and you want it in a form that is friendly to your users and friendly to your applications. And how it's stored in the tables isn't always designed to be user friendly. It's more designed to be appropriate for either relational database or for speed if you're setting up a reporting server or whatever the case may be, and often your data is scattered all over multiple tables because that makes sense from a design standpoint, but not necessarily from an access standpoint. So I'm going to show you what a view is and how you can use it to start creating literally just that views of your data. So I'm just going to start a new query in the…

Contents