Solved

MySQL Where to Start

Posted on 2011-09-08
4
268 Views
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.

Thanks,
~sve
0
Comment
Question by:sventhan
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
yodercm earned 300 total points
ID: 36504127
These are my favorites:

PHP & MySQL For Dummies, Valde, Janet, Wiley Publishing, ISBN 0-470-09600
http://www.amazon.com/PHP-MySQL-Dummies-Computer-Tech/dp/0470096004/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1209218475&sr=8-1

PHP Bible, Converse, Tim and Park, Joyce, Wiley Publishing, ISBN #0-7645-4955
http://www.amazon.com/PHP-Bible-2nd-Tim-Converse/dp/0764549553/ref=sr_1_1?ie=UTF8&s=books&qid=1209218851&sr=1-1

SAMS Teach Yourself MySQL in 21 Days, Butcher, Anthony, SAMS Publishing, ISBN# 0-672-32392
http://www.amazon.com/Sams-Teach-Yourself-MySQL-Days/dp/0672323923/ref=sr_1_1?ie=UTF8&s=books&qid=1209218887&sr=1-1

PHP and MySQL Web Development, Welling, Luke and Thomson, Laura, SAMS Publishing, ISBN# 0-672-32672
http://www.amazon.com/PHP-MySQL-Development-Developers-Library/dp/0672326728/ref=sr_1_1?ie=UTF8&s=books&qid=1209218925&sr=1-1

Build Your Own Database Driven Website Using PHP & MySQL, Kevin Yank
http://www.sitepoint.com/books/phpmysql1/
0
 
LVL 18

Author Comment

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

Assisted Solution

by:khairil
khairil earned 200 total points
ID: 36504717
Hi,

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.
0
 
LVL 18

Author Closing Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP/MySQL Time slot availability check for staff id and all staff 5 94
mySql Syntax 7 44
Selecting specific rows 3 49
PHP connection to remote AWS MySQL RDS 4 64
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

937 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

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now