Background:
I have an interview some time next week (for a Jr position) that requires SQL Server. The job descriptions states "Must be able to score high in a C# and a SQL Server design test."
I feel I'm solid on the C# portion, and I think I'm pretty good on implementation-agnostic DB design (Reread "Mastering Data Modeling" by Carlis & Maguire that was taught in college, and read through "Database Design For Mere Mortals" over the past week). I have a decent knowledge of basic SQL, but mostly from classes 2 years ago (I'm not using a RDBMS at current work), and in my outside project I'm using LINQ to SQL so not much of direct DB interaction, and it's more of the program driving the need for data, whereas for this position I get the sense that it's the other way around.
What are some good online resources or tutorials to get up to speed? This is a junior position so I'm not looking to be an expert in a few days or anything, but I at least need to know what I'm talking about. Ideally I'd like something similar to Dive Into Python which I highly enjoyed. Looking for something that can be digested in 2-3 days or so for kinda translating theory into practice, and also some brush up on syntax, and things to be aware of that are specific to SQL Server/T-SQL.
Also maybe some basic ADO.NET resources might be good too. The company I'm interviewing with hasn't upgraded to .NET 3.5 yet, so LINQ to SQL and Entity Framework aren't going to be available. Not really sure whether I'll need that much for the interview, but still good to know.