VIEWS IN SQL WITH EXAMPLES | WHY VIEWS ARE USED?

[@crackconcepts]

✨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)

[@saanvinetalkar8937]

So minimalistic yet sufficient notes and explanation, thanks a lotttttt

[@amitk9843]

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!!!

[@maryamsaleh2043]

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.

[@RamRam-ce2yk]

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

[@kaustubhpaturi4801]

Smooth and straight... Perfect!

[@manikhantayema2395]

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 😊

[@muthulokesh9444]

Thank you sissy, very clearly explained in quick 5 mins

[@IndhujaPradeep]

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

[@thepriestofvaranasi]

Short and sweet explanation. Thanks alot 🙌🏻

[@arnadh2616]

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

[@kehkehkahkah6149]

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

[@sureshraj6600]

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 :)

[@chaitanyashetty457]

Please explain stored procedures and date functions

[@muralieemohan4255]

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

[@BHARATSINGH-km3ur]

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!

[@tanaykamath1415]

short and sweet, well explained!

[@aayushisoni4009]

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

[@jv___6729]

Thank you for this question .. I just tried and it is allowing to delete the table and if we try to select from view it says 'invalid object name tablename' 'Could not use view or function viewname because of binding errors'

[@kandinagireddy]

Could not use view or function 'View_Name' because of binding errors. This error can appearing.

[@dhrubajyotichatterjee1883]

Very good explanation.

[@lolipops8503]

You're wonderful!! Thank you so much

[@danishasghar1854]

Nice and specific explanation

[@adss5095]

thanks ,this is very helpful :)

[@crackconcepts]

Glad to hear that!

[@I_capture_emotions]

TOO NICELY EXPLAINED

[@sakshamdogra]

Really nice teaching❤

[@nakulanand2725]

Thanks for the info.

[@tubeitz]

Great video! thank you

[@vishalchauhan9832]

Nice explanation !

[@nomad4253]

Voice and explanation 👌🏻👌🏻

[@schoolerpandpos8861]

Thanks .....😍

[@schoolerpandpos8861]

I need your help ..

[@nallurivenkat7425]

Good video.

[@Inayatkhalil906]

Watching 1 day before exam helping ❤️❤️

[@Movi_virals]

Same😂😂

[@darthbleen984]

Ok

[@mahalingappabirajdar5285]

Wow 👌 explanation

[@prasada6471]

Thank you sister..

[@lambdamax]

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!

[@vishnudhonthu9912]

Nice explanation mam

[@sagarb.g.1672]

Thanks madam..

[@futuregroup7304]

thanks maam

[@harshvardhansinhthakor2121]

Nice 👍

[@balakrishna5340]

Thank you

[@MadForCs16]

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

[@rawatdhirender8598]

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

[@mohd.salman961]

😊😊😊😊 i like it

[@shubhamjaiswal9314]

nicely explained

[@gurusekharreddy6915]

👍👍👍

[@abaraobakhale9449]

you are amazing mam

[@banomobile5743]

Thanks slot

[@venip9106]

Thank you mam

[@asyncpipe]

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

[@gunicabagga6233]

Hi Eligijus, I am working on a similar thing currently and was wondering how to do this. Did you come up with a solution or a way to do this please?

[@rushikeshmane6399]

Thanknx ❤

[@akhilnarayanam4260]

Voice ❤️

[@vnpikachu4627]

Your voice is so cute ☺

[@blackhunter4567]

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

[@yoshitamahajan353]

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

[@vustudyguide]

sql ati ha apko project krna apna paid ?

[@maheshshinde2947]

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

[@dhananjayreddy9998]

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 ?

[@HarshitVlogs003]

👍

[@mrjgaming2313]

my all doubt is clear

[@videowithpradip3939]

good

[@fatah5390]

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

[@SSV1312]

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

[@SanojKumar-iq9xm]

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

[@manohargrandhi6881]

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

[@avinashpanchal8955]

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

[@bharathreddy7840]

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?

[@bharathreddy7840]

Since you said that it's virtual table, will this query creates virtual table instantly and get the data back to java objcet

[@goutham.ngowda5610]

can you please explain windows function and subquerys

[@venkymokkarala7677]

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

[@manikhantayema2395]

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

[@prasadjagtap1669]

where does simple view is stored ?

[@adamabdullah6789]

so what is different between function and view ?

[@jv___6729]

Functions can perform various operations which is it can get the user input and produces desired output , views are just select queries which saves time because we don't need to rewrite it again

[@vishnudhonthu9912]

Dbms imp questions chepara

[@ggopinadh3492]

can we update views..?

[@manjeetsinghmehta9462]

yes

[@sumitg4008]

How to join ur sql batch??

[@BSN_-qk4we]

Can we apply to mysqli also

[@nitishjaiswal107]

maam will you please provide pdf of your notes

[@saijyothsna4095]

i think order by clause is invaild in views

[@jv___6729]

Yes you are right , I just tried!

[@MAMAKIJAANGUGU]

Yes, you can’t use order by in views

[@videowithpradip3939]

is mehanat ko comment to banati hai

[@shoaibansari4359]

i love your voice :)

[@asif4904]

🔋

[@dramaworld3213]

Are you programmer?

[@abhishektiwari1989]

binod

[@Helloimtheshiieet]

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.

[@crackconcepts]

If you don’t use views, it automatically means no one will ever use views. GREAT!!