Chances are that if you’re a Linux and open source geek like most of the visitors to Foogazi are, you probably know a little bit about MySQL. But if you’re a true geek, you want to learn all there is to know. Databases power just about everything on the Internet these days, and MySQL is one of the most popular web databases languages there is. Not only is it a great tool, but it’s a great language to know.
Here are some great tips to help you learn MySQL.
Visit MySQL Forums
As with anything you’re trying to learn, it’s always best to become an active member of the community. Not only will you gather valuable information from people all around you, but you’re in a place with other likeminded people. Being active in forums is key to learning the most you can. MySQL forums contain a ton of great tips and useful information.
Here are a few MySQL forums for you to check out:
MySQL Mailing Lists
Just as important becoming an active member in MySQL forums is, it is also important to participate in mailing list discussions. Some of my biggest “oh I get it” moments have been from emails posted to mailing lists. Along with forums, mailing lists are a great place to throw out a question and get a quick answer.
Check out the only resource for MySQL Mailing Lists you need:
Planet MySQL is an aggregation of blogs and news from MySQL developers and users. This is site is a must resource. RSS, web browser, whatever way you like to read, this should be one of your most frequented websites when trying to learn MySQL.
Check out planet mysql here:
Official MySQL Documentation
The MySQL website offers a ton of useful documentation and resources, so obviously this is going to be one place you’ll want to frequent. The MySQL reference manuals are a must have when learning MySQL.
Check out the MySQL documentation here:
MySQL books are obviously one of the best resources to learn from. I personally prefer a tangible book I can bring with me anywhere to learn from.
Here are some of my favorite MySQL books:
- MySQL (4th Edition)
- High Performance MySQL: Optimization, Backups, Replication, and More
- Learning MySQL
- MySQL Crash Course
- MySQL Cookbook
Of all the things I’ve listed as being the best resources to learn MySQL, I must say for me, the most important one is active participation with the community. The more you ask questions, the more you learn. The more you teach, the more you learn. You can’t lose either way.
How do you prefer to learn? Have some more resources? Let us know in the comments!