HomeОбразованиеRelated VideosMore From: KNOWLEDGE GATE

PART 5.3 Indexing in dbms in hindi basics of indexing in dbms primary secondary clustered

2049 ratings | 199350 views
• Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc. You can register for the program at: https://goo.gl/forms/ZmLB2XwoCIKppDh92 You can check out the brochure at: https://www.google.com/url?q=http://www.knowledgegate.in/guruji/counselling_guruji_brochure.pdf&sa=D&ust=1553069285684000&usg=AFQjCNFaTk4Pnid0XYyZoDTlAtDPUGcxNA • Link for the complete playlist of DBMS is: https://www.youtube.com/playlist?list=PLmXKhU9FNesR1rSES7oLdJaNFgmuj0SYV • Links for the books that we recommend for DBMS are: 1.Database System Concepts (Writer: Avi Silberschatz · Henry F.Korth · S. Sudarshan) (Publisher: McGraw Hill Education) https://amzn.to/2HoR6ta 2.Fundamentals of database systems (Writer:Ramez Elmsari,Shamkant B.Navathe) https://amzn.to/2EYEUh2 3.Database Management Systems (Writer: Raghu Ramkrishnan, JohannesGehrke) https://amzn.to/2EZGYph 4.Introduction to Database Management (Writer: Mark L. Gillenson, Paulraj Ponniah, Alex Kriegel, Boris M. Trukhnov, Allen G. Taylor, and Gavin Powell with Frank Miller.(Publisher: Wiley Pathways) https://amzn.to/2F0e20w • Check out our website http://www.knowledgegate.in/ • Please spare some time and fill this form so that we can know about you and what you think about us: https://goo.gl/forms/b5ffxRyEAsaoUatx2 • Your review/recommendation and some words can help validating our quality of content and work so Please do the following: - 1) Give us a 5-star review with comment on Google https://goo.gl/maps/sLgzMX5oUZ82 2) Follow our Facebook page and give us a 5-star review with comments https://www.facebook.com/pg/knowledgegate.in/reviews 3) Follow us on Instagram https://www.instagram.com/mail.knowledgegate/ 4) Follow us on Quora https://www.quora.com/profile/Sanchit-Jain-307 • Links for Hindi playlists of other Subjects are: TOC: https://www.youtube.com/playlist?list=PLmXKhU9FNesSdCsn6YQqu9DmXRMsYdZ2T OS: https://www.youtube.com/playlist?list=PLmXKhU9FNesSFvj6gASuWmQd23Ul5omtD Digital Electronics: https://www.youtube.com/playlist?list=PLmXKhU9FNesSfX1PVt4VGm-wbIKfemUWK Discrete Mathematics: Relations:https://www.youtube.com/playlist?list=PLmXKhU9FNesTpQNP_OpXN7WaPwGx7NWsq Graph Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesS7GpOddHDX3ZCl86_cwcIn Group Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesQrSgLxm6zx3XxH_M_8n3LA Proposition:https://www.youtube.com/playlist?list=PLmXKhU9FNesQxcibunbD82NTQMBKVUO1S Set Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesTSqP8hWDncxpCj8a4uzmu7 Data Structure: https://www.youtube.com/playlist?list=PLmXKhU9FNesRRy20Hjr2GuQ7Y6wevfsc5 Computer Networks: https://www.youtube.com/playlist?list=PLmXKhU9FNesSjFbXSZGF8JF_4LVwwofCd Algorithm: https://www.youtube.com/playlist?list=PLmXKhU9FNesQJ3rpOAFE6RTm-2u2diwKn • About this video: This video discusses the concept of Indexing in database in Hindi. Important topic of database Indexing like need of indexing in database management indexing, Why we do indexing in files in database, How we do indexing in dbms, Types of indexing, Methods of Indexing, Advantages of Indexing, How to access a file fast in database, Single level Indexing in database file, Multilevel indexing in database file structure in dbms, Dense indexing in database, Sparse Indexing in database, Index file in dbms, Advantages of using Index file in database are discussed. What is Indexing: Additional auxiliary access structure is called indexes, a data technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Dense Index: 1)In dense index, there is an entry in the index file for every search key value in the main file. This makes searching faster but requires more space to store index records itself. 2)Note that it is not for every record, it is for every search key value. Sometime number of records in the main file is greater than = number of search keys in the main file, for example if search key is repeated. Sparse Index: 1)If an index entry is created only for some records of the main file, then it is called sparse index. 2)No. of index entries in the index file is less than No. of records in the main file. Indexing in dbms, Indexing in dbms tutorial in hindi,about indexing in dbms,indexing and hashing in dbms, terminologies in indexing in database,indexing in dbms example,indexing in dbms tutorial,disadvantages of indexing in dbms,indexing in dbms for gate, sparse indexing example, dense indexing in dbms example, DBMS blueprint, DataBase Management system,database,DBMS, RDBMS, Relations, Table, Query, Normalization, Normal forms,Database design,Relational Model,Instance,Schema,Data Definition Language, SQL queries, ER Diagrams, Entity Relationship Model,Constraints,Entity,Attributes,Weak entity, Types of entity,DataBase design, database architecture, Degree of relation,Cardinality ratio,One to many relationship,
Html code for embedding videos on your blog
Text Comments (169)
Born To Goal (6 days ago)
best yar 1000 times better than my uni professor
Kanika Tak (10 days ago)
Very good sir
Baris Onur (15 days ago)
Please speak only English in your video series. Most people do not understand Indian.
Prasad Gujar (22 days ago)
Can a table have multiple indexes ?
Leo Johns (28 days ago)
The quality of explanation is so good that those ones who hardly understands Hindi are able to get a better understanding about the core topics. Thank you sir for this service. It's a great help for every student in the country. May god bless you
Akshay Baura (1 month ago)
This is just wow
Muhammad Safi Ullah (1 month ago)
Tomorrow is my exam.
Priyanka Jain (1 month ago)
Explain very well..... But takes long time to explain..... So waste time....
Prasun Tiwari (1 month ago)
Watching one day before exam in 1.5x speed😎
Prasun Tiwari (1 month ago)
@infallible 19 NIT Raipur
infallible 19 (1 month ago)
@Prasun Tiwari konsa college? kahan se ho?
Prasun Tiwari (1 month ago)
@infallible 19 Kasam se atleast 90/💯 to ayega hi
infallible 19 (1 month ago)
exam kaisa tha bhai
mrigank sagar (1 month ago)
Sir sometimes you give very unnecessary examples, you can explore more technically instead them , (NOT ALWAYS) And thank you for making good videos
Mallikarjun Komarraju (1 month ago)
Sir, That background sound like buzz.. sound is so annoying. All the concepts are clear.
Gautam Kishore Shahi (2 months ago)
Do I need to do indexing on all the column or Will it is fine to do it on the primary key only?
saipriya salver (3 months ago)
Can you explain b+tree
Aman Garg (3 months ago)
mitochondria are the powerhouse of the cell.
Muhammad Ahmad (4 months ago)
may you live long ....! your effort is truly capable for appreciate
VARUN TANEJA (4 months ago)
The video was awesome but there are some doubt uncleared till end of the video 1. What would be the S.K (Search Key) 2. Generally we access the database by filter in the query based on different attribites and this makes S.K non-specific.
Radha Ingle (4 months ago)
confusing.....
Megha Sharma (5 months ago)
hii sanchit sir i m watching all ur videos it is more than awesome Thank you God bless u :)
Saradha Devi (5 months ago)
Please make a video in English
candy raymond mdunge (5 months ago)
Check the comments they are in english, perhaps a hint to reach other around the world
candy raymond mdunge (5 months ago)
English
Abdul Wahab (6 months ago)
You're doing a very nice job. Love from Pakistan
Harish kumar (6 months ago)
sir.. best ho app
Mauricio Lomeli (6 months ago)
I don't follow. I hear ,"Sorted order michilega formidagon orishdaga 10 blocks hodinga" Was that english? Hindi? Thats the first time i heard the language. Cool.
Prakrut Chauhan (7 months ago)
Are you also watching this one day before the exams?
TEE_VEE (25 days ago)
Kal hi hai 10 am now it's 9:00 pm rat bhar padhna hoga aj
TEE_VEE (25 days ago)
Yess
bharat regmi (1 month ago)
hhhhaaaaa tommorrow is my exam
H S (1 month ago)
@Prasun Tiwari dude us 2x speed
Me Qayim (7 months ago)
I every video u waste atleast 2 min
Satyaprakash Sahoo (7 months ago)
Really sir u r the best teacher...
ABINASH KUMAR RAY (7 months ago)
awesome explainations!!! Your tutorials are just life saver..Thanks alot sir!!!
shahab sohail (7 months ago)
Very helpful tutorials
Chirayu Asati (7 months ago)
Even after indexing, we have to search 1000 tuples and again it's worst case O(log2N) which is 10 tuples same as earlier. Then what's the advantage, can anyone explain?
Abhishek Goyal (7 months ago)
Great way to explain..Thanks Sir
manish fender (7 months ago)
thank you sirr.. u are very clear with your concepts... love this video once again thanks..
Jagdish malviya (7 months ago)
It's making complicate of this concept
bhuvanasree bapatla (7 months ago)
Sir please try to do in English ...
Ravit Chaudhary (8 months ago)
not good.. what is block in database
Ravit Chaudhary (8 months ago)
sir aap topic ko gumate bahut ho..but correct solutation fir bhi nahi dete
mohd arshad (8 months ago)
Amazing video lecture i like it to study for gate
Archana (8 months ago)
Wow.. Very nice explaination.. Even people who don't know what is SQL will also understand it.. 👍👍
Sonu Ameer (8 months ago)
please try to convey in English so that many will be benefited!
Amruta Haspe (8 months ago)
sir plzz make vedios on hashing and b+ trees
muhammad wasif (8 months ago)
Sir you are doing a great job. Love and respect from Pakistan :-)
NV STORY (8 months ago)
very good
Pratik Patil (9 months ago)
Accha video👍 itna slow kyu bolte ho sir.?
GAURAV SHARMA (9 months ago)
this is the way of teaching, i have seldomly watch this type of way of teaching, sir you are not only great but super great, baatl ki khal nikal dete ho topic ki, keep doing this well job.
Thirunayan Dinesh (9 months ago)
Can u make the video in english??
SAGAR KUMAR (9 months ago)
Index 1000 page ka isse achha to book hi pdle🤣🤣🤣😂 although video is just awesome
dinesh punia (9 months ago)
Osum sir ji
Sushant Kumar (9 months ago)
When you say that we want to search 35th record and then we know that it comes between 31 and 40....how does the file know? Does it do binary search or some other way out?
Sushant Kumar (9 months ago)
Excellent explanation ...
KNOWLEDGE GATE (9 months ago)
Thanx buddy..
Aman Sharma (10 months ago)
queries p bhi video banaie sir
Harendra singh (11 months ago)
I think in I.F. the last entry in search key will be 9991.
Equality (11 months ago)
One of the best vedio
tareq mahmud hridoy (11 months ago)
simple english as well hindi , easy to understand though i am bangali :)
Amarendra Gupta (11 months ago)
Block kaise divide hote hai Please explain
anshul thakur (1 year ago)
Very helpful ,thanks a lot sir
Reena Thomas (1 year ago)
Sir Ur explanations are really good.
Probir Kumar (1 year ago)
got some good information about index.. Thanks..
labib8aug (1 year ago)
thanks bro
Nilanjana Roy (1 year ago)
unbelivable explanation...too good
Anchal Soni (1 year ago)
ads are quite disturbing pls remove them in your next videos
kundan singh panwar (1 year ago)
thnks but i think you should give better example pls
devika t (1 year ago)
plz make it in English sir
Abey Rajan (1 year ago)
Please make videos in english😓😭😭😭🙏🙏
Anisha Chopra (1 year ago)
Thank you so much Sir...great explanation
Sherene Antony (1 year ago)
Please post more videos in English... I don't understand Hindi... Your videos are really good... Especially because exams are coming up... Thanks😊
Sreeja Gurijala (1 year ago)
pls make videos in english also
ahir ashish kumar
Priyanka Poddar (1 year ago)
i can't found the multilevel indexing
Chandrakant Verma (1 year ago)
your way of simplifying the things in easy way is awesome
Komal Yadav (1 year ago)
Please provide a lecture on ASYMPTOTIC NOTATION
Amit Kumar (1 year ago)
Not well explained.
karan goel (1 year ago)
I really like the way you taught the phenomenon of the cache and how the small file and big file access is different
KNOWLEDGE GATE (1 year ago)
Thank you Karan.. Keep following..
tapanjeet roy (1 year ago)
you explain very well sir...thanks a lot sir...
Mohd Sameer (1 year ago)
Pls sir use English most.
Abhijeet Jha (1 year ago)
Wow superb explanation 👍
Vandit Sharma (1 year ago)
Plz made a vedeo of inverted and multilist pls give link any
Praveen Kumar (1 year ago)
its too long way to explain indexing.very bore
vishal21475 (5 months ago)
Bhai isse badhiya explain nahi Kiya youtube par
bharath kumar (1 year ago)
Plz..in english
taw nunu (1 year ago)
Kya hain AI??
Shivani Shubham (1 year ago)
You have mixed up all the concept 😠i got confused
Vivek Gaikwad (1 year ago)
Very good explanation.Very useful.
srushti mate (1 year ago)
thanks for the videos will you explain optimal bianry search tree with example
priya jaganathakumar (1 year ago)
please explain in english
Brij Patel (1 year ago)
keep it up bhai,maja aa gaya samaj ne mai!!!...
Elisha Kriis (1 year ago)
Its an Awesome video, also watch my youtube channel and please make sure to subscribe to my youtube channel
Jahangir Hussain (1 year ago)
overwhelming respect from Pakistan....
Ajinkya Jumbad (1 year ago)
index is cache :P
Frenzy Candour (1 year ago)
Thanks.It was very helpful ...
Neeraj Singh (1 year ago)
sir """B++ Tree """upload plz....!!
Mukesh Singh (1 year ago)
good content and great description
Gazi Muhib (1 year ago)
pls sir make a video on b+ tree and on hashing
Hossain Tech (1 year ago)
Love you sir❤❤❤❤
anup kumar (1 year ago)
guruji tussi great ho,
Nayancy Gupta (1 year ago)
Your video helps in learning and understanding topics well. Pls can u upload sone videos on B and B+ trees numerical because they are quite confusing and I don't find them anywhere else.
Sumit Shrivastava (1 year ago)
Pura 2nd Year CIT UPES yahin milega aaj.
sachin sharma (1 year ago)
very well explained
kuntal dutta (1 year ago)
please make video on b+ and b trees to solve gate question
usman bhatti (1 year ago)
16:49 yahan 35 record number obvious bat ha 30 k bad ho ga ku ek block men 10 hn ......eg:.....block(a) ->a(records(31-40))........................plz answer this
usman bhatti (1 year ago)
15:29 idhr index list ki numbering 9991 pe end ho ge ku k yeh records show kar ra ha na k blocks
Rupali Bairwa (1 year ago)
Nice sir ..i understand dis topic in very easy way..thnx

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.