00:01 Complete DBMS in one shot with hand-written notes and solved problems 01:50 Difference between data and information 05:27 DBMS helps in managing and maintaining data effectively. 07:10 Disadvantages of Conventional File System 10:39 Concurrent execution and rollback in database transactions 12:32 In DBMS, historical data is heavy and requires large storage, while current data is manageable with small storage. 16:01 DBs are directly connected to the server and data. 17:43 Data security is crucial for preventing unauthorized access and misuse. 21:00 Introduction to DBMS and Schema Architecture 22:34 Explanation of data access for school administration 25:47 Discussing data independence and its types 27:33 Data Independence allows changes in conceptual layer without affecting external layer 30:52 DBMS symbols and notations 32:29 Understanding entities and entity types in database management systems 35:51 A multiple valued array can carry more than one value. 37:31 Understanding keys and relationships in DBMS 40:58 Understanding relationships between tables in a DBMS 42:36 Understanding one-to-many and one-to-one relationships in DBMS 46:01 Understanding parent-child relationships and keys in DBMS 47:47 Understanding primary keys and relationships in DBMS 51:09 Understanding Generalization and Specialization 52:53 Specialization means moving from generalized statement to specific 56:19 Key concepts of candidate keys and primary keys in DBMS 58:32 Primary keys are unique identifiers in a database table. 1:02:01 Students paying fees should have access to school facilities. 1:03:37 Understanding referential integrity 1:07:04 Understanding the impact of changes in the sports table after updating the student table 1:08:44 Understanding deletion, insertion, and update operations in DBMS 1:12:12 Understanding functional dependency in DBMS 1:14:16 Understanding functional dependency in DBMS 1:17:48 Understanding Functional Dependencies and Closure 1:19:23 Understanding functional dependency and transitivity 1:23:01 Understanding closure in DBMS 1:24:46 Understanding candidate and super key in DBMS 1:28:13 Decomposition and Minimal Cover in DBMS 1:29:59 Understanding the need to keep non-redundant FDs 1:33:12 Understanding the elimination of redundant attributes 1:34:43 Understanding the steps of closure in DBMS 1:38:17 Understanding how to navigate through the relational database using FDs 1:40:00 Equivalence of FDs 1:43:31 Understanding lossy decomposition in DBMS 1:45:24 Understanding the concept of loss and lossless decomposition in DBMS 1:49:11 Understanding functional dependencies in DBMS 1:50:47 Understanding FD validation and closure in DBMS. 1:53:53 Understanding functional dependency in DBMS 1:55:27 Understanding the Closure of A with respect to FD 1:58:48 Decompose data into different forms and approaches 2:00:31 Understanding the third approach for efficient usage of tables 2:04:00 Understanding lossless decomposition and normalization forms in DBMS 2:05:50 Understanding Dependencies and Decomposition in DBMS 2:09:30 Understanding the normalization forms in DBMS 2:11:20 Explaining multi value dependency and its implications 2:15:10 Understanding and using database joins effectively. 2:16:46 Explaining different types of joins in DBMS 2:20:00 Understanding cross product in DBMS 2:21:25 Understanding the concept of EquiJoin in DBMS 2:24:48 Understanding the concept of Equi Join and its applications 2:26:24 Understanding table joins in DBMS 2:29:23 Understanding student enrollment in multiple subjects 2:31:03 Explaining left outer join in DBMS 2:34:19 Understanding the concept of exclusive right join 2:35:47 Understanding right table exclusive and full outer join 2:39:05 Understanding relational calculus and query languages. 2:40:44 Understanding the basic operators of DBMS. 2:43:56 Projection and selection combined in DBMS 2:45:32 Understanding the union operator in DBMS 2:48:48 Understanding Union and Cross Product in DBMS 2:50:25 Understanding cross product and set difference in DBMS 2:53:44 Understanding the operant table in DBMS 2:55:37 Introduction to DBMS operations 2:58:45 Understanding and identifying specific values in the result set 3:00:23 Understanding operations and syntax in DBMS Crafted by Merlin AI.
Pehle baar apkha channel ka video dekha aur content bahoot acha hai, college abhi start hua 3rdweek phir bhi dekh tha hu video 11:19 kho start Kiya I try my best to complete asap aaj night marunga 3 am Tak khatam ho jayga honhe ke badh comment karunga wapas ❤
COMPLETED THE VIDEO AT 12 a.m. finalllyyyyyyyyy......THANKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK YOUUUUUUUUUUUUUUUUUUUUUUUUU SIRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR..........IT WAS REALLY HELPFUL.......................😁😁😁😁😁😁😄😄😄😄😄😄😄😄😄🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Bhai ap bauth mast padhate ho yaar... Mai bauth pareshan tha kyuki na maine dbms thik se padha tha aur na hi notes tha mere pas... Phir app mile... 🙏🙏🙏🙏
bhaiya pure btech meine aapki videos se padha h .... kaash aap ye video pehle bna dete toh kitna saara mera kaam easy ho jaata becoz i reallly liked the way you teach
B tree, nodes hote h, node/block pointer hote h aur bich mei record pointer aur search pointer hote h, leaf ka no child node so no block pointer B+ mei no data /record pointer in non leaf nodes Pnext -> pointer to next lead node
Im your new subscriber sir 😊Thanku sir ❤for dbms one shot and free notes.. compiler ke bhi notes provide kr djija..or aage ke subjects likhe oops machine learning or constitution ke bhi one shot bana dijia exam se phle plz ... reply and like my comment sir for motivation ..😅
Arrey sir g love you from Pakistan boht zyada love you hogya. I'm from FAST University jisko ragra university bhi kaah jaata hy lekin aapki wajah sy studies halwa bngyi sir
Thank for teaching computer Science Fundamentals, First teachers day after getting job
Great support brother. Appreciate it from the one who can't pay.
00:01 Complete DBMS in one shot with hand-written notes and solved problems
01:50 Difference between data and information
05:27 DBMS helps in managing and maintaining data effectively.
07:10 Disadvantages of Conventional File System
10:39 Concurrent execution and rollback in database transactions
12:32 In DBMS, historical data is heavy and requires large storage, while current data is manageable with small storage.
16:01 DBs are directly connected to the server and data.
17:43 Data security is crucial for preventing unauthorized access and misuse.
21:00 Introduction to DBMS and Schema Architecture
22:34 Explanation of data access for school administration
25:47 Discussing data independence and its types
27:33 Data Independence allows changes in conceptual layer without affecting external layer
30:52 DBMS symbols and notations
32:29 Understanding entities and entity types in database management systems
35:51 A multiple valued array can carry more than one value.
37:31 Understanding keys and relationships in DBMS
40:58 Understanding relationships between tables in a DBMS
42:36 Understanding one-to-many and one-to-one relationships in DBMS
46:01 Understanding parent-child relationships and keys in DBMS
47:47 Understanding primary keys and relationships in DBMS
51:09 Understanding Generalization and Specialization
52:53 Specialization means moving from generalized statement to specific
56:19 Key concepts of candidate keys and primary keys in DBMS
58:32 Primary keys are unique identifiers in a database table.
1:02:01 Students paying fees should have access to school facilities.
1:03:37 Understanding referential integrity
1:07:04 Understanding the impact of changes in the sports table after updating the student table
1:08:44 Understanding deletion, insertion, and update operations in DBMS
1:12:12 Understanding functional dependency in DBMS
1:14:16 Understanding functional dependency in DBMS
1:17:48 Understanding Functional Dependencies and Closure
1:19:23 Understanding functional dependency and transitivity
1:23:01 Understanding closure in DBMS
1:24:46 Understanding candidate and super key in DBMS
1:28:13 Decomposition and Minimal Cover in DBMS
1:29:59 Understanding the need to keep non-redundant FDs
1:33:12 Understanding the elimination of redundant attributes
1:34:43 Understanding the steps of closure in DBMS
1:38:17 Understanding how to navigate through the relational database using FDs
1:40:00 Equivalence of FDs
1:43:31 Understanding lossy decomposition in DBMS
1:45:24 Understanding the concept of loss and lossless decomposition in DBMS
1:49:11 Understanding functional dependencies in DBMS
1:50:47 Understanding FD validation and closure in DBMS.
1:53:53 Understanding functional dependency in DBMS
1:55:27 Understanding the Closure of A with respect to FD
1:58:48 Decompose data into different forms and approaches
2:00:31 Understanding the third approach for efficient usage of tables
2:04:00 Understanding lossless decomposition and normalization forms in DBMS
2:05:50 Understanding Dependencies and Decomposition in DBMS
2:09:30 Understanding the normalization forms in DBMS
2:11:20 Explaining multi value dependency and its implications
2:15:10 Understanding and using database joins effectively.
2:16:46 Explaining different types of joins in DBMS
2:20:00 Understanding cross product in DBMS
2:21:25 Understanding the concept of EquiJoin in DBMS
2:24:48 Understanding the concept of Equi Join and its applications
2:26:24 Understanding table joins in DBMS
2:29:23 Understanding student enrollment in multiple subjects
2:31:03 Explaining left outer join in DBMS
2:34:19 Understanding the concept of exclusive right join
2:35:47 Understanding right table exclusive and full outer join
2:39:05 Understanding relational calculus and query languages.
2:40:44 Understanding the basic operators of DBMS.
2:43:56 Projection and selection combined in DBMS
2:45:32 Understanding the union operator in DBMS
2:48:48 Understanding Union and Cross Product in DBMS
2:50:25 Understanding cross product and set difference in DBMS
2:53:44 Understanding the operant table in DBMS
2:55:37 Introduction to DBMS operations
2:58:45 Understanding and identifying specific values in the result set
3:00:23 Understanding operations and syntax in DBMS
Crafted by Merlin AI.
Respect boss !!!
🫡
Itni mahenat ke bad bhi like nhi mila 😅😂
@@AbhivanyUyared bhai usne Ai ki help se kiya h khud se nhi 😂
@@yateesh_1234😂😂😂😂
Sir aapki wajah se maine Puri Btech complete Kari hai. Thank you sir. .... You are just awesome 😎😎
Aktu dbms complete video ha ye bro ?
@@anshuxman9800yes brother
Ha
Bhai job lagi kya?
Btu University ke liye bhi video upload kr dijiye 🙏
Clear & Easy Explanation, to the Point & Concise....Amazing Teaching Sir
The best one shot video i have ever seened before of DBMS ❤❤❤
Sir my exam is tomorrow and i did everything on time, thanks sir
Hello Bhai tumne pehle nhi pada tha kya Dbms?
@@whoravu pehle padha tha kya?
Hnji bhai
Thanks
Waah!! Subhanallah
Kesi he ye video acha samajaya he ?
पाय लागू गुरु देव
5:36:10
Love you mere guru dev
Thanks
Pehle baar apkha channel ka video dekha aur content bahoot acha hai, college abhi start hua 3rdweek phir bhi dekh tha hu video 11:19 kho start Kiya I try my best to complete asap aaj night marunga 3 am Tak khatam ho jayga honhe ke badh comment karunga wapas ❤
Abhi start Kiya wapas tab so Gaya mai 😂4 din badh
@@ankitmatade4710 koi baat nhi ,ab complete kiya ki nhi🤣
@@sonamsinha406 Ha par last ke 1hr skip Kiya not enough to clear sem with good marks
Thank You so much sir. Please come up with some development stuffs like(frontend, backend) . One shot of any language.
Best One Shot Video... Best Revision Notes... Best Teacher. The entire student community owes you a lot for their semester exams. ❤🔥❤🔥❤🔥
COMPLETED THE VIDEO AT 12 a.m. finalllyyyyyyyyy......THANKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK YOUUUUUUUUUUUUUUUUUUUUUUUUU SIRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR..........IT WAS REALLY HELPFUL.......................😁😁😁😁😁😁😄😄😄😄😄😄😄😄😄🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Kash pehle search Kiya hota to or better kar pata 😊
Thank you desi language me samjhane k liye ❤
5:35:28 yes sir aap v bohot try karte hai humlog v bohot sare pyar denge apka mehnat ko bass sir aap aise hi accha kam kijiye❤
Bhai ap bauth mast padhate ho yaar... Mai bauth pareshan tha kyuki na maine dbms thik se padha tha aur na hi notes tha mere pas... Phir app mile... 🙏🙏🙏🙏
Thank you so much, sir, for this fantastic explanation of DBMS in one shot! I really appreciate your clear and concise teaching style.
You're my motivation to to things in an easy way , Thanku Sir to make Our lives Easier 🙏🏻♥️
Doubt( 42:53 )
In the concept of degree/cardinality
1) one to one
Should not it be many to one
Because multiple students can enroll in same course
personal things cannot be information but just data to someone but for someone it can be concidered as information if its about social engineering
Sir, DBMS topic explained in a very good and efficient manner with examples. Thanks !
3:52:32
👍👍👍👌👌👌
sir you are doing great work . bahut hi achhe way me sab kuch samjhaya aapne ..
Aapne first time padha dbms? Pehle kahi nhi padha??
Sirji You Are the best mentor i have ever seen in my life
Thank you sir . I don't know if I could thank you enough but I try my best by recommending your channel to everyone.
Pehchana? Pehchano ge kese, 5 minutes engineering ab 5 hours Engineering jo bangaya hai😂😂😂
Àa
Waah guru XDXDXD
bro wanna learn dbms in 5 mins
Amazing,Excellent lecture bhaiya❤🔥
BEST TEACHER EVER FOR ANY SUBJECT
1:43:45 2:04:29
Kal exam hai Aaj me dekh rahi hu👍and clear explanation thank you sir 😅
is this video really helpful and enough ?
Exam kesa gya ?
Bhaiya aap bahut asan bhasa me samjhate hue ❤❤❤❤❤ thank you bhaiya
bhaiya pure btech meine aapki videos se padha h .... kaash aap ye video pehle bna dete toh kitna saara mera kaam easy ho jaata becoz i reallly liked the way you teach
best video ....tommorow is my exam and i did not prepared for that but now i am fully confident ...thank you so much sir....thankssss a lot❤❤❤❤
Yes
kesa gaya aapka exam , is this video is worth watching for my final semester exams , please tell me nandini ji 🙏
Sir please make one shot videos of all cs subjects especially related to placements!
Sir ji aap ki vje se mere exam meh ek raat phele saara syllabus complete ho jata hai thank you sir
3:06:50 relational calc for all, there exists
bahi.isme sb cover h na
B tree, nodes hote h, node/block pointer hote h aur bich mei record pointer aur search pointer hote h, leaf ka no child node so no block pointer
B+ mei no data /record pointer in non leaf nodes
Pnext -> pointer to next lead node
Ok
Award deserving teacher from engineering gang
Great work sir keep it up 💪
2:39:00
👍👍
Are gazab sir .
Such an amazing teacher
love you SIr
I score more 60 in DBMS exam. Thank You Sir
सर ऐसी ही वीडियो Data Structure, SAD, Software engineering, Networking, par बनाओ plz
no doubt .....Best
very thankful to make such videos that help students one night before exam.
thanks sir aaj university paper tha apki wajeh se poora 100 marks kr paya ache se
Bhai Pehle Nhi Padha Tha Kya DBMS Tumne?
Bhai kyu jhoot bolra. Is content se 100 percent koe nhi kr skta😂😂.
Sir apni I'd se hi kre hai comment 😂😂@@sushantkumar9883
@@sushantkumar9883how did you study dbms then?
YOUR WAY OF TEACHING IS AWESOME SIR .
Thank You Sir 💗
Your way of teaching makes every complex topics into simpler ones....thank you sir❤
Yess😊
1:14:07
Appreciate to your work sir, Handwritten notes & explanation is excellent❤
Sir you are lifesaver. God Bless You
🙏
THANKU SIR .networking ka class provide krde.
Radhe radhe 🎉
sir ur happy face , fills happiness in us thankyou
Outstanding video ❤ sir ji jo chiz hame university nahi sikhaya gayi thi wohh sikha di soo thank-you soo much for your notes thank you sir ❤❤❤
thank your sir for making this video it helps a lot 💕
Guruji ka Gyaan mil chukka hai ab bass Aashirvad chahiye
Sir You are great ❤
Teaching of way impressive
thankyou verry much sir you are came in those teachers who can easily give education to anyone and will make their carriers bright
1:34:55 sir 3rd step mein wo message kyu popup hua hai "closer, AC is equal to ABCD?
thanku sir
kal exam hai mera , almost saara cover ho gaya
kaisa rha exam?
sufficient hai kya exam pov se?
This guy is humshakal of codewithharry
Mera exam h next month se thank u so much
Sir, Please do on Operating Systems and Computer Networks...
thank you sir, from west bengal
thanku sir
Understood everything!
thanx a lot for this video can you make a video of COMPUTER ORGANISATION AND ARCHITECTURE
Love you sir
❤❤🙏🏻🙏🏻🙏🏻🌟🌟🌟
Thank you for the video
Im your new subscriber sir 😊Thanku sir ❤for dbms one shot and free notes.. compiler ke bhi notes provide kr djija..or aage ke subjects likhe oops machine learning or constitution ke bhi one shot bana dijia exam se phle plz ... reply and like my comment sir for motivation ..😅
Awesome teacher 👏 😎👍❤
Amazing video 👍
Thank youuu so muchhh sirr❤ it's really very helpful 😊 keep doing it 🙏🏻😍and the handwritten notes are jast woww🫰🏻
Nice sir aap bohot chagle shikvta ❤❤❤❤❤
Arrey sir g love you from Pakistan boht zyada love you hogya. I'm from FAST University jisko ragra university bhi kaah jaata hy lekin aapki wajah sy studies halwa bngyi sir
Sir maja aa gya 🎉🎉padhne ke bad
Apne to far di sir Kiya hi video hain maja a geya sare mahine Bina pade apke video dekh ke paper far di ❤❤
Thank you sir for making these videos...helped me a lot
Great lecture ❤
Relational database shows relationship between rows and columns
Entities are rows and
Nice content .keep it up....I have cleared my all the doughts after watching your video thanking you
Thank you sir, for this amazing session....
2:27:50 sir yahan pe marks wala attribute kyun nahi likha aapne ?
Plz anyone explain?
Sir g apki hasne ka andaj bhut pyara h. Plzzz or videos laiye
Sir ye sem bhi ache no. Final aa gya tnx 😊
2:08:00 mi mujhe kuch samjh ni ayaa BCNF
very nice it help me understand the concept
20:00
great teaching sir!
Sir, barpoor quality content in this vidio . No good college will provide this type of notes 🎓⭐
5 min engineering❌
5 hrs engineering ✅
Osm bhaiya Ji😎😎
sir kya aap knowledgegate se dekh k pdha rhe ho, kyuki sir apke example same ho rhe h 1:29
Dayawad Guru Ji ❤️💪⚔️🔱🕉️
Amazing session
Best teacher
only teacher who is too powerful for 2x speed.
KON KON 2024 Mai ye video exam se pahle dekh rha hai 😅😢😢
Mera exam bhi parso hai , par aaj aur kal bhi yhi video dekhunga 😅😅