?

Log in

No account? Create an account

Previous Entry | Next Entry

MySQL

Does anyone have any recommendations on how I can advance my ability with MySQL database structures?  I know a lot of the basics, but I've never done anything truly advanced, and I'm looking to do some fairly complicated stuff for persistant browser-based game development.  I've posted to a forum specifically for that topic, but the most recent activity on the forum was two weeks ago, and I'm no good at navigating major forums.  (I can drown easily in the information overload.)

I'm looking to be able to learn more about methods of structuring a MySQL database without spending money to do it.  I may eventually see about taking classes for this sort of thing, provided financial aid options work out.

Comments

( 8 comments — Leave a comment )
mindtrip101
Nov. 9th, 2008 01:12 pm (UTC)
I've done a little MySQL work in the past. I used Webmin and phpMyadmin as the primary tools to get into the database and made the needed changes. Very easy tools to get in there and muck about. Good luck
aekiy
Nov. 10th, 2008 03:02 am (UTC)
Yep, I use phpMyAdmin, which is pretty nice. I just need to learn more about how to appropriately structure a database, store functions, and that sort of thing. Mostly the structuring part is what interests me at some point. I can scrape together things on the fly, as I usually do, but this is a much bigger project than I normally attempt.

Thanks, though, and hi, by the way. ^*^;

Edited at 2008-11-10 03:03 am (UTC)
sixteenbynine
Nov. 9th, 2008 03:55 pm (UTC)
I'd actually recommend a book -- that way you can take the lessons you need from it at the pace that works best for you. Having a guru at your knee is always a good thing, though, and while I wouldn't consider myself to be on the guru level I've done enough work with MySQL courtesy of phpBB and Movable Type to have a good idea of how things snap together.
aekiy
Nov. 10th, 2008 03:05 am (UTC)
::noddle:: The most important thing for me right now is learning how to properly design and structure the database. I've slapped plenty of tables together myself before, but I'd like to make sure I'm doing as well as I can with this, not just cobbling something together that happens to function.

I'll check the library for reference books, since I'd like to try and pinch pennies as much as I can at this point. A book is a worthwhile investment, but the next couple months are very uncertain for me.
tlttlotd
Nov. 9th, 2008 10:32 pm (UTC)
I'm not very good with MySQL, but if you need a comprehensive reference for it I highly recommend Paul DuBois' tome MySQL, which is probably in its third or fourth edition by now. It's huge, well over a thousand pages, but you can look up literally anything in it, from how to compile it yourself to most anything admin-related.
aekiy
Nov. 10th, 2008 03:14 am (UTC)
Thanks. I see several MySQL books by Paul Dubois on the Barnes & Noble Web site. Four of them are over 1000 pages: MySQL Cookbook (November 2002), MySQL: The Definitive Guide to Using, Programming, and Administering MySQL 4, 2nd Edition (January 2003), MySQL, Third Edition (March 2005), and MySQL (September 2008). Am I looking for that last one? It looks like those may just be the four different editions of the same book, with the last being the most recent edition, but I'm not certain.
tlttlotd
Nov. 10th, 2008 04:38 am (UTC)
The one you want is MySQL: third edition. That's the end-all-be-all of MySQL, updated for MySQL v5.x.
aekiy
Nov. 10th, 2008 04:43 am (UTC)
Awesome! Thanks.
( 8 comments — Leave a comment )

Profile

lilga
aekiy
Gorotsuki Tenshi
miniverse.nu

Latest Month

August 2012
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031 

Tags

Powered by LiveJournal.com
Designed by Lilia Ahner