Database Website to Run and Practice SQL Query Online for FREE - SQLFiddle

Other day, I was looking for a website to execute SQL query online, since
I have uninstalled Microsoft SQL Server because of memory and CPU constraint
and I don't want to install it again, just for executing another query. Also,
installing database is pain, it takes time and eats up lots of resources e.g.
RAM memory, CPU etc; Given so many database to work with e.g. Oracle,
MySQL,
Sybase,
PostgreSQL and SQLLite, it's not really possible
to have all of them in your poor laptop. Fortunately my search leads be to this
wonderful site called SQLFiddle, this
is what exactly I wanted. This site offers support for lot of popular databases,
allows you to build your database schema online and execute SQL query on the
fly. I couldn't have asked more, It's a great resource to learn and practice SQL queries online. Apart from many sweet
feature, it also allows you to share your problem with community. If you are
writing a complex query and stuck in middle, looking for help, you can create
your schema on SQLFiddle and can share with your query to any forum or question
answer website like StackOverFlow or any forum. Having a collection of online database, just makes running SQL query a fun. You
can understand, how happy I am to know about this site, which let me to run and
practice my SQL queries online, that I am sharing with you guys. To be frank,
there is not many online site, where you can practice SQL query in your favorite database. I was looking for online website to test SQL query from
long time, but couldn't find anything like SQL Fiddle, May be I am not
aware if couple of them like SQLFiddle already exists, but this  a site every programmer, database
administrator, SQL beginners and SQL Experts must bookmark, a great tool in SQL
developer and any programmers armory.

How to run SQL query online without
installing database

SQLFiddle provides nice GUI for building
database tables and executing query against that table. It also run SQL query
within a transaction
and rolled it back, after running SQL query, this allows you to share your
schema and letting other people to run queries against that, without affecting
original table and data. You can share your queries with others by sharing URL
generated by SQL fiddle. In order to use SQL fiddle, to build database schema,
you can also login into website, and it supports openid from different provider
including Blogger, Wordpress, Google and yahoo. Others to whom you are sharing
your SQL code, who just want to change and execute query, doesn't need to be
login even, they can change schema, create SQL statements and run them online
in there browser anonymously, without login. Currently SQL Fiddle supports
following database, which I guess covers most of the popular relational
database, you probably encounter in a software development project.

MySQL 5.5.32

MySQL 5.6.6. m9

MySQL 5.1.61

Oracle 11g R2

PostgreSQL 9.1.9

PostgreSQL 9.2.4

PostgreSQL 8.4.17

PostgreSQL 8.3.20

SQLLite

MS SQL Server 2012

MS SQL Server 2008

Why you should use SQLFiddle

Well, there are many reason, why someone will prefer a website, which
allows them to execute there SQL statements, without installing database
locally in there computer. This is one of the strongest reason, programmer will
love SQL Fiddle, It just too much pain to install a database for practising
SQL Query, especially for beginners. I know lot of programmers, who give up
doing SQL exercises, just because they couldn't able to buy or install
databases, or they don't have luxury of having computers or laptop with 2GB
RAM, 100GB hard disk and dual core processor. I personally avoid to install,
lot of stuff to keep my laptop working, with software like popular Java IDE
Eclipse, Netbeans, your machine will slow down a lot. Apart from this most
important reason or I say luxury of running SQL query online without installing
database, following are couple of more reason, why every programmer should know
about SQL Fiddle and make use of it :

1) SQL Fiddle allows you to test your SQL Query in lots of database e.g. MySQL,
PostgreSQL, Oracle, SQL Server and SQL Lite, so if you just want to know,
whether a particular SQL query will be running fine in a particular database,
you can use this website.

2) Another reason for using SQL Fiddle is for sharing your problem and
getting better help from community. In order to solve a database problem or
create a complex SQL query, you need to know about database schema and data
itself, SQL Fiddle allows you to share your schema, data and query to the
community. you can create tables, writhe queries and can share URL into a
forum.

3) Apart from executing and testing SQL query online, you can also view
there execution plans, which will eventually help you to understand better how
your SQL was executed, which index is applied etc.

4) To be frank, it's practically not possible to have all the database in
your computer. I know, developer work in one database e.g. MySQL in one project
than another one e.g. Oracle in another project. This website allows you to
execute SQL query in host of database, so no need to worry, you can even use it
for migrating SQL query from one database to another.

Thank for reading this far guys. I am really pleased to share this
wonderful website, a must know for any Programmer, particularly for developer
who wants to improve there SQL skills and wants to practice SQL query without
going through the pain of installing database locally in there computers or notebooks. Let's
not forget to thanks the guy, who has created this wonderful tool for us, Thank
you so much Jake Feasel. So what are you waiting for, go and try sample SQL
Fiddle yourself :)

Source:http://javarevisited.blogspot.com/2013/10/database-website-to-run-and-practice-sql-query-online-free.html