▶ Connect With Vijay Agarwal Sir: t.me/vijaysirpw ▶ Telegram Group for Electronics & Communication Engineering : t.me/GWElectroandcom ▶ Telegram Group for Computer Science and Information Technology Engineering : t.me/Gwcomsciandinfo ▶ Our Telegram Page: t.me/gatewallah_official ▶ Our Instagram Page: bit.ly/Insta_GATE
1:16:30 Prime Attr vs non-prime attr 3:15:00 Dependancy preservation 3:26:30 Normal forms 3:44:00 3NF 3:46:00 2nf vs 3nf vs Bcnf & Important points 4:06:00 design goal 4:40:30 transactions consept 5:27:10 conflict equivalent 6:09:30 Recoverable schedule 6:21:00 lock based protocol 6:45:00 Thomas write rule
VIJAY SIR IS LEGEND , GREATEST OF ALL TIME , GOD. NONSTOP FOR 11 HOURS WITHOUT SITTING . STARTING CONCEPTS FROM ZERO AND MAKING IT VERY EASY TO UNDERSTAND WITH TREMENDOUS QUESTION SOLVING AND EXPLAINING . HE COVERS WHOLE SUBJECT FROM ZERO !! HUGE RESPECT FOR VIJAY SIR ALWAYS 🙏🙏 , HE IS MY ALL TIME INSPIRATION 🙏🙏 , HE DOSN'T EVEN LET YOU UNDERSTAND THAT HE IS SUFFERING FROM PAIN AND TEACHES WITH FULL ENERGY ALWAYS !!! THANK YOU SO MUCH VIJAY SIR , NO WORDS CAN MAKE JUSTICE TO THIS DEDICATION !! THANKS A LOT SIR ! YOU ARE GOD 🙏🙏❤
After watching your lecture i start gate prepration because you made every concept crystal clear. Phle to dr lgta tha questions hilte bhi nhi the.. ab sb hojata h❤❤🎉🎉🎉🎉
Sir kya hi maha revision tha aapka itne km time me itna jyada content. Mai paid batch me DBMS padha tha aapse lekin 2 copy ko revise karna mushkil tha jo aapke help se ho gya . I think it was just like a crash course of DBMS because you have covered nearly all the topics and questions. Salute for this hard working sir. Aapne aaj ki class me kaii baar vomitting bhi ki thi phir bhi continuously 10 hours upar tak chla hmara class so please take care of your health sir. 🙏🙏🙏
Frankly speaking sir this is the first time I've studied for 10 hrs straight. Itna ache se revision hua ki pata hi nahi chala time ka....so thank you so much sir. This was very much needed for so many of us.
I am from the mechanical branch, lekin jb randomly yt open Kiya or sir ko padhte dekha raat ke 3 bje toh maza hi aa gya............ 10 hr Bina ruke salute to you sir 🫡.
VIJAY SIR heads of to you, iss time pe bhi aapne itna comprehensive revision karwaya dekh ke maja hi aa gya aur dbms mein confidence dilane ke liye thank you sir. We wish for your recovery from Teeth pain. Get well soon sir. Sir maine 30 mins ke baad join kiya tha lekin aapka dedication aur padhane ke tarike se main bhi aaj 10 ghante lagataar pehli baar beth ke padha hun. 💗💗💗💗💗💗💗💗💙💙💙💙💙💙💙💙💙💛💟💟💟💟💟💟💟💟
Best Best Best Session Ever by the BEST FACULTY FOR GATE CS EXAM , VIJAY SIR IS ABSOLUTE LEGEND 👑👑, Whenever we see Vijay Sir , we always feel very blessed and grateful for having such an exceptional teacher ever !! 🙏 Thank You So Much Sir for providing so much high quality content !!! 👑🙏 We can’t Thank You Enough for everthing !! 🙏
Sir you cares for us alot... aapki tabiyat kharab thi fir bhi lgataar 10 ghante enough energy k sath dil se padhaya... thank you sir... aap hi nhi GATE wallah k saare teachers apna best de kr bachho ko padhate hai... thanks to alak panday sir jinke wajah se best faculties se hum padh pa rahe hai... GW is best ❤❤❤
Thank you so much Sir for Maharevision session Sare concepts ekdum crystal clear ho gaye sir. Sir aapki energy bohot motivate karti hai mujhe sir. Sir apne health ka bhi khayal rakhiye. Once again sir thank you so much for this 🙏🙏
Sir revision ke Baad to aur bhi achche se sab kuch clear ho geyi hai and Qs bhi achche se slove ho rehe hai abh.... Thak you so much sir.. One shot mein sab kuch cover karane ke liye...🍀🍀♥♥♥♥♥♥♥♥♥
Thank you Sir for this great session and teaching the whole subject. Respect 🫡 for taking 10 hours lecture in poor health condition. Take care sir .Hope you will get well soon.
best revision session , revision ke Baad ekdm achche se sab kuch clear ho gya and .... Thank you so much sir.. One shot mein sab kuch cover karane ke liye... Guru aap jaise ho toh koi topic nhi bachega
THANK YOU VIJAY SIR FOR SUCH AN AMAZING SESSION , TAKING SUCH A LONG CLASS DESPITE OF SEVERAL HEALTH ISSUES MEANS A LOT , JAB APP PADATE HAI TIME KA PATA HI NAHI CHALTA , THANK YOU SIR ❤❤❤.
▶ Connect With Vijay Agarwal Sir: t.me/vijaysirpw
▶ Telegram Group for Electronics & Communication Engineering : t.me/GWElectroandcom
▶ Telegram Group for Computer Science and Information Technology Engineering : t.me/Gwcomsciandinfo
▶ Our Telegram Page: t.me/gatewallah_official
▶ Our Instagram Page: bit.ly/Insta_GATE
where will we get notes?
@@shivanirajpoot8704
Aapke pass yeh noted hi kya?
@@shivanirajpoot8704 aapke pass yeh notes hi kya????
ho toh plz send krdo??
Time stamps
Functional dependency: 26:30
Armstrong axiom: 1:05:35
Attribute closure: 1:07:34
Keys concept: 1:19:30
Membership set: 2:33:40
Equality between 2 FD sets: 2:40:50
Canonical cover: 2:45:20
Procedure to find minimal set: 2:48:16
Super key: 2:55:30
Closure of FD set: 3:00:30
Lossless/Lossy join: 3:04:30
Dependency Preserving: 3:14:02
Normalisation: 3:27:37
Transaction: 4:41:15
ACID Property: 4:43:00
Schedule: 4:51:20
Conflict Equivalent Schedule: 5:27:03
View Serializable Schedule: 5:30:25
Serializable dependency: 6:06:54
Recoverable schedule: 6:08:52
Lock based protocol: 6:20:30
2 phase locking protocol: 6:23:20
Time based protocol: 6:33:23
ER model: 6:56:40
ER to Relational model conversion: 7:11:10
Foreign key: 7:21:30
Query language: 7:59:55
Relational Algebra: 8:00:54
Join: 8:26:37
Rename operator: 8:39:34
Division operator: 8:41:00
SQL: 9:03:00
Nested Query: 9:32:49
Relational Calculus: 9:40:58
File indexing: 9:50:17
aage bhi likdo bhai
Likh rha hu Bhai jaise jaise padh rha hu
thanks champion
thank you
Thank u so much!!
1. Basics: 0:00 ✓
2. Functional dependency: 26:30 ✓
3. Armstrong axiom: 1:05:35 ✓
4. Attribute closure: 1:07:34 ✓
5. Keys concept: 1:19:30 ✓
6. Membership set: 2:33:40 ✓
7. Equality between 2 FD sets: 2:40:50 ✓
8. Canonical cover: 2:45:20
9. Procedure to find minimal set: 2:48:16
10. Super key: 2:55:30
11. Closure of FD set: 3:00:30
12. Lossless/Lossy join: 3:04:30
13. Dependency Preserving: 3:14:02
14. Normalisation: 3:27:37
1:16:30 Prime Attr vs non-prime attr
3:15:00 Dependancy preservation
3:26:30 Normal forms
3:44:00 3NF
3:46:00 2nf vs 3nf vs Bcnf & Important points
4:06:00 design goal
4:40:30 transactions consept
5:27:10 conflict equivalent
6:09:30 Recoverable schedule
6:21:00 lock based protocol
6:45:00 Thomas write rule
VIJAY SIR IS LEGEND , GREATEST OF ALL TIME , GOD. NONSTOP FOR 11 HOURS WITHOUT SITTING . STARTING CONCEPTS FROM ZERO AND MAKING IT VERY EASY TO UNDERSTAND WITH TREMENDOUS QUESTION SOLVING AND EXPLAINING . HE COVERS WHOLE SUBJECT FROM ZERO !! HUGE RESPECT FOR VIJAY SIR ALWAYS 🙏🙏 , HE IS MY ALL TIME INSPIRATION 🙏🙏 , HE DOSN'T EVEN LET YOU UNDERSTAND THAT HE IS SUFFERING FROM PAIN AND TEACHES WITH FULL ENERGY ALWAYS !!! THANK YOU SO MUCH VIJAY SIR , NO WORDS CAN MAKE JUSTICE TO THIS DEDICATION !! THANKS A LOT SIR ! YOU ARE GOD 🙏🙏❤
I Agree mate
Ye bata gate score kya h tera??
GREAT TEACHER.... 10 hours in one go is not a joke
Hats off to you VIjay sir
Everyone please pay attention closure of FD set at time stamps: 3:04:00 question has come in 2024 gate exam so don't skip please
Kya bat hai sir ..aapne to jajbat halat sab badal diy.... great sir
Timestamps:
0:00:00 - Introduction
00:01:40 - WHAT TOPICS TO BE COVERED?
00:04:40 - INTRODUCTION OF DBMS
00:06:00 - INTRODUCTION OF RDBMS
00:15:08 - WHAT IS DOMAIN
00:16:07 - RELATION SCHEMA AND INSTANCE
00:19:10 - RELATION INTENSION AND RELATION EXTENSION
00:26:10 - FUNCTIONAL DEPENDENCIES
01:19:20 - FINDING KEYS (SUPER KEY CANDIDATE KEY ETC)
02:48:20 - MINIMAL COVER
03:27:50 - NORMAL FORMS
04:40:10 - TRANSACTION CONCEPT
04:51:20 - SCHEDULES
04:59:43 - SERIAL SCHEDULE
05:03:20 - SERIALIZABLE SCHEDULE
06:24:30 - 2PL
06:27:45 - STRICT 2PL
06:56:45 - ER-MODEL
07:59:40 - QUERY LANGUAGE
08:00:55 - RELATIONAL ALGEBRA
09:02:20 - SQL
Words Can't Define Your Dedication and Teaching Legacy Viijay Sir.💯💯.
Real Superstar for our student community.
Best faculty who made DBMS+ CAO like hard subjects like a piece kf cake 🎉🎉🎉🎉🎉
After watching your lecture i start gate prepration because you made every concept crystal clear. Phle to dr lgta tha questions hilte bhi nhi the.. ab sb hojata h❤❤🎉🎉🎉🎉
Hats off sir!
Perfect revision series one can have!
Thank youuu!
Huge respect sir ♥️ This is the best DBMS revision class. You just made it simple to learn
Sir kya hi maha revision tha aapka itne km time me itna jyada content. Mai paid batch me DBMS padha tha aapse lekin 2 copy ko revise karna mushkil tha jo aapke help se ho gya . I think it was just like a crash course of DBMS because you have covered nearly all the topics and questions.
Salute for this hard working sir. Aapne aaj ki class me kaii baar vomitting bhi ki thi phir bhi continuously 10 hours upar tak chla hmara class so please take care of your health sir.
🙏🙏🙏
Sir you are really bleesings for students like us, you are inspiration for me , you inspire me to work hard and give my best
The session was really amazing sir. Thanks a lot to clear the concepts in the great depth.
Sir ...your teaching is like an another level....thanks a lots❤🙏
DEDICATION+CONTENT+SIMPLICITY
Hats off to your commitment sir!!
Did it one day before exam and found it very helpful !!
Hats off sir. you did a splendid job for continuously teaching for 10+ hours. thank you sir
Frankly speaking sir this is the first time I've studied for 10 hrs straight. Itna ache se revision hua ki pata hi nahi chala time ka....so thank you so much sir. This was very much needed for so many of us.
I am from the mechanical branch, lekin jb randomly yt open Kiya or sir ko padhte dekha raat ke 3 bje toh maza hi aa gya............ 10 hr Bina ruke salute to you sir 🫡.
Thanks for covering 70-80%.... Would look forward to session only with PYQS!!!
Thanks for teaching non stop upto 10 hours. 😢😢 Only you can do that much for us. Love you sir from heart
Sir You Best Teacher Ever sir. Non stop 11h, With Pain and Without Sitting, Thank You So much sir.
VIJAY SIR heads of to you, iss time pe bhi aapne itna comprehensive revision karwaya dekh ke maja hi aa gya aur dbms mein confidence dilane ke liye thank you sir. We wish for your recovery from Teeth pain. Get well soon sir. Sir maine 30 mins ke baad join kiya tha lekin aapka dedication aur padhane ke tarike se main bhi aaj 10 ghante lagataar pehli baar beth ke padha hun.
💗💗💗💗💗💗💗💗💙💙💙💙💙💙💙💙💙💛💟💟💟💟💟💟💟💟
Sir respect from heart 🖖🖖🖖 from 5pm to 3am 😮😮😮😮
Best Best Best Session Ever by the BEST FACULTY FOR GATE CS EXAM , VIJAY SIR IS ABSOLUTE LEGEND 👑👑, Whenever we see Vijay Sir , we always feel very blessed and grateful for having such an exceptional teacher ever !! 🙏 Thank You So Much Sir for providing so much high quality content !!! 👑🙏 We can’t Thank You Enough for everthing !! 🙏
Vijay Thalapathy sir 🔥🔥🔥 you really deserve Oscar award sir apne ek ek important topic cover kaare diya sir health issues hone ke baad bhi ❤❤❤❤❤
Sir you cares for us alot... aapki tabiyat kharab thi fir bhi lgataar 10 ghante enough energy k sath dil se padhaya... thank you sir... aap hi nhi GATE wallah k saare teachers apna best de kr bachho ko padhate hai... thanks to alak panday sir jinke wajah se best faculties se hum padh pa rahe hai... GW is best ❤❤❤
Thank you so much sir for your effort ❤
Thank you so much sir 🙏 jaldi se thik ho jao
Hatss of sir ❤ thanks a lot for this lovely session , all the concepts are clear clear now❤❤
🎉🎉🎉best revision session ,Vijay sir is absolute legend 🙌 👏🏼
Thank you so much Sir for Maharevision session
Sare concepts ekdum crystal clear ho gaye sir. Sir aapki energy bohot motivate karti hai mujhe sir. Sir apne health ka bhi khayal rakhiye.
Once again sir thank you so much for this 🙏🙏
GOD bless you sir ....Sri Narayan Ram bless you
Thanku
Hats off for the dedication to teach us for continuous 10 hrs
Respectful teacher 😊
Huge respect to you Sir 🙏🏻
Sir you are a hero❤ hats off to you.
Best revesion from all others
Thank you sir ji this amazing lacture salute 😊
Your dedication is great 👍
this vedio are helpfull for revision😀😀😀😀😀😀😀😍😍😍😍😍
Thank you vijay sir for being with us, you are a gem
Sir today I was solving pyqs to my surprise all are correct......it's just because of you sir.....I truly wish to get your blessings before exam
Vijay sir ke age koi bol sakta hai kya.... Vijay sirrrrrrr......❤
you are legend sir , continuosly teach 10+ hour , Thank you for your efforts
Shandaar, jabadast,adbut, awisheasneey, akalpneey😅😅❤❤
Mind blowing lecture 🎉
AMEZING TEACHING STYLE
AND HIGHLY ENERGYTIC
God bless you sir ❤🙏🙏 huge respect from the bottom of our heart 💓
hats off sir ....DBMS mean Vijay Sir
The Great MahaRevision class. Thanks u so much sir ♥️💐🙏
one of the best revision i have watch till now..😊
Maja aagya sir ji. Thankyou so much
Sir apka class dekh ke me khud teacher ban sakta hu kyu ki utna achhe se padate ho great sir❤❤ love from Karnataka ❤❤❤
Great Session Sir. Thank you for your efforts.❤❤
Next level Excellent teaching skill
🤩🤩
Its Grate Session for revision
No word sir, You are legend sir, This is best revision session i have gone through, but sir take care of your health first! 🙏🙏
Thankyou sir ❤❤
nuvu legend ra babu
the greatest teacher ❤
great teacher
Bestttt 🙌🙌🙌
YOU ARE GREAT SIR
Hats off for your great efforts
Thank You So Much Sir 🙏
Best teacher in India
Easy and simple explanation
No fear when Vijay sir is here❤❤❤❤
where can i get the notes of this video
Sir revision ke Baad to aur bhi achche se sab kuch clear ho geyi hai and Qs bhi achche se slove ho rehe hai abh.... Thak you so much sir.. One shot mein sab kuch cover karane ke liye...🍀🍀♥♥♥♥♥♥♥♥♥
great session!!
Thank you so much sir ❤❤
DBMS Etna easy koi aur nahi samaja saketa hai
GOD OF DBMS ❤❤
Sir Lecture ki PDF kha milegi and Thank u Sir :)
7:15:00
Is this correct???
Huge respect Sir infact having pain you did not stopped
Vijaysir OP
Thank you sir
Thank you Sir for this great session and teaching the whole subject. Respect 🫡 for taking 10 hours lecture in poor health condition. Take care sir .Hope you will get well soon.
Thank you Vijay Sir ❤
best session sir and huge respect to you sir
❤❤❤❤ hello sir You are legend for gate aspirants
good lecture and good material
koi notes dedou is lecture ka...
विजय सर ❤ is GOAT (Greatest Of All Time)
Special Thanks for Maintaining Great energy from 1st to last. 🙏💐♥️
best revision session , revision ke Baad ekdm achche se sab kuch clear ho gya and .... Thank you so much sir.. One shot mein sab kuch cover karane ke liye... Guru aap jaise ho toh koi topic nhi bachega
Sir , Aap literaly legend hai sir .tabiyaat khrab fir bhi sir aapne choda nahi literally inspiration for all of us # RESPECT FOR YOU SIR 🙏🙏🙏🙏🙏
Thank you so much sir..
THANK YOU VIJAY SIR FOR SUCH AN AMAZING SESSION , TAKING SUCH A LONG CLASS DESPITE OF SEVERAL HEALTH ISSUES MEANS A LOT , JAB APP PADATE HAI TIME KA PATA HI NAHI CHALTA , THANK YOU SIR ❤❤❤.
really sir you are god of coa and dbms
best maharevision
thank you
where can i get the notes of this complete video??
Thankuu so much sir🙏🙏❤❤❤❤❤❤❤
❤❤❤❤best session ever
🙏🙏DHANYAVAAD SIR
best sir
Thank you, so much sir : ) ♥♥♥
3:00:43 resume
Big fan sir❤❤❤❤🎉🎉