3.14 CTE in Views

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

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