Lec-129: Simple vs Complex vs Materialized Views with examples | DBMS

►Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

[narendramodiboss]

This video is really helpful! I'm very new to DBMS and this is the first time I've watched a video on this subject. Your explanation is clear and compelling.

[ammadzaheer]

Nice way to define queries.. Its very help full for me. God bless you.

[sdef]

The explanation I am looking for. Thanks a lot Sir. ❤️

[prakashpandey]

Sir, aap itna achha padhate hai, abhi tak unacademy ne apko kharida kyo nahi??😂😂

[BhajanDuniya]

Sir materialized view ke syntax ka use karke view create karne ka ek video banaiye. Usmein materialized view ke bare mein sab kuch samajaya gaya ho *iske Build clause, refresh clause, on clause* ke sare options. Please iske videos to bahut hai but samaj nhi aa raha acche se. *Aap samjate ho to ek bar mein hi samaj aa jata hai* . Iske upper ek video ki mujhe bahut need hai please banaiye 🙏

[rajendramehra]

Thanks Sir, This series is really amazing, i will refer to others to learn from this SQL series, I am not expecting this kind material is exist in YouTube. A Big thank you once again :)

[TJAYASHANKAR-nu]

Suupperbb class sir❤dil se thank u sir, plz ek request hai ki SQL ka pura chapter complete kardijiye sir❤

[mr.gamertech]

THANKS SIR ALLAH PAK BLESS YOU AND YOUR FAMILIES AMEEN

[soumyaranjanswain]

sir i really admire your videos & actually i pass my sem exams by watching your videos.... sir i have a request please make a course video on data mining & data ware housing (dmdw) which i really need to study & imformation retrieval tooo..

Thankyou sir
🙏🙏🙏🙏🙏

[sibghaBiz]

you nailed it broo shi ma smjha dty ho

[paahiprishasamazingworld]

Sir in case of materialized view, we have stored data according min max and avg but after storing data we are inserting some new records in our actual tables from which we have created view then the result will be changed right?
Bt we have stored the same result then what will happen In that case

[sreevidyagireesh]

But if we store data and let’s say base table got changed. Max salary for one dept changed will that automatically update the materialized view?

[arshiabegum]

Sir can we write this materialized view for nosql also please, reply me

[Jagadishwar]

Sir, I want to become a data analyst.. Can u please let me the know the procedure

[VillagelifeRS]

Sir
External views
Concept views
Internal views
This vi

[satyaa]

Sir please provide the subtitles for the vedio
It would be great if you provide the subtitles because we're from South India we don't understand Hindi

[nehaankit]

Sir plz hpsc computer screening ka course start krwa do

[TranssionUpdatesTracker]

Sir ap weak q hogay hain??
Tabiyat sehat thek hai?

[patricgonzales]

If you want to speak hindi why you write english title

[venkateswarudusivam]

You are telling in Hindi..its very bad..should expain in english