VIEWS IN SQL WITH EXAMPLES | WHY VIEWS ARE USED? 

✨Link to my SQL e-book: imojo.in/rkajq9 ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

So minimalistic yet sufficient notes and explanation, thanks a lotttttt

Now I get full clarity of views concept. By u.. Really thanks to u...

Smooth and straight... Perfect!

Just saw ur vdos on indexing and views Awesome... Love the way u use paper notes in this digital era... love the way u make it simple... love ur voice... FAN forever... subscribed... God bless you with huge success!!!

Thank u mam I have confused a lot about views last two days Now am very happy it's helps a lot to me tq 😊

thank you so much for this video now my concept is clear of view. this video help me alot. your way of explanation is too good.

cool.. liked it.. keep it up.. and thanks

Thank you sissy, very clearly explained in quick 5 mins

Short and sweet explanation. Thanks alot 🙌🏻

you're such a big helper...tq so much

when i dont get concepts cleared on udemy,edureka..etc etc.ur channel is my get away to actually understanding things.keep up the good job!

short and sweet, well explained!

Really mam its very usefull and i got it to my semester exam very helpfull ❤

I have seen u r video today morning. I became u r subscribe. Super and thanks

You're wonderful!! Thank you so much

Nice and specific explanation

Great video! thank you

Voice and explanation 👌🏻👌🏻

Please explain stored procedures and date functions

TOO NICELY EXPLAINED

Wow 👌 explanation

Very good explanation.

Hi! Thank you for this video. I have a quick question. After creating a view on an editor, does one save that file? If one is trying to query the view that was just created in a subsequent query, how does one do it? Thank You!

Thanks for the info.

Really nice teaching❤

Nice explanation !

Good video.

Great. I wonder if querying a single column from a view is processing the calculations for the columns that aren't queried.

quick question- suppose if i create a view A using more than one table (b,c,d ) but i drop one the table lets say,b in reality which is used in view, what would be impact over view then

In SCD we use these views to restrict the data from viewing to the end customers. Correct me if am wrong. Very nice explanation mam :)

can you please explain windows function and subquerys

Thank you sister..

nicely explained

Nice explanation mam

Thanks slot

Nice 👍

Thanknx ❤

is there any query to see all the created views on the table?

How come joining of 3 tables is complex without views. Could you please explain briefly. For Views also writing the same select query but how it differs ?

how to differentiate views and CTE's (one is temporary table and another one is a virtual table ) I only found syntax change ...can you share some knowledge on this topic as well

Thank you

thanks ,this is very helpful :)

👍

Thanks .....😍

Thank you mam

😊😊😊😊 i like it

once we create view can we alter and update the view?

Ok

how do u create a view in a different server so people can data in one server

you are amazing mam

after created view how to see which tables is used to create the view?

Any Pdf available for all u r classes of SQL and plsql tutorial??? Madam

Thanks madam..

thanks maam

👍👍👍

Your voice is so cute ☺

Can we apply to mysqli also

Watching 1 day before exam helping ❤️❤️

good

Hello Mam, ye sheet jo aap use karti ho explain karne keliye iski pdf kaha se download kare??

Voice ❤️

Mam can u please upload a real time work videos on sql.

can a view be based on another view ? can please explain it with example?

Hi I had query that can we use the same queries of sql and plsql Oracle db ??

Can we write the views just like SQL in our programming language to interact with DB? And get that data back to our java object for example?

where does simple view is stored ?

This was very much helpful. Today I have an interview and I feel confident now.

my all doubt is clear

maam will you please provide pdf of your notes

Tomorrow is my dbms exam...let's hope for the best😢

How to join ur sql batch??

so what is different between function and view ?

can we update views..?

i think order by clause is invaild in views

is mehanat ko comment to banati hai

i love your voice :)

🔋

binod

Dbms imp questions chepara

Are you programmer?

Yeah..... skip this nobody uses views ever. Views were popular in 1990s early 2000s before big data came along. I haven't created a VIEW at one of the largest financial inst in the world in 10+ years.