Win a copy of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 this week in the Programmer Certification forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Image from Mike Murach & Associates
Title: Murach’s MySQL
Author(s): Joel Murach
Publisher: Mike Murach & Associates
Category: Data modeling, SQL and JDBC


Summary

Mike Murach & Associates wrote:Today, MySQL is the world’s most popular open-source database, and this book will help you master it. As you would expect, this book shows how to code all of the essential SQL statements for working with a MySQL database. But beyond that, this book shows how to design and implement a database and how to take advantage of relatively new features like foreign keys, transactions, and stored procedures. It even has a section on database administrator (DBA) skills.




Book Preview (when available)



From the publisher
  • Table of Contents (PDF)
  • Chapter 2: How to use MySQL Workbench and other development tools (PDF)
  • Chapter 3: How to retrieve data from a single table (PDF)
  • Book Applications and Exercises (EXE for Windows or ZIP for any system)
  • Corrections (PDF)



  • Where to get it?
  • Amazon.com
  • Mike Murach & Associates



  • Related Websites
    COMMENTS:
     
    Sheriff
    Posts: 21817
    104
    Eclipse IDE Spring VI Editor Chrome Java Ubuntu Windows
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    The book follows the Murach style - on the left pages there is text, on the right pages there are screen shots, code snippets, and short summaries of the text on the left. For experienced database developers it's tempting to skip the entire left pages and focus on the right pages only.

    I really like this book. It starts with the obligatory introduction which doesn't really add anything, but after that the good stuff follows. The book shows most of the queries you need - not just the four basic ones, but also stored procedures, functions, triggers, events and transactions. I believe that after reading the book you can do most of the things you will need in your everyday job. And if you don't like the command line, no problems; the book also shows you how to use the MySQL workbench.

    If that's not enough, there is also an entire section about database administration. With this book you won't just learn how to be a database developer, you also learn how to manage security and backup and restore MySQL databases. What more do you need?

    Summarizing, this is one of the best books on MySQL I've read. It's less useful if you want to work with other database systems since a lot of it is specific for MySQL, but then you wouldn't have bought this book, would you?


    I give this book 9 out of 10 horseshoes.

    ---
    Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
     
    Bartender
    Posts: 3225
    34
    IntelliJ IDE Oracle Spring Chrome Java
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Rating: I give this book 10 out of 10 horseshoes.

    If you ever wanted to learn to use MySQL, write SQL queries, create database elements then this is the book to pick up.

    Some of the salient features of the book:
    - The usual Murach's style of code mixed with concepts. Its really useful because you are not only reading but also trying out the code. Its Learning by Doing.
    - It starts with the importance of the formatting and structure of the SQL queries and follows them right through out the book. By the end of it you would be naturally using the convention.
    - Clear division of the book into sections and the right ordering of these sections, this helps to plan the reading of the book accordingly.
    - Good coverage of procedural programming, Normalisation concepts as well as basic db Administration concepts.
    - The importance of the use of tools (MySQL WOrkbench) is also explained, but you dont find it overstressed anywhere in the book. They have introduced the tools as and when necessary.
    - Exercise questions at the end of each chapter to test your understanding.

    I know lot of you would say that with the ORM frameworks and frameworks which provide DSLs to create database structures (like migrations in Rails) such a book exclusively on a particular database might be redundant. But to really understand how these frameworks work, one has to be aware of SQL language and also be familiar with using the db. I think these frameworks may not be of much help in cases where we would have to write complex queries or a stored procedure to perform complex calculations.

    The intended audience:
    -Any one new to SQL/new to MySQL.
    -For someone familiar to SQL but not MySQL might find initial few chapters easy to read.
    -Any one who wants to do some advanced procedural programming in MySQL.

    I couldn't find anything which I didnt like. Though I might be tempted to say the size of the book, but considering the content it is packed with, the code examples, the exercises, the size shouldn't be of much concern.

    ---
    Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
     
    Ranch Hand
    Posts: 235
    5
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Is there much difference between the first and second editions? As near as I can, the reviews here are from the first, but according to Amazon (and others), there is a new edition available.

    Regards,
    Robert
     
    I am mighty! And this is a mighty small ad:
    Java file APIs (DOC, XLS, PDF, and many more)
    https://products.aspose.com/total/java
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!