views:

285

answers:

6

I'm looking for a free online SQL interpreter that also has a database associated with it. I want to play around with SQL statements, but I don't want to setup my own database. I've looked around google for a bit, but I only found one web site that has interactive courses, an interpreter functionality and a small database: http://sqlcourse2.com/

Does anybody know of a better SQL interpreter and database?

A: 

Why don't you want to set up a database? It is quick and easy to do.

Check the Express version of SQL Server. It is also free.

SQL Server Express WebLog: How should I Install SQL Server 2008 Express

Mitch Wheat
I reinstall my OS more often than I install a DB. Sometimes I just need to experiment with simple queries, so installing a DB just for that is just not worth it for me.
Lirik
use a virtual instance and start it up when you need it.
Mitch Wheat
+1  A: 

My only advice is that if you're going to learn SQL it would be worth learning also how to install the thing. Most DBAs I know are also fairly adept systems administrators as well and for good reason. Setting up real databases can be difficult to do well.

So go out and get a copy of an easy DB with a good ui and get started. If you're on the mac you already have MySQL and you can use Sequel Pro as the UI. If you're on windows I'd really recommend PostgresQL and the excellent PgAdmin.

SQL isn't just syntax anymore, I know the spec says otherwise but if you're interested in learning about databases for a job just groking the syntax isn't enough.

Chuck Vose
@Chuck I need it more to try some quick queries... I don't do much with databases. I work with databases so infrequently that installing it is an inconvenience, I re-install my OS more often than I install databases. I do get your point tho :).
Lirik
+2  A: 

Oracle offers free hosted workspaces for evaluation at apex.oracle.com.

Thilo
+2  A: 

SQLite is the fastest way to go. http://www.sqlite.org/

It is supplied with a command-line utility to execute queries. The database is kept in a single .sqlite3 file. As simplistic as it gets.

glebm
A: 

Have a look at MySQL free hosting here...

Hope this helps, Best regards, Tom.

tommieb75
+1  A: 

I've used and recommended this site before to friends.

http://www.sql-ex.ru

It has exercises that you write SQL for and test on a live database. They also have decent faq's, guides, forum discussion based on exercises, ect... Pretty good source if you are starting up or want to test your skills or see more then one way to approach a problem.

Jarek