Forum Moderators: open

Message Too Old, No Replies

mysql software newbie

         

Walter Sobchek

1:25 am on Feb 21, 2008 (gmt 0)

10+ Year Member



Hi,
I am just starting out learning sql and I was wondering if there are any free database programs that use the mysql platform that I can use to practice building databases. Any help would be appreciated, thanks!

jtara

3:11 am on Feb 21, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



are any free database programs that use the mysql platform that I can use to practice building databases.

There are hundreds to thousands of them.

Can you be more specific as to your needs?

If you just want to practice "building databases", you have everything you need within MySQL itself. You can use it to create, populate, modify, and view a database.

It might be useful, as well, to get the MySQL Query Browser and MySQL Administrator (GUI tools.)

Now, if you want to write some program or website that uses MySQL, that's another matter. You need to do some narrowing-down, as I think my fingers would be tired after typing-in those thousands of program names... :)

Walter Sobchek

5:37 pm on Feb 21, 2008 (gmt 0)

10+ Year Member



Thanks for the help! Right now I'm just interested in "building databases" and getting familiar with using mysql.

Walter Sobchek

5:37 pm on Feb 21, 2008 (gmt 0)

10+ Year Member



Thanks for the help! Right now I'm just interested in "building databases" and getting familiar with using mysql.

jtara

5:46 pm on Feb 21, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Well, then, mysql itself and the two GUI tools I mentioned are plenty.

This will give you all you need to learn to install, maintain, and use MySQL, and learn it's SQL language.

I'd suggest a good book, as well. Since you aren't interested in this point in any specific web technology but in MySQL itself, get one that focuses on MySQL itself, with perhaps some overview chapters on web technology (scripting, etc.) to give you an idea of how it can be used in a website scenario.

I wouldn't get something that focuses on "MySQL and PHP", etc.

I have the DuBois book, and find it comprehensive and understandable.

One suggestion I would make for acquiring such a tome cheaply is to check the "used" section on Amazon and buy from their third-party sellers. You can get all but the very latest books in decent condition for much less money. (I mention that because I notice that that's how I got that book...)

Walter Sobchek

5:49 pm on Feb 21, 2008 (gmt 0)

10+ Year Member



Great! Thanks for all the help!