00:01 Complete DBMS Data Base Management System in one shot 02:05 Understanding the importance of data in a database management system 06:20 DBMS is software facilitating efficient data storage, retrieval, and management of databases. 08:27 DBMS is a complete system for managing databases in a professional manner 12:45 Introduction to DBMS and Data Independence 15:09 DBMS Data Base Management System explained in a nutshell. 19:04 DBMS covers topics like multimedia database, deductive database, temporal processing, and access methods. 21:07 Understanding Database Architecture 25:03 Understanding anti-relationship diagram and its importance in database management 26:59 DBMS data can be categorized into tangible and intangible 31:18 Understanding single value and multi-valued attributes in DBMS. 33:11 Representing multi-value attributes by separate tables in a relational model 37:25 Representing relationships in a DBMS 39:45 Understanding the importance of giving relationships a unique name 43:50 Understanding the concept of total participation and partial participation in DBMS 46:00 Explained the concept of separate table in a relationship model 50:07 DBMS is a relational database management system 52:11 DBMS covers topics like cardinality, data types, and atomic values. 55:52 The branch information is dependent on student information. 57:44 Managing data redundancy in DBMS 1:01:45 Normalization is the process of refining tables and establishing relationships between them. 1:03:41 Understanding dependency and normalization approach in DBMS 1:07:35 Understanding functional dependency in DBMS. 1:09:29 Closures are important in DBMS 1:13:17 DBMS rules: Reflexivity Augmentation and Transitive 1:15:27 Explaining dependencies and comparing in DBMS 1:19:37 Decomposition rule in DBMS 1:21:29 Understanding the hierarchy of accessing data in DBMS 1:25:27 Understanding functional dependency in DBMS 1:27:27 Differentiating between Super Keys and Candidate Keys in DBMS. 1:31:18 The prime attribute is a member of at least one candidate's key and is important in database normalization. 1:33:13 Primary key attributes cannot have null values and must be unique. 1:37:28 Understanding normalization and its importance in DBMS. 1:39:25 First Normal Form is an initial step of database normalization. 1:43:26 Partial dependency in DBMS 1:45:27 Redundancies are avoided through normalization 1:49:34 Understanding Dependency in DBMS 1:51:37 DBMS Data Base Management System understanding and definition 1:55:50 Understanding multi value dependency in DBMS 1:57:39 The concept of multi-value dependency in DBMS 2:01:29 Multi Value Dependency in DBMS 2:03:23 Normalization and decomposition in DBMS 2:07:18 Lossless decomposition ensures no data loss 2:09:16 Table decomposition and merging in DBMS 2:13:16 Decomposition is lossless 2:15:23 Understanding decomposition in DBMS and its impact on lossless data 2:19:31 Indexing makes data retrieval faster 2:21:23 Data organization order and its impact 2:24:57 Indexing in a database helps in quickly searching for specific terms. 2:26:38 Indexing is important in a database management system 2:30:23 Understanding the concept of blocks and binary search in DBMS 2:32:09 Understanding indexing in a database management system 2:36:02 Indexing in DBMS with sorted files 2:38:05 Index file management in DBMS 2:41:49 Secondary indexing in DBMS 2:43:37 Clustered indexing ensures every value gets an entry. 2:47:14 Explanation of B tree insertion process. 2:49:14 DBMS uses SQL as a query language and relation model for data management. 2:53:09 DBMS Data Base Management System 2:55:25 Types of operators in DBMS 2:59:18 Understanding DBMS Account Numbers and Balances 3:01:30 Applying union operation on tables to retrieve the names of customers with either a deposit or a loan 3:05:41 Catersian product is used when data is in different tables. 3:07:46 Understanding table names and renaming in DBMS. 3:11:42 Division in DBMS 3:14:08 DBMS is a database management system that organizes and manages data. 3:18:02 Data Definition Language, Data Manipulation Language, Data Control Language, Data Query Language, and View Definition are the key components of DBMS 3:20:00 Creating tables and specifying data types in DBMS 3:24:02 Understanding the concept of tables and data manipulation in a DBMS 3:26:10 Understanding the insertion and deletion commands in DBMS 3:30:06 SQL supports duplication but provides a keyword called 'Distinct' to remove duplication. 3:32:01 DBMS Data Base Management System in one shot - Hindi Crafted by Merlin AI.
@@spectre5002 Hey buddy, at the end of his comment you can clearly see "Crafted by Merlin". So there are basically AI tools that can summarize the whole video, tell you the key points, provide you the timestamps and much more just by pasting the link of the video....👍😉
Hello Sir, I am working as a data engineer for 3 years now and just came across this video because of my subscription during the college days. Funny thing is that I had electrical engineering and hence had no course on DBMS which is actually informative and relavent to the IT industry. After watching your video, I was able to fill the knowledge gaps. I am very glad that you share your knowledge over the internet so that motivated people who are interested in the subject are able to learn, no matter whether life decided for them or not. Hope that God keeps enabling you to continue on this journey so that future generation is never helpless. Real respect and sincere thanks!
Your teaching is truly exceptional, and I wanted to express my gratitude. Your lectures are not only informative but also incredibly relatable, which keeps me engaged even during lengthy sessions. Thank you so much!
You are very welcome dear, glad to know that you are liking our videos❤ Do like, subscribe & share the video, also let me know which course do you want next?
Namaste sir, you are the best, the content you make is precise and to the point. During my college days everyone used to study only from your videos and write the exams. Today I work in a corporate but Even today I am watching this video for preparing for the interviews. You are a motivation. I hope to see more amazing content coming from your side.
2:15:35 it is lossy decomposition as we can get redundand data... B is common in R1 and R2 but B is not a key... A is a key but not common in R1 and R2... also, nothing is common in R3 and R4, so joining it would create redundancy...
This is my request on the behalf of all the gate aspirants to Sanchit sir that please continue the "zero to hero live class for gate 2024 at 6 pm" that we started six months before in February but was not updated after 25th lecture. We badly needs those sessions sir please continue that playlist...it was a life saving playlist for us!🙏🙏
Sir your efforts are highly appreciated... It's a tough work to make such informative ppts for students and then explain all of it in continuous manner... Thank you so much Sir ❤❤
As i said today was my semster exam of dbms and it went well! i was not feeling confident about todays exam but still i went well this implies that the one shot videos provided by sir is fair enough to pass semester exams! thankyou so much sir helped me a lot! . . . . . . . . . This was my second exam the next exam is of DAA and that too im going to prepare from this channel(one shot) lets see what happens and will share more information there!!
Thank you sir for these amazing knowledgeable contents. Sir can you please provide us some important course Like Natural Language Processing, Soft Computing, Machine Learning. These kinds of courses are very important for us and if you make course video on these it will be very very helpful to us. Please if you getting time then make videos on these topics. We love the way of your teaching and all topics are easily understandable by you. Thanks again for all efforts.🙂
You're most welcome dear @Lucky❤ Sure will definitely try to work on these topics, stay connected & do like, subscribe & share our videos. Keep learning👍😊
" Mein kar deta hoon mera maan nahi manega " 1:54:21 .,,, what a jewel of a teacher u are . Thank u so much , from past 3 semesters u have been my life saviour , my current cgpa is 8.6 and all credits goes to u
This is one of the best one shot that covers all the important topics and Guess what ... My end sem paper had at least 95% of questions from this one shot .
Good afternoon sir, I am a die heart fan of your teaching sir. Believe me I didn't even touch the book and go through only by your online class and passed the dbms subject. You are really providing a class content..
India ko aap jaise logo ki jarurat h sir.. agar aap h tho ham h.. shayad future mein ham bhi aap jaise bane aur jyada se jyada eduaction ko phailaye ta ki hum india ko bana sake an educated country..! And ye lecture to bht bbdya tha. Thankyou so much for making such videos... jo hme aap jaise ban ne ki prerna deti h aur inspiration bhi..
Best ever video in RUclips, All concepts understand with in 5:30 hours , college professor takes thousands hours for the teaching these things but that concept is not explained in the easy way Thanku u sir❤🎉
@@saver_x_28 bhaii common sense naam suna hai... In general sense kya raha hai sentence se ye important hai ... Aur hyperbole ke nam ki bhi cheez hote hai ....jise har aam ensaan use krta hai 🙂.. rhi batt yrr Bhai tum khas ho .. Bhai tumhe dekhkar mujhe 3 idiot ki movie yad gyi jisme ek clip jisme Chatur speech de Raha tha ..chamtkar hi chamtkar ho raha hai ...😄😅
Thankyou sir for this wonderful explanation Sir i have an query that at 4:54:43 in definition of non recoverable (commit and abort operation of Ti appear "AFTER" Tj) sir i think it is 'after' rather than 'before.'
i think this is the best video I have ever seen on dbms (considering examination purpose), it will clear your major theory concepts. highly recommended🙏
Jai jinendra 🙏 Sir ur much appreciated much precious.. Till now i am not able to understand DBMS but now it is completely understand .. Ur all video are precious thank u for for uploading best content 😊
Very Lucid one shot video sir. This kind of series will be among the top choice of students. Please continue the series for other subjects like TOC, CD etc. if possible.
hello sir the homework question of lossy/loseless decompostions has an error sir which says that question is with relation R(A,B,C,D,E) but the relations given are R1(A,B),R2(B,C),R3(A,B,C,D),R4(E,G) THE ERROR IS R4(E,G) the main relation was A to E but the R4 has G? that was my request and thanks again for this very understandable lecture
I'm from Andhra Pradesh sir.... I loved your video on the operating system. I just studied it the night before the semester exam ...I just loved it. I have to take dbms exam next ,let's check how would i get on with that
@ 1:20:23 Sir said "Jab tak koi cheez hamare paas hai to hame pata nahi chalta but jab door ho jaati hai jab chalta hai". Mai sahi bataau to mujhe sir 'May I Come In Madam' ke 'Sajan' ki tarah lagte hai. Or sir ye aap ke liye ek kaam ki baat :- Sir, aap 'Sanjana Madam' se door chale jaaiye tabhi madam ko aapki value pata chalegi.
Sir, I love you sir 💓 & big big thanks for this. You went on and on for straight five and a half hours. Continuously speaking without even taking a water break! Hats off to you sir. I can guarantee most of us will not complete this in one setting but you completed everything while speaking continuously for 5 hours! Huge respect!🎉💯
You're most welcome Vishal! Keep learning & supporting! Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍
5:33:29 Completed! It's impressive how you managed to cover almost everything in just 5 hours and 30 minutes, given the amount of content delivered usually requires much more time. Thanks a lot, # G.O.A.T Sanchit Sir. ❤❤🙏🙏
Sir you are superb as you made a one shot of software enginnering on my request so thanks for it ❤.Also sir try for computer oriented numerical methods one shot also if possible ❤❤
I have a question sir, is there any difference in syllabus between DBMS In Hindi (Complete Playlist) available on RUclips and the "Database Management System" course on your website. I am a bit confused about which one will i choose. Sir could you please clarify
DBMS course on website is a complete course according to GATE syllabus, includes previous year questions, practice tests & grand tests also. But, no compulsion to buy a paid course, you can always refer our DBMS playlist, PYQs & tests are not included in this.
Thank you, so much sir this valuable content giving us . this ( DBMS ) content fully helpful for semester exam and best thing is all syllabus is match my acedmic syllabus most of the student watch your lecture beacuse its very helpful , again very thank you " great Sanchit sir "
1:07:35 I've learned this much from a prime institution, but honestly, I didn't get the clarity I got here. I must say, "Try a demo before you trust." Nevertheless, when it comes to Sanchit Sir, especially for DBMS, I have full trust. He's the G.O.A.T of DBMS for sure. It's not easy to teach the essence behind every single topic, from scratch, with 100% clarity. Thanks a lot, Sir. Lots of love and light always!!! ❤🔥🙏 ~ MPH student
Thank you so much for your valuable feedback dear! Am glad that you are liking our content. Stay connected for more videos & do share the video with your friends if you find it helpful.
sir one topic which is left in this whole video as i have infdormed i am preparing for my semster from your channel i have feel that in unit 4 one topic DEADLOCK was not discussed ! just sharing it so otherr peoples may get informed and thankyou soo much!
God!! I never knew that I would learn dbms in such wonderful way..Thank youu Sir bilkul sahi time pr mujhe ye video mil gya i hope exam me ache marks aayenge iss baar😇👌👌
I am from West Bengal sir...I watch your videos according to my subjects and they are very helpful to understand the topic very well...and the notes are also very helpful for my exams...Thank you so much sir...
Glad to know content is helpful Ishita, thank you for following the content, do share video with your friends & stay connected for more upcoming videos👍
For complete content on Computer Science, check out the course link: tiny.cc/allcomputersciencecourse
sir is this for bba ca first year dbms subject..............................
Nice Sir😊😊😊
i think youtube should declare this video as the best video lecture for DBMS...great content sir .....thanks from the buttom of my heart...
Thank you so much Vishnu😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍
Okkkk sirrrr....
where to get notes?
No sorry, Keys ke baare me to padhaya hi nhi iss video me 😢😢😢
00:01 Complete DBMS Data Base Management System in one shot
02:05 Understanding the importance of data in a database management system
06:20 DBMS is software facilitating efficient data storage, retrieval, and management of databases.
08:27 DBMS is a complete system for managing databases in a professional manner
12:45 Introduction to DBMS and Data Independence
15:09 DBMS Data Base Management System explained in a nutshell.
19:04 DBMS covers topics like multimedia database, deductive database, temporal processing, and access methods.
21:07 Understanding Database Architecture
25:03 Understanding anti-relationship diagram and its importance in database management
26:59 DBMS data can be categorized into tangible and intangible
31:18 Understanding single value and multi-valued attributes in DBMS.
33:11 Representing multi-value attributes by separate tables in a relational model
37:25 Representing relationships in a DBMS
39:45 Understanding the importance of giving relationships a unique name
43:50 Understanding the concept of total participation and partial participation in DBMS
46:00 Explained the concept of separate table in a relationship model
50:07 DBMS is a relational database management system
52:11 DBMS covers topics like cardinality, data types, and atomic values.
55:52 The branch information is dependent on student information.
57:44 Managing data redundancy in DBMS
1:01:45 Normalization is the process of refining tables and establishing relationships between them.
1:03:41 Understanding dependency and normalization approach in DBMS
1:07:35 Understanding functional dependency in DBMS.
1:09:29 Closures are important in DBMS
1:13:17 DBMS rules: Reflexivity Augmentation and Transitive
1:15:27 Explaining dependencies and comparing in DBMS
1:19:37 Decomposition rule in DBMS
1:21:29 Understanding the hierarchy of accessing data in DBMS
1:25:27 Understanding functional dependency in DBMS
1:27:27 Differentiating between Super Keys and Candidate Keys in DBMS.
1:31:18 The prime attribute is a member of at least one candidate's key and is important in database normalization.
1:33:13 Primary key attributes cannot have null values and must be unique.
1:37:28 Understanding normalization and its importance in DBMS.
1:39:25 First Normal Form is an initial step of database normalization.
1:43:26 Partial dependency in DBMS
1:45:27 Redundancies are avoided through normalization
1:49:34 Understanding Dependency in DBMS
1:51:37 DBMS Data Base Management System understanding and definition
1:55:50 Understanding multi value dependency in DBMS
1:57:39 The concept of multi-value dependency in DBMS
2:01:29 Multi Value Dependency in DBMS
2:03:23 Normalization and decomposition in DBMS
2:07:18 Lossless decomposition ensures no data loss
2:09:16 Table decomposition and merging in DBMS
2:13:16 Decomposition is lossless
2:15:23 Understanding decomposition in DBMS and its impact on lossless data
2:19:31 Indexing makes data retrieval faster
2:21:23 Data organization order and its impact
2:24:57 Indexing in a database helps in quickly searching for specific terms.
2:26:38 Indexing is important in a database management system
2:30:23 Understanding the concept of blocks and binary search in DBMS
2:32:09 Understanding indexing in a database management system
2:36:02 Indexing in DBMS with sorted files
2:38:05 Index file management in DBMS
2:41:49 Secondary indexing in DBMS
2:43:37 Clustered indexing ensures every value gets an entry.
2:47:14 Explanation of B tree insertion process.
2:49:14 DBMS uses SQL as a query language and relation model for data management.
2:53:09 DBMS Data Base Management System
2:55:25 Types of operators in DBMS
2:59:18 Understanding DBMS Account Numbers and Balances
3:01:30 Applying union operation on tables to retrieve the names of customers with either a deposit or a loan
3:05:41 Catersian product is used when data is in different tables.
3:07:46 Understanding table names and renaming in DBMS.
3:11:42 Division in DBMS
3:14:08 DBMS is a database management system that organizes and manages data.
3:18:02 Data Definition Language, Data Manipulation Language, Data Control Language, Data Query Language, and View Definition are the key components of DBMS
3:20:00 Creating tables and specifying data types in DBMS
3:24:02 Understanding the concept of tables and data manipulation in a DBMS
3:26:10 Understanding the insertion and deletion commands in DBMS
3:30:06 SQL supports duplication but provides a keyword called 'Distinct' to remove duplication.
3:32:01 DBMS Data Base Management System in one shot - Hindi
Crafted by Merlin AI.
THANX
how free are you?
@@spectre5002 Hey buddy, at the end of his comment you can clearly see "Crafted by Merlin". So there are basically AI tools that can summarize the whole video, tell you the key points, provide you the timestamps and much more just by pasting the link of the video....👍😉
@@spectre5002 bhai aap sachmein computer science field se belong karte hoo na ??
Lag toh nahi raha. Shayad iske baap ne management quota se karaya hoga admission ya phir iska interest nahi hoga.@@jarvis9263
Hello Sir, I am working as a data engineer for 3 years now and just came across this video because of my subscription during the college days. Funny thing is that I had electrical engineering and hence had no course on DBMS which is actually informative and relavent to the IT industry. After watching your video, I was able to fill the knowledge gaps. I am very glad that you share your knowledge over the internet so that motivated people who are interested in the subject are able to learn, no matter whether life decided for them or not. Hope that God keeps enabling you to continue on this journey so that future generation is never helpless. Real respect and sincere thanks!
Thanks a lot Abhisht for your valuable feedback, glad to know our content is helpful to you, keep learning, supporting & stay connected👍😊
@@KNOWLEDGEGATE_kg From where i can get notes?
7hrs left "Sem exam"😅
Aree baba 😲😮
12 hours for me🤣🤣
Bhot h ye to 😂
7 hrs 30 min left for sem exam🤣😭
Same here 😂
Sir , my answer : " AC->B , A->C, B->C " of canonical cover question after removing redundancy . Is this correct or not ?
mine answer is also same
AC->B is also redundant kindly check
No you can't get to B if you remove AC->B
@@shriramjisewak from a we can reach b
B -> C
A -> BC
1.04.32
Maruti Alto 800. ...
Maruti Dzire. ...
Maruti Swift. ...
Maruti Eeco. ...
Maruti Alto K10. ...
Maruti Wagon R.
Your teaching is truly exceptional, and I wanted to express my gratitude. Your lectures are not only informative but also incredibly relatable, which keeps me engaged even during lengthy sessions. Thank you so much!
You are very welcome dear, glad to know that you are liking our videos❤ Do like, subscribe & share the video, also let me know which course do you want next?
@@KNOWLEDGEGATE_kg c , c++ , python , core java
@@KNOWLEDGEGATE_kg rpsc programmer course we need
Namaste sir, you are the best, the content you make is precise and to the point. During my college days everyone used to study only from your videos and write the exams.
Today I work in a corporate but Even today I am watching this video for preparing for the interviews.
You are a motivation. I hope to see more amazing content coming from your side.
Great, am glad to know this @Shivam, thanks a lot for your valuable feedback, keep learning & do like & share our videos❤
2:15:35 it is lossy decomposition as we can get redundand data... B is common in R1 and R2 but B is not a key... A is a key but not common in R1 and R2... also, nothing is common in R3 and R4, so joining it would create redundancy...
yes same here
Subah 10 baje exam ke liye abi video start karne wale kitne hai
Some next level explanation in limited time covering all topics thank you so much 🙏🙇♂💖
Glad you liked it @Sahil❤ Do like, subscribe & share the video, also let me know which subject do you want next?
@@KNOWLEDGEGATE_kg JAVASCRIPT TUTORIALS
🥺
This is my request on the behalf of all the gate aspirants to Sanchit sir that please continue the "zero to hero live class for gate 2024 at 6 pm" that we started six months before in February but was not updated after 25th lecture.
We badly needs those sessions sir please continue that playlist...it was a life saving playlist for us!🙏🙏
Sure dear, will consider your suggestion, stay connected & keep learning👍😊
Hello sir, kash aap hamlog k time video dete very useful. 2023 pass out. Love from Bihar.
thanks a lot sir. These one shot lectures for semester exams, when we need them at any cost are extremely helpful
Glad to know they are helpful, all the very best for your exams, keep learning & supporting👍😊
Sir your efforts are highly appreciated...
It's a tough work to make such informative ppts for students and then explain all of it in continuous manner...
Thank you so much Sir ❤❤
You're welcome, keep learning & supporting & stay connected for more upcoming contents👍
Thank you so much sir...I am eagerly looking for CN also😘🙏
CN is the next subject, it will be uploaded within a week, Keep learning and let us know which subject do you want after CN?
@@KNOWLEDGEGATE_kg thank you so much sir... Compiler Design after CN🙏
Thanks a lot Sir 🙏 Compiler Design after CN Sir
sir plz compiler design after CN
Compiler design 😊
Important hits(will update as I cover complete video) :
Flie System vs DBMS 7:58
DBMS Architecture 21:38
Lossy/Lossless Dependency Preserving Decomposition 2:03:26
Dependency Preservation 2:16:23
Triggers 4:05:31
ACID Properties 4:26:39
Schedules Summary 5:00:37
Bro can you please update
🤣🤣@@vinayakgupta6105
bhai update karo!
padhle bhai
@@sahilxd440😂😂😂😂
more power to you sir !! genuinely wanted to say thanks . your content and teaching is truly gold .
Thank you so much Madhav for your kind & generous feedback, stay connected & keep learning❤
As i said today was my semster exam of dbms and it went well!
i was not feeling confident about todays exam but still i went well this implies that the one shot videos provided by sir is fair enough to pass semester exams!
thankyou so much sir helped me a lot!
.
.
.
.
.
.
.
.
.
This was my second exam the next exam is of DAA and that too im going to prepare from this channel(one shot) lets see what happens and will share more information there!!
bro what is your college name and what are you doing i mean course?
Glad to hear that, all the best for your upcoming exams, keep learning👍😊
@@user-tb9un3ro6u brother my Clg is HBTI kanpur and course is Btech(CSE)
What happened bro then?
Thank you sir.Your normalisation part was fantastic , i finally got that clarity .
Glad to know Krish, keep learning👍😊
Thank you sir for these amazing knowledgeable contents.
Sir can you please provide us some important course Like Natural Language Processing, Soft Computing, Machine Learning. These kinds of courses are very important for us and if you make course video on these it will be very very helpful to us.
Please if you getting time then make videos on these topics.
We love the way of your teaching and all topics are easily understandable by you.
Thanks again for all efforts.🙂
You're most welcome dear @Lucky❤ Sure will definitely try to work on these topics, stay connected & do like, subscribe & share our videos. Keep learning👍😊
@@KNOWLEDGEGATE_kg Thank you so much sir 😊🙂
" Mein kar deta hoon mera maan nahi manega " 1:54:21 .,,, what a jewel of a teacher u are . Thank u so much , from past 3 semesters u have been my life saviour , my current cgpa is 8.6 and all credits goes to u
Excellent, keep learning & stay connected for more upcoming content❤
this man made me to pass university exams every time , u r jusprit bumbrah of my life
Thanks sir Only one video have full dbms solution wonderful effort
From Pakistan🇵🇰
Punjab ❤
Thank you, keep learning❤
I am From Pakistan and you really really taught too well,I just can't put in words but you are doing a great great job and thank you sir
You're most welcome dear. Do like & subscribe, keep learning & stay tuned for more upcoming contents👍😊
RTU Attendance here 👇👇👇👇
bhai kuch samajh nhi aarha fail hu rtu me
@@gamingwithshivamandgarvit1214 us bro us 😨😢😶
I m the topper of rtu 🙃
@@Ak_Edits25005 bhai paper hi easy tha main bhi top kr gya
Congratulations bros 👇 se@@gamingwithshivamandgarvit1214
This is one of the best one shot that covers all the important topics and Guess what ... My end sem paper had at least 95% of questions from this one shot .
Glad to know this, keep learning & stay connected for more upcoming contents👍😊
Bro tumhare ho gye end sem..??
@@AbhishekSharma-yt3ew 3 sem ho gaye
@@Menon_editsz ye dbms tumhare 3rd sem mai tha kya..??
@@AbhishekSharma-yt3ew haa tha
Good afternoon sir, I am a die heart fan of your teaching sir.
Believe me I didn't even touch the book and go through only by your online class and passed the dbms subject.
You are really providing a class content..
Excellent dear, glad to know this @Sukanya Keep learning & stay connected for more amazing contents, also let me know which subject do you want next?
@@KNOWLEDGEGATE_kg sir plz make one shot for software engineering
@@KNOWLEDGEGATE_kg Sir Artificial intelligent
India ko aap jaise logo ki jarurat h sir.. agar aap h tho ham h.. shayad future mein ham bhi aap jaise bane aur jyada se jyada eduaction ko phailaye ta ki hum india ko bana sake an educated country..!
And ye lecture to bht bbdya tha. Thankyou so much for making such videos... jo hme aap jaise ban ne ki prerna deti h aur inspiration bhi..
Lol emotional
Best ever video in RUclips,
All concepts understand with in 5:30 hours , college professor takes thousands hours for the teaching these things but that concept is not explained in the easy way
Thanku u sir❤🎉
You're welcome, keep learning & following. Do like, subscribe & share it with your friends. Stay connected for more upcoming contents👍😊
bhai thousand hours jyada nahi ho gaya, semester hi 5 mahine ka hota h
@@saver_x_28 bhaii common sense naam suna hai...
In general sense kya raha hai sentence se ye important hai ...
Aur hyperbole ke nam ki bhi cheez hote hai ....jise har aam ensaan use krta hai 🙂..
rhi batt yrr Bhai tum khas ho ..
Bhai tumhe dekhkar mujhe 3 idiot ki movie yad gyi jisme ek clip jisme Chatur speech de Raha tha ..chamtkar hi chamtkar ho raha hai ...😄😅
Thankyou sir for this wonderful explanation
Sir i have an query that at 4:54:43 in definition of non recoverable (commit and abort operation of Ti appear "AFTER" Tj) sir i think it is 'after' rather than 'before.'
yes
5 hours left...(Sem exam)
14 hrs left for end sem
@@donshadow3693 IPU's college ? 😭😭
i think this is the best video I have ever seen on dbms (considering examination purpose), it will clear your major theory concepts. highly recommended🙏
Thank you so much😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍
Anybody study for AKTU. comment
Thanks sir for this video and DBMS playlist.
I am From patna, Bihar
Thanks for watching Omkar😍 Do like, subscribe & share it with your friends. Stay connected for more upcoming contents👍😊
Canonical Cover QA (01:24:57) :-
A ---> B
B ----> C
is this answer correct? Anyone verify please
I got A->C also along with the two
Mine is
A->B
B->C
Same
Correct answer should be
a -> c
b -> c
c -> b
Same bro
Same ans
10:03 pura difference pel kr aayi ga 🤣🤣
This is something i always need for my exams
THANK YOUU SO MUCH SIR🙌
You're welcome dear, do like & subscribe, keep learning & stay tuned for more upcoming contents👍😊
Sir mja aagya ab lgta h syd m pass ho jaunga thnku sir, kl mera exam h, thnku once again sir
bhai kl ke exam ke liye enough hai, me ab shuru kr rha hu.
Great, all the very best, do well👍
Thnku sir mera exam bhot badhiya gya h@@KNOWLEDGEGATE_kg
Jai jinendra 🙏
Sir ur much appreciated much precious..
Till now i am not able to understand DBMS but now it is completely understand ..
Ur all video are precious thank u for for uploading best content 😊
You're most welcome Chhavi, keep learning & supporting! Stay connected for more upcoming contents, do like, subscribe & share the video👍😊
Watching and learning from Washington, D.C. - USA
Thank you Sanchit Sir..
Thank you so much for watching & supporting, stay blessed & keep learning😍
everything is temporary but train is permanent
Very Lucid one shot video sir. This kind of series will be among the top choice of students. Please continue the series for other subjects like TOC, CD etc. if possible.
Thank you so much dear! Do like & subscribe our channel for more upcoming videos😍 Sure, will consider your suggestion, stay tuned👍😊
One of the best content on DBMS I have ever seen , please make the Oneshot video on compiler design.
he has already made it.
It's already there: ruclips.net/video/OQCjakjCJu4/видео.html
hello sir the homework question of lossy/loseless decompostions has an error sir
which says that question is with relation R(A,B,C,D,E) but the relations given are
R1(A,B),R2(B,C),R3(A,B,C,D),R4(E,G) THE ERROR IS R4(E,G) the main relation was A to E but the R4 has G?
that was my request and thanks again for this very understandable lecture
Legends come before a NIGHT of Exam, here attandence 😂😂
Tomorrow is my exam 🙃
Bhai konsi university se ho
Jammu and Kashmir ❤❤
Hi dear, thanks for watching, which subject do you want next?
@@KNOWLEDGEGATE_kgComputer Networks sir
Content in this video:
00:00 (Chapter-0: Introduction)- About this video
02:20 (Chapter-1: Basics)- Data & information, Database System vs File System, Views of Data Base, Data Independence, Instances & Schema, OLAP Vs OLTP, Types of Data Base, DBA, Architecture.
21:56 (Chapter-2: ER Diagram)- Entity, Attributes, Relationship, Degree of a Relationship, Mapping, Weak Entity set, Conversion from ER Diagram to Relational Model, Generalization, Specification, Aggregation.
50:08 (Chapter-3: RDBMS & Functional Dependency)- Basics & Properties, Update Anomalies, Purpose of Normalization, Functional Dependency, Closure Set of Attributes, Armstrong’s axioms, Equivalence of two FD, Canonical cover, Keys.
1:38:28 (Chapter-4: Normalization)- 1NF, 2NF, 3NF, BCNF, Multivalued Dependency, 4NF, Lossy-Lossless Decomposition, 5NF, Dependency Preserving Decomposition.
2:19:32 (Chapter-5: Indexing)- Overview of indexing, Primary indexing, Clustered indexing and Secondary Indexing, B-Tree.
2:49:08 (Chapter 6: Relational Algebra)- Query Language, Select, Project, Union, Set Difference, Cross Product, Rename Operator, Additional or Derived Operators.
3:14:00 (Chapter-7: SQL)- Introduction to SQL, Classification, DDL Commands, Select, Where, Set Operations, Cartesian Product, Natural Join, Outer Join, Rename, Aggregate Functions, Ordering, String, Group, having, Trigger, embedded, dynamic SQL.
4:07:54 (Chapter-8: Relational Calculus)- Overview, Tuple Relation Calculus, Domain Relation Calculus.
4:22:28 (Chapter-9: Transaction)- What is Transaction, ACID Properties, Transaction Sates, Schedule, Conflict Serializability, View Serializability, Recoverability, Cascade lessness, Strict Schedule.
5:01:02 (Chapter-10: Recovery & Concurrency Control)- Log Based Recovery, Shadow Paging, Data Fragmentation, TIME STAMP ORDERING PROTOCOL, THOMAS WRITE RULE, 2 phase locking, Basic 2pl, Conservative 2pl, Rigorous 2pl, Strict 2pl, Validation based protocol Multiple Granularity.
Thank u sir for this one shot lecture.
It is very helpful for exam.
Glad it's helpful Suryansh, keep learning & stay connected for more amazing lectures.
Maharashtra pune❤
Thanks for watching, keep learning, which subject do you want next?
Aktu walo yha attendence lagao😅
Rtu attendance
wow great video sir....I have exam next day that's why I see this video and this is a great video.....my doubts are all cleared...thank you sir...
Glad it's helpful, wish you all the best👍
I'm from Andhra Pradesh sir....
I loved your video on the operating system.
I just studied it the night before the semester exam ...I just loved it.
I have to take dbms exam next ,let's check how would i get on with that
Thanks for watching Varshitha, do like & subscribe, keep learning & stay tuned for more upcoming contents👍😊
@@KNOWLEDGEGATE_kg yes sir sure😇
IPU waale attendance lagao kal ke DBMS exam ki 😂👇🏻
yeaaa boiii
Which college?
@@Lord_Dman adgitm!
@@LegendaryGoku22 I am in JIMS
Which jims? Vk or rohini?@@Lord_Dman
tomorrow is my DBMS exam and this helped me a lot thanks sir.. wish me luck😀
Wish you all the best, do well👍
@@KNOWLEDGEGATE_kg sir i did good thank you☺️
love from maharashtra
Thanks for watching, Vaibhav. Keep learning & following for more content👍
1:24:56 So the minimal cover is A----->B and B----->C
yes
Wrong in A->B
Closure(A)-ACB
@ 1:20:23 Sir said "Jab tak koi cheez hamare paas hai to hame pata nahi chalta but jab door ho jaati hai jab chalta hai".
Mai sahi bataau to mujhe sir 'May I Come In Madam' ke 'Sajan' ki tarah lagte hai.
Or sir ye aap ke liye ek kaam ki baat :- Sir, aap 'Sanjana Madam' se door chale jaaiye tabhi madam ko aapki value pata chalegi.
Aktu wale like kre
Hii
Sir aapka one shot class bpsc pgt teacher ke liye kaisi rahegi.
lucknow
thnk you som much sir maine DAA aapke channel se hi pdha tha aur 100% aya tha exam me same thank you so much sir 😍😍😊😊
Glad to know this Aryan! Please like, subscribe, and share the video, and stay connected for more amazing content👍
HN bro same, easy aya tha daa ka paper AKTU 5th sem
@@ratandeepsingh9693 yes bro ❤
@@KNOWLEDGEGATE_kg sir please machine learning pr ek video bnaiye RUclips pe bahut hi km content h MLT se related aur thik bhi nahi h
Loved this content sir, agar mein isko padhke bada aadmi bana to zaroor aise content ke liye contribute karunga.
Thank you so much dear, wish you all the very best, keep learning👍😊
1:25:00 the canonical cover is:- A-> B & B->C
A-b to phle hi ht jayega redundant hai na bhai wo to ???
@@yogeshjoshi2730 bro check your steps once again.
@@ayushiyadav1 can you explain pls without A -> B we can get AC using A -> C and using AC -> B we can get ACB so isn't A -> B redundant?
I got only B->C
Perfect one to score good marks in semester exams.....Spending 5 hours 33 minutes was worth❤...
sir now i proudly say u are the best in this business u made my btech sir thanks alot
You're welcome Anmol! Please like, subscribe, and share the video, and stay connected for more amazing content👍
Sir, I love you sir 💓 & big big thanks for this. You went on and on for straight five and a half hours. Continuously speaking without even taking a water break! Hats off to you sir. I can guarantee most of us will not complete this in one setting but you completed everything while speaking continuously for 5 hours! Huge respect!🎉💯
You're most welcome Vishal! Keep learning & supporting! Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍
5:33:29 Completed! It's impressive how you managed to cover almost everything in just 5 hours and 30 minutes, given the amount of content delivered usually requires much more time. Thanks a lot, # G.O.A.T Sanchit Sir. ❤❤🙏🙏
You're most welcome. Keep learning, supporting & stay connected for more content👍
Sir you are superb as you made a one shot of software enginnering on my request so thanks for it ❤.Also sir try for computer oriented numerical methods one shot also if possible ❤❤
You're welcome dear, keep learning & stay connected for more upcoming contents👍😊
I have a question sir, is there any difference in syllabus between DBMS In Hindi (Complete Playlist) available on RUclips and the "Database Management System" course on your website. I am a bit confused about which one will i choose. Sir could you please clarify
DBMS course on website is a complete course according to GATE syllabus, includes previous year questions, practice tests & grand tests also. But, no compulsion to buy a paid course, you can always refer our DBMS playlist, PYQs & tests are not included in this.
Thank you, so much sir this valuable content giving us . this ( DBMS ) content fully helpful for semester exam and best thing is all syllabus is match my acedmic syllabus most of the student watch your lecture beacuse its very helpful , again very thank you " great Sanchit sir "
You're most welcome Vishal, keep learning & supporting😍 Do like, subscribe & share it with your friends. Stay connected for more upcoming contents👍😊
1:07:35 I've learned this much from a prime institution, but honestly, I didn't get the clarity I got here. I must say, "Try a demo before you trust." Nevertheless, when it comes to Sanchit Sir, especially for DBMS, I have full trust. He's the G.O.A.T of DBMS for sure. It's not easy to teach the essence behind every single topic, from scratch, with 100% clarity. Thanks a lot, Sir. Lots of love and light always!!! ❤🔥🙏 ~ MPH student
Thank you so much for your valuable feedback dear! Am glad that you are liking our content. Stay connected for more videos & do share the video with your friends if you find it helpful.
@@KNOWLEDGEGATE_kg sure sir
1:55:54 the relational table R is in 3NF but not in BCNF , as all A,B,C,D,E are prime attributes
sir one topic which is left in this whole video as i have infdormed i am preparing for my semster from your channel i have feel that in unit 4 one topic DEADLOCK was not discussed !
just sharing it so otherr peoples may get informed and thankyou soo much!
For deadlock you can refer DBMS playlist: ruclips.net/p/PLmXKhU9FNesR1rSES7oLdJaNFgmuj0SYV
Namaste Sir, thank you for clearing all the concepts. I am from UP and I am pretty sure Bharat ke kone kone se log dekh rahe honge aapko.😃
You're most welcome Shivansh & thank you so much for following the content, keep supporting😊
SIr mst padhaya h apne
saare concept clear ho gye
but university ne game kr diya
Time Based Protocol me uske Basic type ka algorithm puch liya
Thanks a lot sir, I was struggling to build my interest in the subject before watching your video. Wish I had a professor like you :)
You're most welcome Gunjan, glad to know that our content is helpful. Keep supporting👍
one of the best teacher i saw in the history of my overall engineering
Thank you so much for your kind words dear. Keep learning, supporting & stay connected for more content👍
Thanku so much bhaiya ji ,aapne jo bhi padaya sab kich aaya 🥺❤️🫵 you deserve my respect handsome boi
Great, glad to know! Please like, subscribe, and share the video, and stay connected for more amazing content👍
sir u r the best teacher in my life i ever seen
Thanks a lot for your kind words, keep supporting & learning❤
@@KNOWLEDGEGATE_kg sir today is my paper of DBMS, and it went amazing only bcs of u, thnk u sir for giving me a lot of information 😊😊😊😊😊😊
Love from Maharashtra ❤
Thank you so much, keep supporting😊
Lucknow se sir and apka kl DAA ka on shit 9 hours ka dekhe they 88 marks ka 100 mein se ayaa thaa
Well done, glad to know this 👏 keep learning & supporting, Please like, subscribe, and share the video, and stay connected for more amazing content👍
sir plz make one shot videos on OOSD and MLT as exams are near on 29 feb and 31 feb . its a serious request sir
God!! I never knew that I would learn dbms in such wonderful way..Thank youu Sir bilkul sahi time pr mujhe ye video mil gya i hope exam me ache marks aayenge iss baar😇👌👌
You're welcome @Himanshi, keep learning & all the very best for your exam👍😊
1:24:57 What will be the answer to this?
Maine kabhi kisi ko comment nhi kiya aajtk lekin aaj majbur hu aap bhagwaan ho ❤
me first time dbms kar rhi hu, me jaipur,(rajasthan) se hu thanku so much...........................................🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks for watching😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍😊
(Watching from) Chitkara University
Thanks for watching dear😍 Do like, subscribe & share it with your friends. Stay connected for more upcoming contents👍😊
thanks sir you have made videos for my third semester i.e your mostly one shot videos
You're welcome Raghav, keep learning👍
I am from West Bengal sir...I watch your videos according to my subjects and they are very helpful to understand the topic very well...and the notes are also very helpful for my exams...Thank you so much sir...
Glad to know content is helpful Ishita, thank you for following the content, do share video with your friends & stay connected for more upcoming videos👍
Sir kindly confirm the answer🖐🖐
Answer to canonical cover under F.D is
In optimised form
A->C
B-> C
AC ->B
A to B
B to C
Equivalence - 1:16:00
Division - 3:11:50
Trigger - 4:05:30
I'm from Ratlam Madhya Pradesh ❤️
Thanks for watching😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍😊
1:45:32 yess ye dialogue humne pehle wale video me suna hai😂😂
Actually it was really good video, thank you Sir 🙏😄
You're welcome. Keep learning, supporting & stay connected for more content👍
Love from surat gujarat ❤
Currently studying in pune sppu university
Thanks for watching😍 Do like, subscribe & share it with your friends. Stay connected for more upcoming contents👍😊
Sir, you are the best teacher 💞😌
Isn't it 😊.❤
Thank you Rishikesh for your kind words, keep supporting❤
Thank you so much sir for completing whole huge syllabus.
You're welcome Tejas, keep learning & supporting👍😊
wah sir kya padhate ho 🥰👏🏻 quality content.you got a subscriber
Thank you, keep learning & following👍