SitePoint Sponsor

User Tag List

Results 1 to 12 of 12
  1. #1
    Visible Ninja bronze trophy
    JeffWalden's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,709
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Post Best MySQL Learning Book?

    I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::
    TAKE A WALK OUTSIDE YOUR MIND.

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For a more advanced book, check out SQL Hacks by Andrew Cummings, while not mysql specifically, the authors go to lengths to provide necessary tweaks to the code. They examine SQL Server, Oracle, MySQL among others and make sure the code runs on at least two of the platforms. Many of them run on MySQL via examples.

  3. #3
    SitePoint Zealot unformatik's Avatar
    Join Date
    Aug 2007
    Location
    216/GMT+1
    Posts
    156
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Hyperbolik View Post
    I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::
    I think that :

    1/Simply SQL by Sitepoint
    2/SQL Essential Training by Lynda.com

    are the best couple!

  4. #4
    SitePoint Guru
    Join Date
    Dec 2005
    Posts
    982
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm a big fan of http://www.amazon.com/Practical-Data.../dp/1904151205 And you can get it VERRRY cheap now
    MySQL v5.1.58
    PHP v5.3.6

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by BrandonK View Post
    And you can get it VERRRY cheap now
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Addict
    Join Date
    Dec 2007
    Posts
    348
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SimplySQL !!!

    It teaches you so much in relatively few pages!

  7. #7
    SitePoint Zealot
    Join Date
    Jun 2008
    Location
    Gloucestershire, UK
    Posts
    197
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got a good introduction to MySQL from Larry Ullman's "PHP and MySQL For Dynamic Websites", but I'd like to find a book to take me to the next level.

    Has anyone read "MySQL Cookbook" (2006 edition) by Paul Dubois, and is it any good? Otherwise, has anyone got any other suggestions?

    Cheers,

    Jon

  8. #8
    SitePoint Enthusiast
    Join Date
    Nov 2007
    Location
    Medford, Oregon
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by unformatik View Post
    I think that :

    1/Simply SQL by Sitepoint
    2/SQL Essential Training by Lynda.com

    are the best couple!
    Still trying to get this stuff down myself, I would fear getting an "SQL" book rather than a MySQL text because it is already difficult enough stuffing the syntax into my gray matter.

    Any books for slightly dumb people that focus on just MySQL, and cover both the basics and then maybe a teensy bit of optimization and stuff like that?

    I noticed yesterday that my own Php/MySql books only offer the essentials (update, delete, insert) where database instruction is presented.

    Wow, this forum has a million smilies to choose from.


    Randal
    Visit http://meetchristians.com. Not today tho - She's broken

  9. #9
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by randalusa View Post
    Still trying to get this stuff down myself, I would fear getting an "SQL" book rather than a MySQL text because it is already difficult enough stuffing the syntax into my gray matter.
    i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  10. #10
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,077
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Build Your Own Database Driven Website Using PHP & MySQL(new edition due out at the end of the month)
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  11. #11
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,875
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by r937 View Post
    i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql
    I agree Rudy. Of all the SQL books I have seen yours looks to be the best book for beginners.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">

  12. #12
    SitePoint Enthusiast
    Join Date
    Nov 2007
    Location
    Medford, Oregon
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937
    i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql
    Quote Originally Posted by felgall View Post
    I agree Rudy. Of all the SQL books I have seen yours looks to be the best book for beginners.
    May as well give 'er a look. Could be the presentation will be just right. Thanks.


    Quote Originally Posted by SpacePhoenix View Post
    Build Your Own Database Driven Website Using PHP & MySQL(new edition due out at the end of the month)
    I will have a peek at this one too.

    Great to have a couple places to begin at least.


    Randal
    Visit http://meetchristians.com. Not today tho - She's broken


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •