test
Board index › Topical Discussion › Computers, Math, Science, and Technology

MySQL for home student user

Page 1 of 1 [ 8 posts ] 

Previous topic | Next topic

coralbell
Yellow-bellied Woodpecker
Yellow-bellied Woodpecker

User avatar

Joined: 5 Mar 2009
Posts: 53

13 Apr 2009, 2:20 pm

I am trying to teach myself MySQL and I am looking for suggestions on the best version for my home computer - Windows XP. A test version for my pc is adequate for now, while I learn. (The last time I tried to install it I got MySQL server by mistake.) I am also looking for a good, free, online tutorial site. I have a good handbook but additional tutorials would help a lot. For background - I am an intermediate Access user with basic relational db design skills. Any suggestions are welcome and thank you in advance.



Zand
Yellow-bellied Woodpecker
Yellow-bellied Woodpecker

User avatar

Joined: 2 Apr 2009
Age:27
Posts: 58
Location: New Hampshire

13 Apr 2009, 2:29 pm

Well I use linux for my server but a good site I know of is http://www.w3schools.com/sql/default.asp. Thats what I used to learn.



Ichinin
Veteran
Veteran

User avatar

Joined: 3 Apr 2009
Posts: 2,020
Location: A cold place with lots of blondes.

13 Apr 2009, 5:30 pm

You could use WAMPServer directly on windows:
http://www.wampserver.com/en/

It comes with Apache, MySQL and PhP (Wamp is Windows, Lamp is Linux) so you can start coding PHP directly and try out database applications in PHP.


As for management, i'd suggest WebYog:
http://www.webyog.com/en/downloads.php

It is a much more comprehensive GUI than the regular MySQL interface.


As for a tutorial, Zand already mentioned the best place :)


_________________
"It is far better to grasp the Universe as it really is than to persist in delusion, however satisfying and reassuring" (Carl Sagan)


peterd
Veteran
Veteran

User avatar

Joined: 25 Dec 2006
Age:63
Posts: 1,275

14 Apr 2009, 3:08 am

Why not pick up an Eclipse with the JPA tools and add Sun's latest Java and MySQL to it. It'll all work pretty well straight out of the box and the tutorials come built into the Eclipse Help.



AgentCROCODILE
Snowy Owl
Snowy Owl

User avatar

Joined: 16 Sep 2008
Age:127
Posts: 165

14 Apr 2009, 6:15 am

You could always install a virtual machine (MS Virtual PC or MS Virtual Server) and install Ubuntu Server on it - select LAMP package

LAMP is a very reliable combination for a Web server.

Then of course as far as teaching yourself is concerned you can find a PHP IDE (not sure anyone tried NetBeans yet?) - and voila!



Ichinin
Veteran
Veteran

User avatar

Joined: 3 Apr 2009
Posts: 2,020
Location: A cold place with lots of blondes.

14 Apr 2009, 12:27 pm

I have tried Netbeans, but with Java.

NB is a capable GUI and all you need as a beginner. I would like to recommend Eclipse and all its über cool features, it is not good for a beginner to start coding in a complex environment.

So, NB could be a good GUI to start with. Or to scale down complexity even more you can use the text editors that come with the system.


_________________
"It is far better to grasp the Universe as it really is than to persist in delusion, however satisfying and reassuring" (Carl Sagan)


AgentCROCODILE
Snowy Owl
Snowy Owl

User avatar

Joined: 16 Sep 2008
Age:127
Posts: 165

14 Apr 2009, 7:23 pm

Ichinin wrote:
I have tried Netbeans, but with Java.

NB is a capable GUI and all you need as a beginner. I would like to recommend Eclipse and all its über cool features, it is not good for a beginner to start coding in a complex environment.

So, NB could be a good GUI to start with. Or to scale down complexity even more you can use the text editors that come with the system.


Having tried Eclipse for several months before dumping it due to frustration, and the fact that it used to basically "self-destruct" I would not recommend Eclipse.

I must say Eclipse does have a cool range of plugins.



coralbell
Yellow-bellied Woodpecker
Yellow-bellied Woodpecker

User avatar

Joined: 5 Mar 2009
Posts: 53

14 Apr 2009, 9:44 pm

Thank you everyone for taking time to advise - will report back when I get everything set up. Cheers.