Database Lesson #7 of 8 - Database Indexes

Dr. Soper gives a lecture on database indexes. Topics covered include index concepts, linear vs. binary search strategies, estimating index storage space requirements, B-tree indexes, bitmap indexes, hash indexes, and clustered vs. non-clustered indexes.

[@jimc1499]

Dr. Soper,
Thank you for this series for SQL Database Indexes. The series has great detail, clarity and presentation.

[@rajendrasinghbisht6165]

A simple and nice and presentation about how database indexes works !
Thanks Dr. Soper !

[@RicardoFerreira-rc7ux]

this was by far the best index explanation I have ever seen

[@jefftrimmer3221]

Excellent information. Though I had to increase the play speed to 1.5 to maintain my sanity.

I'm glad I was not the only one.

[@walidzein1]

try at 0.25 speed, it will become ASMR

[@ColdFuse96]

I go 1.5 normally on all of his videos, but then that became the "normal speed", so I went to 1.75 and was still able to follow him with no problem.
His content is great, but I need that speed boost to for it to maintain my attention 😂

[@channabasappaheralgi5723]

Gave a clear cut understanding on lot of DBMS concepts!!!!!!!!!! Thanks for that superb video.

[@kishankumarJha]

sir, it was the best tutorial I ever had. please keep updating ur tutorials

[@shivankchopra8552]

Best video for understanding indexing on youtube! It compliments well with the indexing lessons given in Korth (Database System Concepts).

[@Luccient]

This video helped me immensely, many thanks!

[@hiteshjain986]

Excellent Lecture !Lot of Basics covered ! Thank you so much !

[@sent4dc]

Good lecture. Although let me save you 20 minutes -- watch at x2 speed.

[@didierfolly]

Thanks for the very well explained topic. Many things popped up to my mind after listening to your video. Keep doing such as great and interesting videos.

[@fillheimer]

Best argument for organization I have ever understood.

[@Jorrissie]

Very well explained with practical examples. Thanks!

[@tokierekowei9796]

Thank you So much Dr. Daniel. Very informative and very clear to understand

[@mksmurff]

Worth every minute. Thank you

[@thulanimoyana6626]

Straight to the point. Perfect.

[@dainova]

Magnifico!!! Thanks much Doc. Absolutely super!

[@bojanzivkovic8934]

Great job, very nice explanation of very important topic for any DBA.

[@ibtisamj4035]

Thanks Dr. Soper.

[@niranbhandari1327]

Thanks for all the efforts in distributing your knowledge.............

[@davejoseph9799]

Nice presentation and the tone (voice ) is perfect for a demo

[@aselabiz3757]

thank you so much sir :) i watched many videos coudnt understand but your one helped me a lot :)

[@1Watchmerock]

You video was excellent. I really learned a lot from your explanation. Thank you so much for uploading this video.

[@hugecraig]

Thank you Dr Soper

[@danistdaniel]

i like this lessons Database keep it up guys

[@nigh7ynigh7]

Thanks. This video helped a lot!

[@kidz_code]

Thank you :)

[@satishgupta470]

Awesome lecture, to be honest it's a very helpfull lecture, thanx alot sir for making such a awesome tutorials.
Can i get the pdf of your notes for quick revision during exam or interview time

[@AnjaliChadha]

Thank you Dr.Daniel for the lucid explanation.
I have a doubt though; the B Tree Index you explained in the video, isn't that B+ Tree in actual ?

[@taab84]

Great video

[@anuradhaprabhathkadurugasy4515]

Great video. well explaining.

[@2everywhere285]

Thank you sir. Very good lecture.

[@maryjain1762]

great presentation for beginners....

[@avalon2199]

Great stuff.

[@chineseprogrammer]

thanks alot doc. You did a better job than my uni lecturer. I doubt he taught us indexes unless I'm mistaken. I don't have a particularly good memory

[@opti420sk]

Super good explanation and very clear

[@Web3ForDevs]

Thank you sir. nice lecture

[@danielalmeida7140]

This is the second time I come back to this video. Still amazes me how great the whole playlist is. I don't understand, however, why there must be only one clustered index per table.... can't we just update the leaf nodes whenever we update the table?

[@coreblaster6809]

"Simply put: a clustered index IS the table. It organizes the data itself in a certain way.
Thus, you can have only one clustered index per table."
- Koen Verbeeck

[@laynovaed3219]

Very informative.

[@jakubwszokowski1294]

Maximum search time in ordered table should be rounded up, isn't it? For instance: There're 5 steps needed to find Al Rabeeah.
But the most thing - your course is awesome & helped me a lot, thanks!

[@MrJonnis13]

Amazing tutor!
(by a tutor)

[@Ninadeniso]

Good and well structured information. But the speech is very slow. Listening at speed of 1.25 or 1.5 worked well.

[@ShantamBhavsar]

Awesome

[@elham-elliem7123]

Very great , thank you , as a suggestion if there were series of added exercises as quizzes with solutions and explanations under video of exams and exercises about each topic they would be very helpful as well
Very great , thank you , as a suggestion if there were series of added exercises as quizzes with solutions and explanations under video of exams and exercises about each topic they would be very helpful as well

[@na0m1fes51]

thanks bro

[@amanajib]

thx

[@t-poseriku6265]

I'm not the best at algebra, and I wanted to understand on 5:52, in average = (22+1) / 2 =11.5, what does the '1' stand for?

[@ShivPrateekSharma]

good ..

[@allynooallynoo5983]

When doing a linear average for a database why is it (n+1)/2 instead of (n)/2????

[@marywise3462]

x2 SPEED is a must YA'll

[@racialwhale]

been watching youtube on 1.75. just tried normal speed to see how it was and bruh. that is not happening for me.

[@johnlockie]

Raise your hand if you listen to these on 2x 🖐

[@bartpeters7682]

valt tegen daniel

[@joshuaburnworth8611]

My instructor provided links to your videos for us to listen to. They chose poorly. You talk SO SLOWLY. I can read ten times faster (at least) than you talk. It. Drives. Me. CRAZY!!!