Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
I welcome back to Module three sequel programming. This is less than four table expressions, and this will be a quick lesson. We're in sub lesson 4.4 c t e with a view,
00:10
and what we're going to do is take the comment table expressions that we generated in the last lesson, and we're going to put them behind a virtual table known as a view. And that's really simple and easy to dio create or replace.
00:32
See you
00:36
manager
00:38
ANFO
00:39
as
00:42
S O. What the state middle dues will create the view if it doesn't exist, or it will replace the view. If it does exist, let's go ahead and run that
00:51
and it ran. Let's go ahead and refresh our views. Folder and D Beaver.
00:57
So right Click, refresh
01:04
and get rid of this filter if you have it in there.
01:11
Roided strength of tables
01:14
and
01:15
there's the manager and folk. We give that a double click.
01:19
We can see the columns that we created.
01:23
Take a look at the source code, which, if you weren't familiar with what we were doing, this would look pretty complicated. You'll also see that Ah
01:30
de Beaver or my seat. The my sequel engine has changed the way that the quarry looks, and it's not as reliable as it used to be.
01:44
There's the data tab and the yard E. R. Diagram. Now, if we want to use this
01:51
as a table in the future in different queries to make even more complicated connections of data, it will be much easier to deal with because it will be in a view. And we won't have to really worry about
02:02
the source that is creating that view, and that completes this lesson again. It was a short lesson. It was just
02:10
combining two ideas, which was taking a common table expression chain and putting it behind of you to make it more manageable for future queries. So I hope you enjoy this lesson and I will see you in the next one. Thank you.

Up Next

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor