Want to learn sql

[deep1234]

Hi guys, I want to learn SQL syntax. It is not exactly learning but refreshing my memory coz I learned it back in university. Well the thing is that I need a software that do my work on (for a week or two).

Can some one recommend a software for me? Can I use the SQL server 2008 express edition? coz I have the web developer and c# 2008 express editions and it will work along with them. Also, Will it slow down my pc?

System requiremnet:-

Asus commando

Intel Core2Duo E6750

4GB RAM

Nvidia 8600GTS

Vista 64

And thank you in advance.

[Brian M. Veteran]

Yes, you can use the express edition, although it's functionality is somewhat limited.

It will slow your PC down a bit to start with, as it has to launch the server when you boot, however, once it's logged in and running, you wont notice a difference. You could always do what I do, and have all of your server apps installed in a virtual machine - works just as well, and you can choose when you want them running :p

[deep1234]

It is possible to make the server don't launch when I boot the pc? and launch it when I want (also close it when I want)?

[p858snake]

if you just want to learn/revise basic syntax you could try http://www.uranganshs.eq.edu.au/home/dmcgu...query/index.htm

[deep1234]

Cool, Thanx :D

[andy2004]

It is possible to make the server don't launch when I boot the pc? and launch it when I want (also close it when I want)?

not played around in 2008 yet but in 2005 yes you go into sql configuration manager and set startup type. I have all the sql services set to manual then before i launch into visual studio team system just go into the sql config manager and manually start the services.

[Kami-]

Ye, set teh service to load manually, instead of automatically.

Also, if you don't want to use SQL Server Express, try MySQL - its Free too!

[Bazenga]

Don't lock yourself with SQL Server Express, try MySQL as F7S suggested.

[Kami-]

Thanks Ali :) FIrst person to recommend someone actually uses something I suggest :p

[CloudEngineer]

mysql and a teach yourself sql book :)

weather you run it in windows or on linux a vm is your choice