I don't know about you, but If I'm trying to learn something new, I only seem to benefit from watching a video, and then doing lab-type exercises to practice what the video was demonstrating;
google was my friend here, and i searched "free SQL Server online training"
found an online blog as an example,where someone has put up a dozen or so videos:http://weblogs.asp.net/scottgu/archive/2007/03/01/free-sql-server-training-videos-and-other-good-data-tutorial-pointers.aspx
There were lots of other examples out there.
personally, I find this site to be one of the best learning resources in existence.
Every day I find forum posts that interest me, copy and paste the code to SSMS, and then build a potential solution.
It's the actual thinking about the issue, and trying to build a strategy to solve the problem that is the #1benefit for me.
I often post my suggested solution, but most especially, I compare it to what other people have posted. There's more than one way to resolve any issue, and you learn from how other people tackle the same problem differently.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!