Learning MySQL and MariaDB
Heading in the Right Direction with MySQL and MariaDB
Publisher: O'Reilly Media
Final Release Date: March 2015
Pages: 408

If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.

Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.

  • Create and alter MySQL tables and specify fields and columns within them
  • Learn how to insert, select, update, delete, join, and subquery data, using practical examples
  • Use built-in string functions to find, extract, format, and convert text from columns
  • Learn functions for mathematical or statistical calculations, and for formatting date and time values
  • Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
  • Use APIs to connect and query MySQL and MariaDB with PHP and other languages
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyLearning MySQL and MariaDB
 
3.0

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

67%

of respondents would recommend this to a friend.

Reviewed by 3 customers

Displaying reviews 1-3

Back to top

 
3.0

A Great Struggle... Could Use a Good Edit

By Aaron the Tech

from Somerville, MA

About Me Sys Admin

Verified Reviewer

Pros

  • Easy to understand
  • Helpful examples
  • Well-written

Cons

  • Too many errors

Best Uses

    Comments about oreilly Learning MySQL and MariaDB:

    The author of this book does a great job teaching the reader MySQL, and the exercises at the end of each chapter really make you think through what you're doing. A+ on pedagogy and content.

    However, the book is also in serious need of re-editing, and I wonder if the editor is familiar with MySQL. Granted, editing a book on coding is much more difficult than any other type of 'how to' book, but you're a professional!! Know what you're signing up for.

    The book is littered with mis-edits - some small, some not so small.

    The silver lining here is that, as a result, I am even more meticulous in checking and re-checking my code, more quick to jump into the documentation to double check the book, and think that I might actually be learning more as a result of the bad editing.

    Bottom line: buy the book, but when something doesn't seem right even though you have followed the directions EXACTLY, (or what is called a list of 7 elements is really 8 [I'm not joking... see page 67]), don't stress! Consider it a lesson in coding in the real world, where work is often done in collaboration and you will most likely find yourself debugging other people's mistakes.

    (2 of 2 customers found this review helpful)

     
    1.0

    Look anywhere else to learn MySQL or MariaDB

    By gm

    from Arizona

    About Me Developer

    Verified Reviewer

    Pros

      Cons

      • Difficult to understand
      • Too many errors

      Best Uses

        Comments about oreilly Learning MySQL and MariaDB:

        This book is littered with errors including but not limited to incorrect code, incomplete companion data i.e. there are tables missing in the "full" database, and noncorresponding examples.

        For how many blatant errors, genuine blunders and a writing quality that can best be described as adolescent makes me question if the book was edited.

        I have never purchased an O'Reilly book that was so haphazardly produced. Anyone learning MySQL or MariaDB would be better off studying the source documentation.

        (0 of 1 customers found this review helpful)

         
        5.0

        Concise and easy to understand.

        By Mircea Alexandru Ticovschi

        from Romania

        Verified Reviewer

        Pros

        • Accurate
        • Concise
        • Easy to understand
        • Helpful examples
        • Well-written

        Cons

          Best Uses

            Comments about oreilly Learning MySQL and MariaDB:

            Great book!

            Displaying reviews 1-3

            Back to top

             
            Buy 2 Get 1 Free Free Shipping Guarantee
            Buying Options
            Immediate Access - Go Digital what's this?
            Ebook:  $42.99
            Formats:  DAISY, ePub, Mobi, PDF
            Print & Ebook:  $54.99
            Print:  $49.99