SQL Books? - HTML Forums

MatthewAnders · 08-14-2009, 07:56 AM

Hi all,

Are there any books that you would recommend reading to learn about MySQL? Something that is easy enough to pick up and take off with.

My boss has given me carte blanche to pick up books to help manage our company's website a little better. I also have to make a tracking system for some of our inventory.

I want to use PHP and SQL to make the tracking system and ill have him foot the bill for the book. I just have to do the hard part =D

Thanks!
Matty

Horus_Kol · 08-15-2009, 06:02 AM

SQL Functions from WROX - its the only one i've ever bought

drivle · 08-31-2009, 05:25 PM

Sorry this is a little late, but I recommend MySQL by Paul Dubois

It is a very good read that explains MySQL in a clear fashion and has a chapter on how to interface with PHP.

tigaga · 09-04-2009, 02:44 AM

hi ... MySQL is easy to learn. Below are some links where you can find some recommended books of MySQL. You may get some help from here.
Recommended Books of MySQL
PHP and MySQL Guide for Beginners

webappln · 10-21-2009, 02:00 AM

The whole problem with doing books on SQL is the general run-amuck that database vendors have been doing to the SQL standards. The result is that EAI-Enterprise Application Integration and Heterogeneous Database Joins remain very thorny problems - no thank yous directed to IBM, Microsoft, Oracle, Sybase and other SQL companies.

So as potential SQL author do you write a general SQL text and explain all the many and proprietary offshoots from the ANSI SQL standards - or do you specialize on one vendors database for the practical coverage that allows. Most writers have chose the latter approach - so that made finding some excellent general SQL texts an even more inviting challenge.
Buy from Amazon.com

The Simple, Easy But Effective Book - Trimble and Chappell's A Visual Introduction to SQL is just what the doctor ordered in getting the key concepts of SQL - tables, diagrams, and the basic SELECT, INSERT, UPDATE and DELETE commands across to users new to the database and SQL world. This is a very clear, concise and well diagrammed exposure to SQL. This reviewer liked the gentle injection of of ERD-Entity-Relationship Diagramming elements and figures without fuss showing how they can help to illustrate how SQL- and particularly SELECT commands work.

And the authors build up successively to more complicated GROUP BY with HAVING, then the various types of JOINS followed by subqueries with ANY and ALL. Because this was written in 1989, the JOIN mentions but does not feature the new left and right join syntax. And the commands are generic - users will find proprietary variation, as is their cavalier wont, from all the major vendors from IBM through Microsoft to Oracle. But most of the syntax will stand up and the database concepts come through with distinct visual clarity. Kudos to a well written book that has passed the test of time... and available at Amazon for less than $10, what a bargain.!