In my current job, I get to write data extracts.
eg. extract data from an SQL database, using Microsoft Access as the front-end. Not my preferred tool, but it’s what I’ve got.
Thought it would be useful to brush up on my T-SQL, so I purchased the book on the right.
Best darn little book I’ve found on Transaction SQL. The 10 minutes refers to each lesson. And there are 30 lessons all up. This will be a book which I’d going to end up using as a quick reference.
Now if you want to teach yourself T-SQL, I’d suggest the following:
- Sams Teach Yourself Microsoft SQL Server T-SQL
- SQL Server 2005 Express Edition with Advanced Services
- .Net Framework version 2
(if you don’t already have it)
- Membership of SqlServerCentral.com (it’s free), the question of the day is worth it for knowledge reinforcement.
Update August 2009:
Writing SQL Queries: Let’s Start with the Basics, by Microsoft is worth reading as well.