PDA

View Full Version : Learning MySQL?


Crone
11-19-2010, 11:52 AM
So just today, I figured out that learning MySQL would be a huge up to my "company value".

I'll admit, I've done not a single bit of google research on this yet, but thought I'd start by asking if anyone had any useful ideas on learning MySQL? I might see if my community college has any courses.

I don't know if I'd like it, as I tried to learn Visual Basic many years ago and I didn't really like that.

Thanks for any help.

nilbog
11-19-2010, 11:53 AM
Running your own eqemu server is good mysql practice.

Aadill
11-19-2010, 11:55 AM
Past Experience/Skills that would help you in this workplace environment:

I ran a home basement video game server on a cable connection using MySQL.


I like it!

mgellan
11-19-2010, 11:56 AM
There's bajillions of sites on the net, google them. The O'Reilly books (http://oreilly.com/pub/topic/mysql) are also highly recommended...

However learning MySQL is of limited value without a development environment to actually build screens and such - you might want to have a stab at learning PHP or Ruby on Rails as well..

Regards,
Mg

nilbog
11-19-2010, 11:57 AM
Past Experience/Skills that would help you in this workplace environment:

I ran a home basement video game server on a cable connection using MySQL.


I like it!

Doesn't matter how you learn to use sql. At least eqemu is a fun way of learning where you can visually see the changes you make.

Crone
11-19-2010, 12:00 PM
Hmm.. I'll check these things out. Thanks Mgellan. I have a feeling that my very limited knowledge of what my company uses MySQL for is just the tip of the iceberg.

I'm kinda like that one guy, that thinks he knows what that other department does, and based on that, wants to move into that department. :)

Aadill
11-19-2010, 12:01 PM
I know it was just a joke :)

Actually it's the PERFECT sandbox, as you said. You can do anything and immediately patch it in and have a full view of any alterations made. I like the recent work in finishing off the data miner for mob engagements. Backend and frontend results coming together $$$

It's like being a level designer and not only coming up with something fun but getting to test it out. The only difference is now you control the physics and objects, too.

P.S. You're God (of Norrath).

warrioman
11-19-2010, 12:06 PM
Doesn't matter how you learn to use sql. At least eqemu is a fun way of learning where you can visually see the changes you make.

How can one get involved in P1999 development? I don't really have much experience with Ruby/Perl/Sql but have experience with Java/Scheme/Python/C++. Would be fun to pick up new languages working on something awesome.....

mgellan
11-19-2010, 12:06 PM
Running your own eqemu server is good mysql practice.

Yeah, agree 100%, a good alternative to my PHP/Ruby suggestion, especially if you haven't done any programming in the past. If your implementation skills are a bit lacking you might try the AX_CLASSIC Repack (http://forums.axclassic.com/viewtopic.php?f=14&t=891), it installs a complete eqemu system as a turnkey install including MySQL and some tools.

Regards,
Mg

warrioman
11-19-2010, 12:13 PM
not to mention it's sad to see everybody is agnostic^^^

nilbog
11-19-2010, 12:33 PM
How can one get involved in P1999 development? I don't really have much experience with Ruby/Perl/Sql but have experience with Java/Scheme/Python/C++. Would be fun to pick up new languages working on something awesome.....

There is a sticky for source development submissions here: http://www.project1999.org/forums/showthread.php?t=6897

Step #1 would be to find an existing bug, fix it with the public source branch, and submit it to us.

For database development or scripts (sql/perl), speak with me on IRC.

Itchybottom
11-19-2010, 02:24 PM
NAY! Postgres! POSTGRES! ...but you can learn everything you need to know from MySQL in a Nut Shell, including good programming practices.

Crone
11-19-2010, 03:15 PM
Can get that in ebook form. Nice. I'll take a look at it, and then maybe setup my own eqemu server so I can start messing around with some things.

Thanks for the input guys.