NETTUTS.com has posted Day 2 of their "CodeIgniter from Scratch" series of vidcasts following up on the first day.
Continuing on from day 1, today, I'll teach you five different ways to write select statements for your database. If you haven't watched the first entry in this video series, don't worry; each video can function on its own as a single tutorial. Having said that, I highly recommend that you watch each screencast.
You can watch the vidcast through their in-page player or just grab the source code for their examples and get to work.