question

Ken avatar image
Ken asked

Learn SQL, which version should I get.

I want to learn to write SQL queries. I have a very good book, but I don't have a place to practice. I would to install express or some other version of MS SQL to practice but I do not know which version to go with?

sql-server-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered
  1. I suggest you start with Express edition. Both 2005 / 2008 will do just fine.
  2. If you dont want install here is an online lab available to you free of charge through the support of DELL, MaximumASP and PASS (Professional Association for SQL Server). http://test.sqlserverbeta.com/. Sample databases are already installed.
  3. If you need a quick reference to speed you up check out W3schools.

Good Luck!

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David 1 avatar image
David 1 answered

Express Edition is a free download but without some of the major features. http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

Developer Edition is the real thing. It has all the features of Enterprise Edition but at minimal cost (around $50 is typical) for non-production use only. http://www.microsoft.com/sqlserver/2008/en/us/developer.aspx

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image CirqueDeSQLeil commented ·
I highly recommend you shell out the $50 to get the dev edition. I would also go with 2008
3 Likes 3 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I agree. Developer edition and 2008. There's no reason to pick up 2005 at this point in the product's life cycle.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.