Complete DBMS in One Shot (5 Hours) in Hindi

[@KundanMishra-mf9bi]

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.

[@omdhongde7153]

Respect boss !!!

[@rajpowar2264]

🫡

[@AbhivanyUyared]

Itni mahenat ke bad bhi like nhi mila 😅😂

[@yateesh1855]

@@AbhivanyUyared bhai usne Ai ki help se kiya h khud se nhi 😂

[@sonupritam4354]

Sir aapki wajah se maine Puri Btech complete Kari hai. Thank you sir. .... You are just awesome 😎😎

[@anshuxman9800]

Aktu dbms complete video ha ye bro ?

[@Ashwanifit0008]

​@@anshuxman9800yes brother

[@allmovie5373]

Ha

[@vardaanx8803]

Bhai job lagi kya?

[@Shashaankgargoffi]

Btu University ke liye bhi video upload kr dijiye 🙏

[@shubhamgarge7001]

Thank for teaching computer Science Fundamentals, First teachers day after getting job

[@PriyabrataPadhi-x5c]

Thank You so much sir. Please come up with some development stuffs like(frontend, backend) . One shot of any language.

[@herosing7964]

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

[@anurag01a]

Sir please make one shot videos of all cs subjects especially related to placements!

[@nandinipathak3037]

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

[@Karan_Kumar_Jharkhandi_1932]

Yes

[@ankitmatade4710]

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 ❤

[@ankitmatade4710]

Abhi start Kiya wapas tab so Gaya mai 😂4 din badh

[@sonamsinha406]

@@ankitmatade4710 koi baat nhi ,ab complete kiya ki nhi🤣

[@ankitmatade4710]

@@sonamsinha406 Ha par last ke 1hr skip Kiya not enough to clear sem with good marks

[@AjmalFaruqi]

Sir, DBMS topic explained in a very good and efficient manner with examples. Thanks !

[@maniprakash6960]

Sir, Please do on Operating Systems and Computer Networks...

[@atulkhanal6686]

personal things cannot be information but just data to someone but for someone it can be concidered as information if its about social engineering

[@LONE-WOLF_SURAJ]

You're my motivation to to things in an easy way , Thanku Sir to make Our lives Easier 🙏🏻♥️

[@deepanshusaxena7471]

Sir please make a 1 shot video on Web Technology for semester exams, it is much needed!

[@Acevishu]

Kash pehle search Kiya hota to or better kar pata 😊 Thank you desi language me samjhane k liye ❤

[@rd-fp1jh]

सर ऐसी ही वीडियो Data Structure, SAD, Software engineering, Networking, par बनाओ plz

[@muhammadrayyanshehzad1668]

Such an amazing teacher love you SIr

[@khushi5827]

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

[@anshulsingh3130]

Ok

[@VishakhaGoyal-n7x]

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

[@dineshthorat367]

Appreciate to your work sir, Handwritten notes & explanation is excellent❤

[@nidhiverma0901]

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

[@SujalKrsoni]

thanx a lot for this video can you make a video of COMPUTER ORGANISATION AND ARCHITECTURE

[@anuragshirsekar2078]

BEST TEACHER EVER FOR ANY SUBJECT

[@new__beginning]

THANKU SIR .networking ka class provide krde.

[@ajaysinghrawat322]

sir, plz post coa one shot too and this was very much helpful

[@littlejin-n8x]

sir please make a full video on CCNA please please, I need to prepare in 2 months and I learn the best from you , I have watched your computer networks videos and it was super helpful, please a playlist or complete video of 12-14 hours on CCNA 200-301 please :(

[@pleasantdayNwisdom]

sir ur happy face , fills happiness in us thankyou

[@saketkumar1123]

thank your sir for making this video it helps a lot 💕

[@pranotimane23]

Thanks

[@anshulsingh3130]

Waah!! Subhanallah

[@SAGARJADAV1795]

Kesi he ye video acha samajaya he ?

[@YASHPAL-SINCE-2004]

sir Please provide Microprocessor Oneshot

[@sudiptapalofficial]

thank you sir, from west bengal

[@Infernus-Swift]

thanku sir Understood everything!

[@AbhishekKumarAbhi-cr6ch]

Bhaiya aap bahut asan bhasa me samjhate hue ❤❤❤❤❤ thank you bhaiya

[@lavanyasingh6536]

3:06:50 relational calc for all, there exists

[@iamchiraggupta]

bahi.isme sb cover h na

[@ADILRASHED09]

Sir Machine learning ki bhi de do one shots video please

[@sonupritam4354]

Are gazab sir .

[@dn-2991]

Sir, MCQ v practice karwayiye na tab relate karne k liye aur dimag me parmanently betha ne k liye easy hota he.. a se dekhne samajh toh jate he but dimag permanently reh Nehi jata he.. Mein electronics & telecom se hu.. competitive exams de raha hu usme DBMS,Data structure, Microprocessor,data communication a sb ata he lekin chota chota questions, GATE k tarah Nehi.. JE level ka.. wesa wala questions practice karwa ne se help ho jata..

[@nayanpawar2004]

thank you so much.

[@manishyadav-gr3dj]

Ek raat me syllabus khtam karne wale ..attendance dedo 😂❤

[@RabiaNouman-gq2bo]

Yeah

[@RabiaNouman-gq2bo]

😂😂😂😂

[@pink.City-ln2zz]

Bhai kl hi exam hai 19-072024 Ko

[@vishalkalal2132]

Nice content .keep it up....I have cleared my all the doughts after watching your video thanking you

[@gopeshshukla8151]

YOUR WAY OF TEACHING IS AWESOME SIR .

[@nikhilkushwaha4418]

Mera exam h next month se thank u so much

[@khushi5827]

Relational database shows relationship between rows and columns Entities are rows and

[@sulagnaduttachoudhuri3838]

sir javascript tutorial complete kijiye please, thank you so much for this one shot series

[@payalwanje1238]

Sir you are teaching very nice I request data communication and computer network sati vdo kara

[@anshikajaiswal157]

sir data analytics ka one short chahaiye plss

[@English_604]

Thank you sir for making these videos...helped me a lot

[@niranjanchitragar7860]

Sir, barpoor quality content in this vidio . No good college will provide this type of notes 🎓⭐

[@YASHPAL-SINCE-2004]

sir Please ptovide Microprocessor Oneshot

[@vintech443]

Sir please 31 january ko exam h machine learning technique ka toh aap uski bhi one shot bnado

[@abadheshkumar283]

Sir You are great ❤

[@guljarhussain1830]

Award deserving teacher from engineering gang

[@Karanraj-jk2jq]

1:14:07

[@Umeshtechzvlog]

Sir upload compiler design one shot

[@KumarRajat-p3w]

no doubt .....Best

[@muhammadawaisminhas9657]

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

[@Song_shorts07]

Great work sir keep it up 💪

[@himanigarg4705]

Amazing session

[@RahulChouhan96]

This guy is humshakal of codewithharry

[@bull-bearmarket7271]

Great lecture ❤

[@satyamsinha6036]

Sir please provide 8085 microprocessor

[@EssakDasari]

Sir definations, proper points mention kardiya karo...utna scenario samajneke baadh likne ke liye proper deifination nhi hota hai.....exam mai scenario toh likh nhi sakte naa

[@Itswicrant]

Agree..

[@raghavendrac4710]

You teach very well sir.

[@iamchiraggupta]

bhai isme sem related sb cover h na ?

[@navratanyadav5378]

3:52:32 👍👍👍👌👌👌

[@Mistymehndidesign]

Sir CHP one shot bhi bna dijiye n

[@navratanyadav5378]

Love you sir ❤❤🙏🏻🙏🏻🙏🏻🌟🌟🌟 Thank you for the video

[@LakkojuHemanth]

Bhai 8051 microcontroller

[@nigamGvlog]

Best video ❤

[@vgaming2552]

Amazing video 👍

[@khushi5827]

Record pointers

[@asif_chouhanproduction415]

Keep doing good

[@aspirantofhealing117]

Is it good for semester exam .? Im having my 1st semester plz reply

[@latestsongs12]

Sir a big request for you please microprocessor and peripheral devices ki ka bi ik shot series'jdli dijiye

[@arshapjoy4086]

Complete ml dl in single video please

[@priyansh4324]

Daa cover kr do bhaiya

[@sauravsinghmehta6201]

Sir design and analysis of algorithms ki video please

[@StockTechnicalAnalyst..A-K]

Sir, Candidate ki can have a null value this makes differece b/w primary key and candidate key?

[@057_arkayanchakraborty6]

Thank you🙏

[@Truth-qe6sf]

5 minutes k bajaye 5 hours ki video.

[@malharkulkarni1641]

is this enough for placments preparation POV

[@aniketbhutange9527]

Is this video good for gate cse

[@Aesthetically_Fevered]

Srry but Functional dependency smjh nhi aya. Baki saab agya smjh.

[@pleasantdayNwisdom]

in view serializability why havent you mentioned third condition of same write read (updated read)?

[@navratanyadav5378]

2:39:00 👍👍

[@GauraVerseJi]

nice watch till end

[@latestgamer1412]

Ek hi din me core paper khatam karne ka ghamand hai 🗿🗿

[@DEEPGAMER77788]

kal mera bhi hai

[@latestgamer1412]

@@DEEPGAMER77788 best of luck

[@DEEPGAMER77788]

@@latestgamer1412 aapka kab hua tha

[@MelodicMemories-hw8ej]

​@@DEEPGAMER77788 JUT RANCHI student 😮

[@loki-ij4dl]

Sir enough for placements??

[@akhileshyadavshorts2957]

thanku sir for this content

[@ujwal9819]

sir u r best

[@iamchiraggupta]

bahi isme sb cover h na

[@Here.s_how]

Is this one shot more than enough for my sem exam ? does it includes questions

[@dipaliwarade7800]

Sir at 1:28:2 when B is also candidate key, then can AB still be super key?... Because now both A and B are prime attributes..

[@mehboobhussain5762]

saviour

[@sindhu1637]

Thanks a lot sir ❤

[@usmanmarkaz]

Thanks sir Gee love from pakistan

[@ganeshprajapat1502]

Thanks 🙏 Sir

[@kunaldoke8270]

Sir please launch course on full stack developer in low cost

[@khushi5827]

Entity set set of entities

[@souravdalai6769]

Best Best Best

[@Dontbus]

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

[@Neelambarigaikwad90]

Sir, please give cheatsheet of dbms.... 😢

[@tecnology7073]

🥰🥰