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

  Рет қаралды 69,542

Gate Smashers

Gate Smashers

Күн бұрын

Пікірлер: 41
@andrea-kg9yx
@andrea-kg9yx 13 күн бұрын
These videos have been really helpful for me for my university theory as well as practical papers....the way u explained views is crystal clear and amazing...thank you so much sir.
@narendramodiboss
@narendramodiboss 2 жыл бұрын
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.
@sdef719
@sdef719 Жыл бұрын
The explanation I am looking for. Thanks a lot Sir. ❤️
@ammadzaheer8434
@ammadzaheer8434 Жыл бұрын
Nice way to define queries.. Its very help full for me. God bless you.
@BhajanDuniya8756
@BhajanDuniya8756 Жыл бұрын
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 🙏
@rajendramehra5180
@rajendramehra5180 Жыл бұрын
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 KZbin. A Big thank you once again :)
@185_harshkoldiya5
@185_harshkoldiya5 Жыл бұрын
so easy, so nice just thank you sir
@mr.gamertech9
@mr.gamertech9 Жыл бұрын
THANKS SIR ALLAH PAK BLESS YOU AND YOUR FAMILIES AMEEN
@TJAYASHANKAR-n6u
@TJAYASHANKAR-n6u Жыл бұрын
Suupperbb class sir❤dil se thank u sir,plz ek request hai ki SQL ka pura chapter complete kardijiye sir❤
@Darazfinds4350
@Darazfinds4350 2 жыл бұрын
Happy Teacher's Day Sir ♥️✨
@sibghaBiz
@sibghaBiz 10 ай бұрын
you nailed it broo shi ma smjha dty ho
@ritikasharma9252
@ritikasharma9252 10 ай бұрын
Sir u r a messenger of God ❤
@rashmijoshi7030
@rashmijoshi7030 8 ай бұрын
Fantastic sir😊
@kodgirevenkateshvilas
@kodgirevenkateshvilas 7 ай бұрын
Completed whole Playlist 🙌🙌👍
@RohitRaj-lb5si
@RohitRaj-lb5si 7 ай бұрын
Hello bhaiya, I am about to start DBMS because it is in my fourth semester syllabus, so can you tell whether this playlist is complete or not, I mean all the topics are covered right?And is this placement related also? Please respond.
@internationallegend5081
@internationallegend5081 2 ай бұрын
​@@RohitRaj-lb5sinope
@soumyaranjanswain2662
@soumyaranjanswain2662 2 жыл бұрын
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 🙏🙏🙏🙏🙏
@NakaruHikamuraOP
@NakaruHikamuraOP 2 жыл бұрын
++
@Tamanna_K_Hardy
@Tamanna_K_Hardy 2 жыл бұрын
Great as always 😎👍
@paahiprishasamazingworld
@paahiprishasamazingworld 7 ай бұрын
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
@prakashpandey1051
@prakashpandey1051 2 жыл бұрын
Sir , aap itna achha padhate hai , abhi tak unacademy ne apko kharida kyo nahi??😂😂
@ratnadeepmishra1403
@ratnadeepmishra1403 2 жыл бұрын
Bhai Unacedemy ko idea Mt do
@Alien-ik1tt
@Alien-ik1tt Жыл бұрын
I think Sir wants Education revolution like Khan Sir.
@vanshu....6250
@vanshu....6250 2 жыл бұрын
Thank you sir
@sreevidyagireesh
@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?
@Uzmikmedia12
@Uzmikmedia12 Жыл бұрын
thnak you
@captainjacksparrow782
@captainjacksparrow782 2 жыл бұрын
thank you
@rajabiswas8018
@rajabiswas8018 Жыл бұрын
is this playlist enough for gate ?
@arshiabegum2706
@arshiabegum2706 Жыл бұрын
Sir can we write this materialized view for nosql also please, reply me
@TranssionUpdatesTracker
@TranssionUpdatesTracker 2 жыл бұрын
Sir ap weak q hogay hain?? Tabiyat sehat thek hai?
@Jagadishwar1994
@Jagadishwar1994 2 жыл бұрын
Sir, I want to become a data analyst.. Can u please let me the know the procedure
@NakaruHikamuraOP
@NakaruHikamuraOP 2 жыл бұрын
Analyse your opportunities simple
@VillagelifeRS
@VillagelifeRS 2 жыл бұрын
Sir External views Concept views Internal views This vi
@nomaneeium2940
@nomaneeium2940 2 жыл бұрын
💜
@nehaankit1050
@nehaankit1050 2 жыл бұрын
Sir plz hpsc computer screening ka course start krwa do
@godbappa1
@godbappa1 2 жыл бұрын
1st comment 🙏🙏🙏🙏🙏
@NakaruHikamuraOP
@NakaruHikamuraOP 2 жыл бұрын
Konsa award chiye iske lie?
@satyaa4989
@satyaa4989 Жыл бұрын
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
@patricgonzales1486
@patricgonzales1486 8 ай бұрын
If you want to speak hindi why you write english title
@venkateswarudusivam1400
@venkateswarudusivam1400 11 ай бұрын
You are telling in Hindi..its very bad..should expain in english
Foreign Key🔑 with On Delete Cascade with Execution
5:34
Gate Smashers
Рет қаралды 53 М.
Lec-93: Why Indexing is used | Indexing Beginning | DBMS
10:20
Gate Smashers
Рет қаралды 1 МЛН
小路飞和小丑也太帅了#家庭#搞笑 #funny #小丑 #cosplay
00:13
家庭搞笑日记
Рет қаралды 8 МЛН
УДИВИЛ ВСЕХ СВОИМ УХОДОМ!😳 #shorts
00:49
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 3,7 МЛН
Lec-112: View in Database | Oracle, SQL Server Views | Types of Views
13:58
Lec-8.0: Integrity Constraints in Database with Examples
7:14
Gate Smashers
Рет қаралды 428 М.
What is Database Sharding?
9:05
Anton Putra
Рет қаралды 63 М.
小路飞和小丑也太帅了#家庭#搞笑 #funny #小丑 #cosplay
00:13
家庭搞笑日记
Рет қаралды 8 МЛН