Complete DBMS Data Base Management System in one shot | Semester Exam | Hindi

[@KNOWLEDGEGATE_kg]

For complete content on Computer Science, check out the course link: tiny.cc/allcomputersciencecourse

[@avdhutshinde-q2k]

sir is this for bba ca first year dbms subject..............................

[@CollegeExamPreparation]

Nice Sir😊😊😊

[@adii3285]

ty sir for helping :))

[@me_and_god]

Sir ye wale notes ki pdf ka link kahaan h ??😢

[@adii3285]

@@me_and_god bro site pe jao aur wahan pe hai ab notes enroll kar lo but ab download nahi kar paoge 365 days free enroll hai 2nd course mai hai iske notes

[@amitkumar-dm7uv]

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.

[@imd2659]

THANX

[@spectre5002]

how free are you?

[@sameenshaik7037]

@@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....👍😉

[@jarvis9263]

@@spectre5002 bhai aap sachmein computer science field se belong karte hoo na ??

[@Chaddest_Maximus]

Lag toh nahi raha. Shayad iske baap ne management quota se karaya hoga admission ya phir iska interest nahi hoga.@@jarvis9263

[@vishnukumarroyrajput8367]

i think youtube should declare this video as the best video lecture for DBMS...great content sir .....thanks from the buttom of my heart...

[@KNOWLEDGEGATE_kg]

Thank you so much Vishnu😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍

[@vishnukumarroyrajput8367]

Okkkk sirrrr....

[@RikMishra]

where to get notes?

[@rajbhati1888]

No sorry, Keys ke baare me to padhaya hi nhi iss video me 😢😢😢

[@PiyushKumar-vd8jy]

​@@vishnukumarroyrajput8367 ab notes ke liye pay karna padega....ab free me notes nhi milege😢

[@abhishtgupta6242]

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!

[@KNOWLEDGEGATE_kg]

Thanks a lot Abhisht for your valuable feedback, glad to know our content is helpful to you, keep learning, supporting & stay connected👍😊

[@RikMishra]

@@KNOWLEDGEGATE_kg From where i can get notes?

[@shrijalshrivastav4873]

Hi sir your videos are very helpful could you please make one shot on data warehouse and data mining subject in aktu please

[@SystummmOP12]

" 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

[@KNOWLEDGEGATE_kg]

Excellent, keep learning & stay connected for more upcoming content❤

[@InduVerma-w4l]

Sir answer to bata diya kijia confirm krna ke liya

[@InduVerma-w4l]

Questions ka final answer bata diya kijia sol dhund lenge

[@vanshimathur3449]

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...

[@deathxunnat4693]

yes same here

[@ankitmehta6875]

1.04.32 Maruti Alto 800. ... Maruti Dzire. ... Maruti Swift. ... Maruti Eeco. ... Maruti Alto K10. ... Maruti Wagon R.

[@PRINCE-ts3no]

lmao

[@shivammodi3431]

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.

[@KNOWLEDGEGATE_kg]

Great, am glad to know this @Shivam, thanks a lot for your valuable feedback, keep learning & do like & share our videos❤

[@random2402]

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!

[@KNOWLEDGEGATE_kg]

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?

[@sportygirl1207]

@@KNOWLEDGEGATE_kg c , c++ , python , core java

[@vimal12592]

​@@KNOWLEDGEGATE_kg rpsc programmer course we need

[@Wajeehhassan-y6n]

​@@vimal12592KIA notes free mil saktay hein kesay milein gay samajh na aai

[@Wajeehhassan-y6n]

Notes kesay milein gay nae milrahay Koi help kr day.plz

[@MADHAVSHARMAGCEBDS]

more power to you sir !! genuinely wanted to say thanks . your content and teaching is truly gold .

[@KNOWLEDGEGATE_kg]

Thank you so much Madhav for your kind & generous feedback, stay connected & keep learning❤

[@Er.AmarVerma]

1:24:57 A->B,B->C

[@mddanish2016]

Hello sir, kash aap hamlog k time video dete very useful. 2023 pass out. Love from Bihar.

[@sahillodha6084]

Some next level explanation in limited time covering all topics thank you so much 🙏🙇‍♂💖

[@KNOWLEDGEGATE_kg]

Glad you liked it @Sahil❤ Do like, subscribe & share the video, also let me know which subject do you want next?

[@GauravRao01]

@@KNOWLEDGEGATE_kg JAVASCRIPT TUTORIALS 🥺

[@adarshrathore9960]

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

[@vinayakgupta6105]

Bro can you please update

[@shashankrapolu6819]

🤣🤣@@vinayakgupta6105

[@TM-jx6et]

bhai update karo!

[@sahilxd440]

padhle bhai

[@lofi_feels1924]

​@@sahilxd440😂😂😂😂

[@shubhamgarge7001]

Thank for teaching computer Science Fundametals, First teachers day after getting job, MANIT BHOPAL

[@KNOWLEDGEGATE_kg]

Glad to hear that, Shubham. Many congratulations dear, wish you all the very best for your upcoming career❤️

[@Dexco-r6v]

Yesterday I had my DBMS exam, and it went really well ,all thanks to you. Thank you,sir!

[@KNOWLEDGEGATE_kg]

Great job!

[@muskaansharma4102]

thanks a lot sir. These one shot lectures for semester exams, when we need them at any cost are extremely helpful

[@KNOWLEDGEGATE_kg]

Glad to know they are helpful, all the very best for your exams, keep learning & supporting👍😊

[@krishjain7840]

Thank you sir.Your normalisation part was fantastic , i finally got that clarity .

[@KNOWLEDGEGATE_kg]

Glad to know Krish, keep learning👍😊

[@ChahakKaur-w1m]

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!🙏🙏

[@KNOWLEDGEGATE_kg]

Sure dear, will consider your suggestion, stay connected & keep learning👍😊

[@Memes_Karaa]

1:55:55 Ans It is in 1NF because PK and CK is ADC And A -> B violates Partial dependency cause B is Non prime Attr which depends on one part of PK

[@aayushkumar4238]

I think the anwer is 3NF due to all attributes are prime . Here is three candidate key (EDC), (DCA), (BDC). Correct me if i wrong

[@alert_indian-x3p]

@@aayushkumar4238 Yours is correct. Since all attributes are prime, it is in 3NF form.

[@lazyGoliath]

@@aayushkumar4238 yes same

[@diptadipchoudhury1047]

@@aayushkumar4238 how do you find the ck

[@kalyanshnusaikia9288]

1:24:58 ans only B -> C is the optimal dependency. all the others are redundant set.

[@eyeopener_io]

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 ❤❤

[@KNOWLEDGEGATE_kg]

You're welcome, keep learning & supporting & stay connected for more upcoming contents👍

[@bhaiookabhai]

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!!

[@KrishnaMohan-d6j]

bro what is your college name and what are you doing i mean course?

[@KNOWLEDGEGATE_kg]

Glad to hear that, all the best for your upcoming exams, keep learning👍😊

[@bhaiookabhai]

@@KrishnaMohan-d6j brother my Clg is HBTI kanpur and course is Btech(CSE)

[@avilashdey6581]

What happened bro then?

[@sh.creation.]

Sir , my answer : " AC->B , A->C, B->C " of canonical cover question after removing redundancy . Is this correct or not ?

[@randomstuff5714]

mine answer is also same

[@anuvanshkshatriya7268]

AC->B is also redundant kindly check

[@shriramjisewak]

No you can't get to B if you remove AC->B

[@akshattiwary6521]

@@shriramjisewak from a we can reach b

[@shobhitgautam752]

B -> C A -> BC

[@JonJones-pz9kb]

Amazing lecture series. May god suppport you SIr

[@KNOWLEDGEGATE_kg]

Thanks for watching dear, keep learning & stay connected for more upcoming content👍

[@sumanthrajhalaharvi4529]

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..

[@theflash34529]

Lol emotional

[@umeshkumarsingh2494]

Thank you so much sir...I am eagerly looking for CN also😘🙏

[@KNOWLEDGEGATE_kg]

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?

[@umeshkumarsingh2494]

@@KNOWLEDGEGATE_kg thank you so much sir... Compiler Design after CN🙏

[@prakashkumar2645]

Thanks a lot Sir 🙏 Compiler Design after CN Sir

[@somya3641]

sir plz compiler design after CN

[@ek_kosish.]

Compiler design 😊

[@Menon_editsz]

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 .

[@KNOWLEDGEGATE_kg]

Glad to know this, keep learning & stay connected for more upcoming contents👍😊

[@Zenlifechronicle]

Bro tumhare ho gye end sem..??

[@Menon_editsz]

@@Zenlifechronicle 3 sem ho gaye

[@Zenlifechronicle]

@@Menon_editsz ye dbms tumhare 3rd sem mai tha kya..??

[@Menon_editsz]

@@Zenlifechronicle haa tha

[@luckyverma9475]

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.🙂

[@KNOWLEDGEGATE_kg]

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👍😊

[@luckyverma9475]

@@KNOWLEDGEGATE_kg Thank you so much sir 😊🙂

[@cybrbby7]

Great video, straight to the point no spoon feeding/giving lame examples like apna college.

[@KNOWLEDGEGATE_kg]

Glad you liked it dear, thanks for following the content. Keep learning & stay connected😊

[@anmollavania5721]

sir now i proudly say u are the best in this business u made my btech sir thanks alot

[@KNOWLEDGEGATE_kg]

You're welcome Anmol! Please like, subscribe, and share the video, and stay connected for more amazing content👍

[@Hustle_Games]

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🙏

[@KNOWLEDGEGATE_kg]

Thank you so much😍 Do like, subscribe & share the video with your friends. Stay connected for more upcoming contents👍

[@sukanyabhardwaj1232]

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..

[@KNOWLEDGEGATE_kg]

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?

[@samratguha7053]

@@KNOWLEDGEGATE_kg sir plz make one shot for software engineering

[@Abhinavpandey-ub1pz]

@@KNOWLEDGEGATE_kg Sir Artificial intelligent

[@LofiVibes_Lounge69]

any one from GTU 👉

[@ayushprajapati211]

Yes

[@HalfTuber-db]

Yes

[@Almostwebbing]

✋✋

[@dilkhush8458]

Yes

[@Dev_v_patil]

Yes

[@Umesh_Sh]

1:20:18 Accha khaasa padhai kar rha tha sir......🥲

[@rishavranjan6656]

The best ever video created for learning DBMS, I am a Mechanical Engineering graduate and the way in which he taught the concepts was absolute brilliance

[@KNOWLEDGEGATE_kg]

Glad you liked it dear @rishavranjan6656, thank you. Keep learning, supporting & stay connected for more content👍

[@aestheticsstash06]

This is something i always need for my exams THANK YOUU SO MUCH SIR🙌

[@KNOWLEDGEGATE_kg]

You're welcome dear, do like & subscribe, keep learning & stay tuned for more upcoming contents👍😊

[@4kwallpapaer01official6]

this man made me to pass university exams every time , u r jusprit bumbrah of my life

[@Rushill_gulati]

Thanks for the great lecture.

[@KNOWLEDGEGATE_kg]

You are most welcome, Aryan. Keep supporting😍

[@Simplesamosa9834]

Thank u sir for this one shot lecture. It is very helpful for exam.

[@KNOWLEDGEGATE_kg]

Glad it's helpful Suryansh, keep learning & stay connected for more amazing lectures.

[@AbhishekHansdak]

1:24:56 So the minimal cover is A----->B and B----->C

[@UzairAli-od6kv]

yes

[@Priyanshu-ur7ek]

Wrong in A->B Closure(A)-ACB

[@RanjeshGautam-h2y]

BCA attendance 😅

[@cousinsvlogs3912]

Yes

[@NandiniDeshpande-f4e]

Yes

[@PriyankaKumari-yh9ns]

Yes

[@GauravRao01]

1:55:54 Answer of this question is 2NF because partial dependency doesn't exist and the Relation is in 1NF.

[@darshan_k_05]

Legends come before a NIGHT of Exam, here attandence 😂😂

[@VikramSingh-rg9yq]

Time 2:15:31 R(ABC) Lossless Decomposition R(ABCD) Lossless Decomposition R (ABCDEG) Lossy Decomposition

[@aqibfiroz4661]

One of the best content on DBMS I have ever seen , please make the Oneshot video on compiler design.

[@aman-satyawani]

he has already made it.

[@KNOWLEDGEGATE_kg]

It's already there: kzbin.info/www/bejne/hYKmm5Shn6h9q5Y

[@harshmittal6461]

Subah 10 baje exam ke liye abi video start karne wale kitne hai

[@HunterPlayz.24]

Me😁

[@NahidaYasmeen]

2024 main dekhne walo 👍

[@vksaxena3696]

👍

[@varshakansal2823]

Can someone provide notes link

[@nishamaharana69]

baby i love you...❤

[@nishamaharana69]

jaanuu

[@SanjayKumar-ju9ky]

Male version of Goddess Saraswati 🙏.

[@imsagarsuryavanshi]

Thanku so much bhaiya ji ,aapne jo bhi padaya sab kich aaya 🥺❤️🫵 you deserve my respect handsome boi

[@KNOWLEDGEGATE_kg]

Great, glad to know! Please like, subscribe, and share the video, and stay connected for more amazing content👍

[@URVISHAH-v7m]

thankyou it help me a lot and finally i know the concepts of dbms perfectly.Please keep posting the videos they are really helpful to us. once again thankyou sir

[@KNOWLEDGEGATE_kg]

Sure, will do. Keep learning & following for more upcoming videos👍

[@pt267]

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.

[@KNOWLEDGEGATE_kg]

Thank you so much dear! Do like & subscribe our channel for more upcoming videos😍 Sure, will consider your suggestion, stay tuned👍😊

[@Mr_Yuvii_Rajput.1303]

Anybody study for AKTU. comment

[@manassingh18]

Han bhai aaj start kiya

[@akanksha915]

1 day left for Sem Exam

[@pranjalmaiti4298]

6 hours consistency is enough 🙂

[@akanksha915]

@@pranjalmaiti4298 Right But you can't recall all the concepts during exam

[@pranjalmaiti4298]

@@akanksha915 not each and every but some of those will 🙂

[@ringtoneworld8361]

West Bengal? Makaut?

[@JonJones-pz9kb]

May God bless you Sir ❤

[@KNOWLEDGEGATE_kg]

Thanks a lot for your good wishes🙏

[@WhatsUpDude_o]

Sir jab video syllabus ke according banate hain aap, to video chapters bhi same college syllabus ke according banaya kariye, ye special video chapters ke vajah se hotchpotch hota hai bahut, is one shot mein unit wise one shot hoga to, humare liye specific unit ko dekhna easy hoga, ab ek unit bas dekhna hai to uske liye ek ek topic alag alag time line pe ja ke khoj ke dekhun 😢, Baki apke lectures bahot achchhe hote hain, nd in easy language also.😊 But uper ki query ko ek baar dhyaan dijiye.

[@KNOWLEDGEGATE_kg]

Dear learner, ye video kisi ek specific college ya university ko dhyan mein rakhke nai banaya gaya hai. Humne video ko aise design kiya hai ke maximum university ke syllabus ko match kar sake.

[@HimanshuSharma-hw6kt]

everything is temporary but train is permanent

[@garvitgoyal9888]

RTU Attendance here 👇👇👇👇

[@gamingwithshivamandgarvit1214]

bhai kuch samajh nhi aarha fail hu rtu me

[@garvitgoyal9888]

@@gamingwithshivamandgarvit1214 us bro us 😨😢😶

[@Ak_Edits25005]

I m the topper of rtu 🙃

[@gamingwithshivamandgarvit1214]

@@Ak_Edits25005 bhai paper hi easy tha main bhi top kr gya

[@sunnysharma3155]

Congratulations bros 👇 se​@@gamingwithshivamandgarvit1214

[@raunaksahafouzder4871]

Canonical Cover QA (01:24:57) :- A ---> B B ----> C is this answer correct? Anyone verify please

[@AkshatKaushik-d7f]

I got A->C also along with the two

[@virendranathmishra8155]

Mine is A->B B->C Same

[@Devraj14433]

Correct answer should be a -> c b -> c c -> b

[@118-swatantraupadhyay2]

Same bro

[@ashish_ash_k]

Same ans

[@KanishkSaha]

Equivalence - 1:16:00 Division - 3:11:50 Trigger - 4:05:30

[@shivanshpandey4237]

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.😃

[@KNOWLEDGEGATE_kg]

You're most welcome Shivansh & thank you so much for following the content, keep supporting😊

[@VaibhavSrivastav-p8s]

10:03 pura difference pel kr aayi ga 🤣🤣

[@AkshayKumar-ll5df]

Jammu and Kashmir ❤❤

[@KNOWLEDGEGATE_kg]

Hi dear, thanks for watching, which subject do you want next?

[@kelvinrathod9556]

​@@KNOWLEDGEGATE_kgComputer Networks sir

[@AditiVerma825]

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.'

[@dakshverma8982]

yes

[@ayushiydvKG]

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

[@KNOWLEDGEGATE_kg]

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.

[@ayushiydvKG]

@@KNOWLEDGEGATE_kg sure sir

[@MUKESHKUMAR-uu1uv]

Concepts are being taught in very lucid way Also we request to prepare video on data warehouse and data mining. Requires in professional exams

[@Vaishnavi1203]

5 hours left...(Sem exam)

[@donshadow3693]

14 hrs left for end sem

[@AsmitKrGautam]

@@donshadow3693 IPU's college ? 😭😭

[@iamSanerjee]

tomorrow is my DBMS exam and this helped me a lot thanks sir.. wish me luck😀

[@KNOWLEDGEGATE_kg]

Wish you all the best, do well👍

[@iamSanerjee]

@@KNOWLEDGEGATE_kg sir i did good thank you☺️

[@PrateekChenani-r6w]

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

[@gtxthunderstorm6219]

Love from Andhra Pradesh Jai Hind

[@KNOWLEDGEGATE_kg]

Thanks a lot dear, keep learning & following😊

[@mayankthakur3559]

@ 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.

[@avdhutshinde-q2k]

Maharashtra pune❤

[@KNOWLEDGEGATE_kg]

Thanks for watching, keep learning, which subject do you want next?

[@theflash34529]

Rtu attendance

[@MrVaibhavv]

love from maharashtra

[@KNOWLEDGEGATE_kg]

Thanks for watching, Vaibhav. Keep learning & following for more content👍

[@MubasheraParveen-l9g]

Minimal cover Q. R(A,B,C) Answer= A --> B B ---> c

[@Jai_bharat_183]

one of the best teacher i saw in the history of my overall engineering

[@KNOWLEDGEGATE_kg]

Thank you so much for your kind words dear. Keep learning, supporting & stay connected for more content👍

[@ncjpr04]

Tomorrow is my exam 🙃

[@MohdShuaib-nw3db]

Bhai konsi university se ho

[@arkestahotvideo2669]

Aktu wale like kre

[@SudhirKumar-w5n4t]

Hii

[@santoshgupta5542]

Sir aapka one shot class bpsc pgt teacher ke liye kaisi rahegi.

[@nitinbhatia3640]

Thank you so much for providing this content❤ please make one shot video on "Fundamentals of Mobile Computing"🙏

[@KNOWLEDGEGATE_kg]

You're welcome, Nitin. Keep learning, supporting & stay connected for more upcoming content👍

[@aanchaldharmasya]

Perfect one to score good marks in semester exams.....Spending 5 hours 33 minutes was worth❤...

[@challenger6089]

Aktu walo yha attendence lagao😅

[@LegendaryGoku22]

IPU waale attendance lagao kal ke DBMS exam ki 😂👇🏻

[@anonymous-qy1vw]

yeaaa boiii

[@Lord_Dman]

Which college?

[@LegendaryGoku22]

@@Lord_Dman adgitm!

[@Lord_Dman]

@@LegendaryGoku22 I am in JIMS

[@rishavrathor5686]

Which jims? Vk or rohini?​@@Lord_Dman

[@gunjankanwar6367]

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 :)

[@KNOWLEDGEGATE_kg]

You're most welcome Gunjan, glad to know that our content is helpful. Keep supporting👍

[@pv9835]

College m lakho rupees fee dekar bhi kuch samz nhi aur yha sab kuch samz aa gya free m. Thank you sir 🙏 salute

[@KNOWLEDGEGATE_kg]

Glad it's helpful. Keep learning & following for more content👍

[@mayankchopra536]

Thank you so much sir for complete explanation of DBMS. Would love to see more one-shot videos on Topics like Big Data, Machine Learning etc. in future . ❤🤩

[@ishitadas1225]

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...

[@KNOWLEDGEGATE_kg]

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👍

[@debjeetpaul449]

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...

[@KNOWLEDGEGATE_kg]

Glad it's helpful, wish you all the best👍

[@ayushiydvKG]

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. ❤❤🙏🙏

[@KNOWLEDGEGATE_kg]

You're most welcome. Keep learning, supporting & stay connected for more content👍

[@dikshantshokhanda5773]

Sir mja aagya ab lgta h syd m pass ho jaunga thnku sir, kl mera exam h, thnku once again sir

[@aman-satyawani]

bhai kl ke exam ke liye enough hai, me ab shuru kr rha hu.

[@KNOWLEDGEGATE_kg]

Great, all the very best, do well👍

[@dikshantshokhanda5773]

Thnku sir mera exam bhot badhiya gya h​@@KNOWLEDGEGATE_kg

[@MixedMatter001]

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.

[@AryanSharmaA]

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

[@alibadhahimateja2877]

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

[@STUDY-fr4zu]

to anoyone in doubt , this vedio will cover all topics in greatest detail in shortest time , must watch buddy

[@KNOWLEDGEGATE_kg]

Thanks a lot dear. Keep learning, supporting & stay connected for more upcoming content👍

[@Erwinsmith-ib8hr]

wah sir kya padhate ho 🥰👏🏻 quality content.you got a subscriber

[@KNOWLEDGEGATE_kg]

Thank you, keep learning & following👍

[@nirajmodi2998]

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

[@ihgamingfun6295]

I am watching from Arunachal Pradesh ... Thanks a lot sir ❤❤

[@KNOWLEDGEGATE_kg]

You're welcome. Keep learning, supporting & stay connected for more upcoming content👍

[@ayushiydvKG]

1:25:00 the canonical cover is:- A-> B & B->C

[@yogeshjoshi2730]

A-b to phle hi ht jayega redundant hai na bhai wo to ???

[@ayushiydvKG]

@@yogeshjoshi2730 bro check your steps once again.

[@bhuvansharma6979]

@@ayushiydvKG 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?

[@rittikk_gauttamm]

I got only B->C

[@Nothingeverything192]

@@yogeshjoshi2730 you are right

[@Gamercr007]

Thank you sir very good explaination,because of you i can develop very good understanding of dbms subject.

[@KNOWLEDGEGATE_kg]

You are most welcome, Arpit. Glad to know our content is helpful, stay connected for more upcoming videos😊

[@shahulrahman2516]

Fantastic video. Kindly make an English version for non-native speakers.