It has been a while since last time I posted review here. But today I watched very nice, interesting and friendly presentation that covers basic theory and stright away I wanted to add it into this section.
I highly recommend to watch this presentation. In nutshell it covers the best practices that we all know or should be aware of when working with databases, and quering it to obtain various information it holds. Author of this presentation Anna Filina shares all of this information using friendly language supported with good examples.
I really enjoyed watching this presentation: short, interesting, easy to follow and covers things that if applied to my daily work would help to improve significantly performance of a database or web application.
You can find presentation on Anna's website: speed up your database