Top University Courses for Free

I just received an email from a friend with links to top university courses for free. I checked them out and they are indeed free and what’s great about them is that they can contain classes for the entire semester and not just one class. They also get updated quite frequently so you can follow along with the professor. My favorite is the Berkley Webcasts which seems to have the most courses and you can subscribe to RSS feeds for each course.

Stanford free Courses
http://see.stanford.edu/default.aspx

Yale free Courses
http://oyc.yale.edu/

MIT free Courses
http://ocw.mit.edu/OcwWeb/web/courses/courses/index.htm

UC Berkeley YouTube Video Courses:
http://youtube.com/ucberkeley

UC Berkeley Webcasts:
http://webcast.berkeley.edu

I’m still here and some great resources

Well, after a long break from blogging I am back. We have a new addition to the family so that kept me away. Actually, that and just being lazy to blog really.
Anyway, I recently came across some useful resources on SQL 2005 and thought I would share:

JumpStartTV
Great intro videos for beginners wanting to learn SQL 2005, SSIS, SSAS, etc. They are free but you have to register.

TechNet Virtual Labs: SQL Server 2005
These labs include SSAS, Management Studio, SSIS, Data Mining, etc.

How to use rank function in SQL Server 2005
A very easy to follow query example on the ranking functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE