Views in sql server Part 39

In this video we will learn about
1. What is a view
2. Creating example views
3. Advantages of using views
Text version of the video
csharp-video-tutorials.blogspo...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our CZcams channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
czcams.com/users/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

[@omprakash1453]

🙏 many many thanks

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
czcams.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
czcams.com/video/y780MwhY70s/video.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
czcams.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat

[@riderwonders6192]

Om Prakash can increase youtube views?..

[@stevenclark1123]

This guy is the best programming tutor on the web. Seriously...

[@phanendraallavarapu4651]

I strongly agree with ur word.

[@dev0_018]

i agree 💯

[@kripamishra1001]

Guys lets just not consume the content but also share Venkat's keen dedication towards teaching... literally its been 12 years since this video...we should share his channel as much as possible with our juniors and working collegues..
I wish I could ve watched this video earlier... he is so clear.... bcz of him I cracked the interview... as a senior analyst in reputed MNC
I was using linkedin learning earlier which just waste of money infront of him...
Thanks a lot Sir.. loads of respect and love ❤
You will always be my hero for SQL

[@dauculajava]

Thank you very much. I don't have to pay for any class because your vid tutorial is too excellent, easy to understand. You are naturally born to be a trainer

[@midsummer4864]

Thank you ever so much I am a new user of SQL and I find you videos so helpful. You are just brilliant

[@GauravSingh-bc7zm]

HATS OFF man the way you describe all the tutorials.
Awesome tutorials for beginners.

[@schudasama]

Hi Venky, You are son of Goddess Saraswati the God of Knowledge. Here in North America I feel very proud to be an Indian! Your intentions of helping people around the world to learn is your best Karma. God bless you!

[@Csharp-video-tutorialsBlogspot]

Hi Sanjay,
Thank you very much for taking time to give feedback. I am very glad you found these videos useful.

[@Mohammedaatif90]

kudvenkat Hi , venkat Sir you videos are really good and i am learning a lot from them . I have one request . Can you provide Us some practicals questions to perform using your videos ? It will help us to try new thing . from Beginner to intermediate . Like Practice " create login Page " , Create some sort of Display page , create something different . Something like which is used in current market .. Problem is i am going for interview as a fresher and they say normal crud operations are basic thing you need to learn more . I can't find how to apply all these into some small project and modules . I hope you understand what i wanted to say . It will be really helpful . Awaiting your reply :) Thanks

[@rudrashivgan5476]

God of knowledge is ganesh and the goddess is Saraswati

[@archanabhati1541]

YES, HE IS actually RIGHT, i also want practice question.

[@chorra977]

Sure he is.

[@bogdangirdea8929]

You are brilliant! You are made to teach others! Thank you!!

[@kirankumari-kk6pr]

I am big fan of your sql tutorial. i learn so many things in sql and join the sql company few days ago . Thanks a lot sir ...

[@shop7639]

Hello Mr.Venkat,
Your tutorial on SQL Views made my life easy at work. I have been scratching my head since a month to understand views since I never got a chance to work on SQL.
Trust me , I have been through 100 videos to get the best of what I want.. Sooner I saw your video, I subscribed your channel.
Keep Educating and inspiring newbies like me ...
Sarika Reddy

[@weatherlye71]

Excellent lesson - thank you! You answered some questions 'on the side', if you will. I was looking for specific information and got 'extra credit'. You taught me things I didn't even know I needed to know!

[@elenad4294]

You are fantastic. I came across your video after looking for DML triggers and I ended up watching more. I clicked subscribe botton imediately 👀thank you for your amazing work, my life is much easier now 🙏

[@ForsakePariah]

Best SSMS videos on youtube. Thank you!

[@zainkhan9497]

Explained really well sir.. itna tou kabhi class may b samaj ni aaya tha jitna video may dekhke samaj aaya. Thank u so much keep Teaching 😊

[@russellkemmit73]

Great, I come back to review your videos often!

[@prosperg186]

excellent video as usual. Just a tip: use table alias names on joining. So much easier and quicker to use.

[@udaybhaskarchodagiri475]

Hi Venkat your sessions are excellent. Thank you very much.

[@premsharanverma3557]

Sir, your explanation makes everything easy to understand for everyone, In my group everyone following you only. Thanks a lot for everything

[@Csharp-video-tutorialsBlogspot]

Hello Prem - Thank you very much for the feedback. Means a lot me. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

[@almosawi32]

I learn from you more than my college! Thank you

[@aakankshasingh5600]

what a clarity of expressions u have... commendable sir.... salute to u

[@BikashBiswalCHHUAPUA]

I really appreciate the way have explained. Thanks Bro
I understood the concept of Table and view.

[@azadehk3010]

I appreciate. It was really helpful. I just wanted to find a view description but now I am going to watch other videos.

[@balbahadurpokharel5849]

Thanks for great tutorials. I am really grateful to your contribution. Very much appreciated lectures.

[@ikramullahmohmand]

best persons should be appreciated for their work.... thanks

[@shivamghai9215]

Still so useful. Love you Venkat Sir. Thank you for all your efforts.

[@mr.prasadyadav]

Really Thank you very much Sir ..
Every video of your class is a Diamond of SQL server ..

[@Divyaprakashpandey52]

Hi Venkat, thank you for the explanation. i wanted t ask if we run a view having select query from a table and normal select query on the same table. Which one will be faster or will they be same?

[@TheFallibleFiend]

Brilliant, as usual. Right to the important points and application. No rambling.

[@sharan7blue]

simply superb god bless you mate!!

[@mukund3060]

Thanks a lot venkat.
you are so great .....
explained topics so simply.

[@mohitawasthi7866]

Hi Venkat,
Please include DML (Insert and Update) in views, great video

[@brunomcsilva5404]

Great Video. It deserves many Thumbs up. Thank you !!

[@Csharp-video-tutorialsBlogspot]

Hi Suresh, thank you very much for the feedback. I am really glad these videos are helpful to you. Training videos are uploaded on a daily basis. If you want to receive email alerts when new videos are uploaded, please subscribe to my youtube channel.

[@karthikkarthikyuvi7073]

i am following every videos of u sir.....its very easy to understand.keep ur good work sir..god bless u.

[@Anand-wl6qr]

You makes it soooo easy man.
Thanks a million 🙏

[@linkon_]

Thank you Sir for your detailed and easy to learn videos.

[@zoehyang]

This is the best SQL courses I've ever watched. Thank you so much for your hard work on this!

[@kushasawa627]

Do I have to watch all 149 for basic knowledge in SQL, if not then how many slides are sufficient?

[@arunas5050]

All your videos are very clear in explanation and hats off to your effort taken

[@sravankumar1767]

Thanks' a lot, nice explanation any body can easily understand. The way of explanation is awesome..

[@mighubp]

Con mi modesto ingles, entiendo todo!. Muy buena explicación. Felicitaciones y gracias.
Miguel

[@UsmanGhani-xn8vn]

sir ..all these videos are very useful .thank you very much

[@salehali940]

What is the difference between valued table function & Views ??
we call each to get a table right ?

[@m-corpgames4011]

Thank you very much my good sir. It is 2018 and your video really is still relevant and it helped me understand what a view is.

[@loading.m4469]

Very helpful. You are a great teacher!

[@rojakarne9839]

your explanation is very clear n perfect

[@phaniraj434]

Hi venkat, you are a great teacher.

[@karishmapatil3020]

Hi sir really good explanation...your example are really good .after watvhing your videos I get confidents on that topic..

[@ecarlosbc]

I LOVE YOU MAN!!! :D

[@alexdonchev1491]

Thanks, this has been very helpful!

[@shrijadas9987]

Awesome explanation ... You are really a pro!

[@loading.m4469]

Thank you very much for all your great efforts.

[@anand.guggari.9657]

Thanks, sir :) All the videos are very well explained :)

[@neeljotani4902]

thanks for this video
i am loving it

[@mixnmatch7864]

thanks sir..u saved me,,thanks a lot.

[@phaniraj434]

Hi venkat, do you have any plans in the near future on preparing videos on SSBI,Reporting services etc

[@achaouki]

hi "kudvenkat" I WANT JUST TO SAY TNKE U VERY MCH

[@unpluggedlyrics5869]

Column names in each view or function must be unique. Column name 'dep_id' in view or function 've' is specified more than once.???why this error is coming??can you tell me??

[@loading.m4469]

Your videos are great!

[@amanullah5053]

Thanks, Your Video is very easy to understand.

[@bhagyashreejain539]

all of ur videos are excellent...

[@articcircleado]

Excellent video -- Thank you!

[@harshpatel1515]

[@bgrg]

@kudvenkat when it comes to row/column security or hiding data, once we create the views with selected data, how do we then restrict the user with just these data?
I am still a begineer learning about sql. Sorry if I don't nake sense.

[@khurshidmalik565]

It's really great. Thanks ..

[@batabatonica]

Your content is awesome dude

[@7116matrix]

Thanks for the tutorials

[@nileshkamble3673]

Thanks a ton Venkat!

[@nganzijr]

Amazing
So simple and super useful

[@binduskumar3201]

Great explanation!!!

[@avinashhiradodde7246]

very nice explanation sir i liked it....

[@hudawm7]

Great video!

[@karishmapatil3020]

you are really really wonderful ......!!!!

[@konstantingrigorov1042]

Great tutorials :))))

[@maheshd3506]

Nice explanation, thanks 👍

[@ramantharji9881]

Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.

[@solapaification]

Awesome, thank you!

[@ya0004ng]

excellent job!

[@saikishore2401]

Thanks a lot for your session.

[@waiyanhein7205]

Sir I respect u so much . I follow all videos u uploaded . But how can non-it user use sql query sir ?

[@muralimuthyala1965]

thank you for your great explaining .

[@debbie1724cham]

need to dig further into knowing SSMS.. :) this is a good vid

[@vijayraj6291]

Your save lot of lifes...

[@Tonystark-br1vy]

Thank you so much...but I have a question "what is the difference between CTE, procedure and view?"

[@powerbireal-time4136]

Awesome explanation ()

[@sumalatha-sv2mv]

its very useful,thanks a lot......

[@AjinkyaDeshpandes]

Great one.

[@nithyasanthoshininalmas2953]

thanks a lot...for ur videos:-)

[@watan178]

i became ur fan sir

[@nancychikara3713]

Hello Venkat,
As far as I remember, in store procedure you said that we can use them whenever we need to give limited access to someone. So, I would like to know how is view different from stored procedure?
Thanks.

[@rudrashivgan5476]

+Nancy Chikara A View Can't Accept a Parameter but a Stored Procedure Can Do So.A View Won't Be Able to Modify a Table...A Stored Procedure can do so.You Can Insert,Update Or Delete a Row Using Views..A Stored Procedure Restricts You From Doing So.A View Can Be Used in Large Queries as A Fundamental Unit.For Example in Joins.

[@nancychikara3713]

+Rudra Shivgan Thank you Rudra! your explanation just answered my question

[@ajitshinde9277]

@@rudrashivgan5476 we can insert, updated, delete using sp not by views please check

[@godbhaigod]

I love you

[@behnamamiri8252]

thank you so much

[@sanukotiya6956]

hi sir if we give access of the view to non IT guy and if by mistake he delete some data or update the data then it will become unsecure...i don't think that would be a good...please tell which is the best reason where i can use views in SQL..

[@gopinathrao05060]

Really a good one

[@just_kidding_kid]

thanks you very much
Regards from Ukraine

[@ayselceferzade8587]

awesome! thanks!

[@orhanbakuvi]

Appreciate it . Do you have Pandas series like this ?

[@ravisankarreddy5697]

Good explanation venkat

[@Csharp-video-tutorialsBlogspot]

+Ravi Sankar Reddy Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
czcams.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
czcams.com/video/y780MwhY70s/video.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
czcams.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat

[@b.vandanareddy7676]

Very nice explanation

[@munirhabib8153]

very useful for beginners,

[@ssrrv4880]

Hi Venkat ,
I have a doubt,I am new to SQL, after listing this video ,i got a question,i.e..
Here view is similar to stored procedure..we have stored procedure to save the selected query and we can use it later,here why we need to create the view again ? is it not same with stored procedure..
please help me.

[@viveksakhamuri7961]

If you drop a table in db...then related view of the table is also deleted or not??

[@saikrishna7987]

super explanation