• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Getting to Intermediate SQL Server Level

xux42

Still gathering requirements...
Joined
Jan 12, 2009
Messages
94
Likes received
0
Thanks received
0
Location
Gloucester & London
Hi

I'm taking a break from work - contract not renewed and didn't bother looking.

Experienced in DB2 and SQLBase.

What's the best way to get up to speed with SQLServer which I have only used a bit. Need to come across as proficient in an interview.
Can take 2/3/4 weeks.

Ta
 
You can download the latest developer edition for free.
 
Thanks all for the prompt replies.
I plan to start by Downloading SQL Server 2008 Express Edition and using some the of the books and DVDs you are suggesting.
I assume 2008 is backwardly compatible, so exercises in 2000/2005 Books/DVDs will work with it....
 
I assume 2008 is backwardly compatible, so exercises in 2000/2005 Books/DVDs will work with it....

Not exactly. The 'Enterprise Manager' GUI in SQL Server 2000 became the rather different 'Management Studio' in 2005/2008.

If you're doing stuff mostly in query format rather than with the GUI, you should be OK with literature written for the 2000 version, otherwise you're best off working with stuff written for 2005 upwards.
 
Get to grips with Transact SQL (T-SQL). It's easier than Oracle PL/SQL and is used in both SQL Server and Sybase, so if you know one you pretty much know the other.
 
You can download the latest developer edition for free.

Developer edition is NOT FREE (through any legal channels)

It can be legally purchased for about £50 though (legal downloads from MS might be even cheaper)
http://www.amazon.co.uk/Microsoft-D..._1_1?ie=UTF8&s=software&qid=1251151185&sr=8-1

My opinion is... if you can spare the £50 then get the developer edition over express. The differences between the editions are big enough for you to find yourself in a pickle when you try and apply your knowledge within a corporate environment. Plus you'll get the other components - SSIS, SSRS and SSAS

Don't worry too much about SQL Server using up lots of resources. Unless you've actually got 10's of gigs of data on there and some really badly optimised tables and queries you'll find it has a pretty small foot print
 

Advertisers

Back
Top