✨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)
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!!!
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
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'
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
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!
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 ?
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
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.
✨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
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!!!
Now I get full clarity of views concept.
By u..
Really thanks to u...
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.
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 sissy, very clearly explained in quick 5 mins
Really mam its very usefull and i got it to my semester exam very helpfull ❤
Smooth and straight... Perfect!
Short and sweet explanation. Thanks alot 🙌🏻
Very good explanation.
cool.. liked it.. keep it up.. and thanks
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!
Please explain stored procedures and date functions
thanks ,this is very helpful :)
Glad to hear that!
Nice and specific explanation
I have seen u r video today morning. I became u r subscribe. Super and thanks
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
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'
Could not use view or function 'View_Name' because of binding errors. This error can appearing.
Good video.
short and sweet, well explained!
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
Nice explanation !
Really nice teaching❤
Voice and explanation 👌🏻👌🏻
Watching 1 day before exam helping ❤️❤️
Same😂😂
Thanks for the info.
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 :)
TOO NICELY EXPLAINED
You're wonderful!! Thank you so much
Nice explanation mam
Nice 👍
Great video! thank you
This was very much helpful. Today I have an interview and I feel confident now.
👍👍👍
thanks maam
Ok
Thank you sister..
nicely explained
Wow 👌 explanation
Thanks madam..
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 .....😍
I need your help ..
😊😊😊😊 i like it
you are amazing mam
Great. I wonder if querying a single column from a view is processing the calculations for the columns that aren't queried.
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?
Thank you
Thanks slot
after created view how to see which tables is used to create the view?
can a view be based on another view ? can please explain it with example?
Your voice is so cute ☺
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 ?
Tomorrow is my dbms exam...let's hope for the best😢
Voice ❤️
my all doubt is clear
how do u create a view in a different server so people can data in one server
Thank you mam
Hello Mam, ye sheet jo aap use karti ho explain karne keliye iski pdf kaha se download kare??
once we create view can we alter and update the view?
good
is there any query to see all the created views on the table?
Mam can u please upload a real time work videos on sql.
Hi I had query that can we use the same queries of sql and plsql Oracle db ??
sql ati ha apko project krna apna paid ?
Thanknx ❤
can you please explain windows function and subquerys
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?
Since you said that it's virtual table, will this query creates virtual table instantly and get the data back to java objcet
where does simple view is stored ?
Dbms imp questions chepara
👍
Any Pdf available for all u r classes of SQL and plsql tutorial???
Madam
so what is different between function and view ?
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
How to join ur sql batch??
maam will you please provide pdf of your notes
is mehanat ko comment to banati hai
can we update views..?
yes
i think order by clause is invaild in views
Yes you are right , I just tried!
Yes, you can’t use order by in views
Can we apply to mysqli also
i love your voice :)
🔋
Are you programmer?
binod
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.
If you don’t use views, it automatically means no one will ever use views. GREAT!!