SQL noobie

[capr]

Hey, I am just starting with SQL and would like a GUI took that works well with MySQL SQL-server and Oracle. 

 

I just need to practice making quarries and pulling data from multiple tables and such. I hear it's a good idea to get comfortable with one interface that works with all of them.

 

your guidance is much appreciated. I am learning through nuggetlab.

 

thanks,

 

[Kalint]

  On 12/02/2014 at 18:37, capr said:

Hey, I am just starting with SQL and would like a GUI took that works well with MySQL SQL-server and Oracle. 

 

I just need to practice making quarries and pulling data from multiple tables and such. I hear it's a good idea to get comfortable with one interface that works with all of them.

 

your guidance is much appreciated. I am learning through nuggetlab.

 

thanks,

>> https://www.coursera.org/course/db <<

 

I'm not aware of any GUI that works with all of them.  Frankly I see no reason for a GUI to do it all.  Each DB has their own console for making queries.

[James Rose]

Check out Toad, not free but nice.  http://www.quest.com/toad/

[Jason S. Global Moderator]

ive never cared for MySQL, personally. I learned the majority of my "skills" (im still not very good) using MSSQL. Perhaps you download a copy of Express and have at it.

[+Biscuits Brown MVC]

You could also try Oracle's SQL Developer tool. I'm pretty sure it's free and I think it will connect to MySQL as well as Oracle. 

 

Here's a link SQL Developer

[exotoxic]

For MySQL try Workbench

http://www.mysql.com/products/workbench/?p=1169

[kjordan2001]

Not the prettiest of clients, but SQuirrel SQL Client will support anything that has a JDBC driver: http://www.squirrelsql.org/

 

Several IDEs (Eclipse, Intellij IDEA, Netbeans) have SQL clients too that will support most server types out there too if you plan to connect to them programmatically.

[articuno1au]

Navicat.

 

http://www.navicat.com/

 

It supports everything. Their licensing can be a bit full on, but it will do everything in a single app.

[riahc3]

Hello,

  On 12/02/2014 at 19:27, Jason S. said:

ive never cared for MySQL, personally. I learned the majority of my "skills" (im still not very good) using MSSQL. Perhaps you download a copy of Express and have at it.

You cant advance much then; MySQL is supported on A LOT of platforms and you can use MySQL as your DB in Windows Server. MS SQL is more Microsoft products and that's about it.

 

  On 12/02/2014 at 19:54, exotoxic said:

For MySQL try Workbench

http://www.mysql.com/products/workbench/?p=1169

Without a doubt. I use Workbench at work.

[capr]

thanks everyone. I came to the conclusion that it's better to just start somewhere and then maybe get well rounded and find something with features I need/like. Workbench seems fun so far, easy to install and figure out. Having a blast so far. love the diagrams.