Lombardo86 Registered User
#1

Hi,

Am hoping somebody may be able to point me in the right direction. I am looking for somewhere to practice my SQL. I am going to be getting back into it soon and would like to brush up before then.

I am looking for any online resources that i would be able to run some triggers/procedures/not too complex queries jst as a refresher without the whole installing a DB and web servers etc.

Is there anything online that would facilitate this or what is the easiest way to go about it?

Any help appreciated - Thanks

amen Registered User
#2

Download the free versions of MySQL or MS SQL Express

seamus Dental Plan!
#3

You can get huge sample databases from Microsoft which you can load into an MSSQL Express server:
http://msftdbprodsamples.codeplex.com/

duffman85 Registered User
#4

XAMPP (apache, mysql,php) from here(www.apachefriends.org/en/xampp.html) is installs and configured in a few clicks. Can run queries from command line or phpmyadmin interfaces

SqlServer Express and the Management Studio are straightforward enough to get going on and as Seamus says there's lots of sample dbs to play with.

drag0n79 Registered User
#5

Lombardo86 said:
Hi,

Am hoping somebody may be able to point me in the right direction. I am looking for somewhere to practice my SQL. I am going to be getting back into it soon and would like to brush up before then.

I am looking for any online resources that i would be able to run some triggers/procedures/not too complex queries jst as a refresher without the whole installing a DB and web servers etc.

Is there anything online that would facilitate this or what is the easiest way to go about it?

Any help appreciated - Thanks


I don't think you'll be able to look at triggers, procedures etc. without doing the installs as others have mentioned above.

But if you want to practise some queries online, look here

http://db.grussell.org/sql/

(use the cat command to view the tables in the database)

Lombardo86 Registered User
#6

Hi Everybody.. thanks for the links/resources there. Been a while since i was into the detail here so excuse the basic question!

Will have a look around here and ill post back some useful feedback over the next while should anyone else be in my position in future

Want to share your thoughts?

Login here to discuss!