Need a light weight IDE for practicing some SQL commands?

Question

So I was looking for a simple program that could run simple SQL commands like creating a table selecting and stuff I don't want to get more deeper than that . I actually have CD of oracle SQL PLUS 8 but hell lotta hassles and this connect that address tnsname.ora **** . Is there something simpler install and go no professional development . It's in my high school course so anyone could suggest a simple ide whether online or downnloadable . Thanks
P.S please provide link too

Answer 1

It depends on your database.



SQL Server has their Express edition that is free and easy to install. You would use SQL Server Management Studio to connect to the database.



Oracle as you have already mentioned can be installed. After you install the database, you would use Oracle's SQL Developer to talk to the database. SQL Developer is a separate install, but is a great SQL Editor.



MySQL has their SQL Workbench that includes a SQL Query editor.



You could also go to http://sqlfiddle.com/. You don't have to download anything there. All of your queries would be written in your browser. But, you will have to read on how to get it setup for your practice.

Answer 2

get mysql and download the windows management studio for it.



My SQL you can install run a SQL command from the command line to allow remote connections into the DB, define ADO/ODBC connectors without too much effort.



Having dealt with many dDM systems over the years I will say Oracle is a cluster*uck for doing simple design and frankly costly over kill



you could download an install of MSSQL express if you are doing it in school you could get the developer thing for about 45 bucks.

Answer 3

You can only learn these by using them, as they are quite complex commands and require additional commands added to the queries to make them work without errors or corrupting data. Your best option is to study the most standard query language, used in mysql. Look at the mysql manual, just search for that as it is on line.

Answer 4

Hello,

You can download PHPmyadmin here http://j.mp/1no5l1V

I strongly recommend it.

good luck.

Answer 5

please go to this address



http://www.w3schools.com/sql/default.asp