SQL question

[dcmk]

Okay basically i don't want to connect to an sql server.

all i want to do is basically test out some functions build up my confidence in doing sql statements without the need for all that extra element.

i installed Oracle i couldnt do anything without a server first. Im at university and need to do some exercises so anyone can recommend anything where i would be able to handle my data without all that

[elkatas]

Im at university and need to do some exercises so anyone can recommend anything where i would be able to handle my data without all that

I don't really know any training software for SQL, but you could install MySQL server to your own PC, and access command line client. MySQL server is quite small and doesn't hog resources at all, unlike Oracle which is meant for really heavy duty. Even though MySQL uses its own variant of SQL-language, I suspect that you are going to do so simple queries that it doesn't really matter.

[NaveT]

Just install SQL 2005 Express edition. Its free. It runs locally on your pc, and should get you up and running in no time.

http://www.microsoft.com/sql/editions/express/default.mspx

[chaoticjelly]

I ran the latest edition of Oracle on my laptop last year no problem. It took a while to get the server set up but once I did that I was able to freely run queries on my database after logging in using SYSTEM. Just make sure that on installation you choose a different password for something like the SYSTEM user account, then you can use all commands etc on the database.

IIRC it was Oracle Database, and Oracle Developer I installed, in that order.