MySQL Where to Start

Posted on 2011-09-08
Medium Priority
Last Modified: 2012-05-12
Dear Experts -

Hope all is well.

I'd like to learn MySQL (to manage few dbs). Please let me know good sources that I can use to start with.
Any web sites, books, etc., will help.

Question by:sventhan
  • 2
LVL 27

Accepted Solution

Cornelia Yoder earned 1200 total points
ID: 36504127
These are my favorites:

PHP & MySQL For Dummies, Valde, Janet, Wiley Publishing, ISBN 0-470-09600

PHP Bible, Converse, Tim and Park, Joyce, Wiley Publishing, ISBN #0-7645-4955

SAMS Teach Yourself MySQL in 21 Days, Butcher, Anthony, SAMS Publishing, ISBN# 0-672-32392

PHP and MySQL Web Development, Welling, Luke and Thomson, Laura, SAMS Publishing, ISBN# 0-672-32672

Build Your Own Database Driven Website Using PHP & MySQL, Kevin Yank
LVL 18

Author Comment

ID: 36504537
Thanks for your response and I'll take a look at those links....
LVL 13

Assisted Solution

khairil earned 800 total points
ID: 36504717

You are so good at databases, I think you won't have much issues on basic things like creating tables or databases.

You can start by installing the database itself, there are few tools use to manage MySQL like MySQL Workbench at mysql website, but my favourite is Toad from Quest. You can manage MySQL using MyPHPAdmin, but for you I not really suggested. You have to setup Apache to run MyPHPAdmin.

Try avoid using packaged solution such XAMP or LAMP, do it from basic and you will learn more, and you have more control on it.

For me, strongest point of mysql is it's in memory databases and it way to do clustering (like facebook), maybe it is something you like to explore.

If you are really want to focus on MySQL then try find books on it, avoid mixing with programming such bunlde with PHP matter (even PHP work best with MySQL). Some are pretty advanced and interesting, like, "High Performance MySQL" and "MySQL High Availability". Amazon can be your best friend here, look for the best rating and published dates.
LVL 18

Author Closing Comment

ID: 36506133
Thanks Experts... I'll dig more into it.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question