• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Image from Amazon
Title: Murach's MySQL (4th Edition)
Author(s): Joel Murach
Publisher: Mike Murach & Associates

Summary

Mike Murach & Associates wrote:Ihe latest edition of Murach’s classic MySQL book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips.To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the most important SQL statements because developers use them every day. Then, it shows how to design a database, how to implement that design, and how to work with views, transactions, stored procedures, functions, triggers, and events. Finally, it presents a starting set of skills for a database administrator (DBA) including how to manage security, how to backup and restore a database, and how to host a MySQL database with Amazon Web Services (AWS).The result? You’ll be able to use SQL to work with a MySQL database in a way that’s thoroughly professional.Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive “paired-pages” format is ideal for learning and reference.




Book Preview (when available)



From the publisher
  • Table of Contents (PDF)
  • Chapter 3 - How to retrieve data from a single table ()
  • Book Applications and Exercises (ZIP)
  • Corrections (Where to get it?
  • [url=https://www.amazon.com/Murachs-MySQL-Reference-Joel-Murach/dp/B0CHMPQ3FC" target="_blank" rel="nofollow">Amazon.com
  • Mike Murach & Associates



  • Related Websites
  • MySQL

  • COMMENTS:
     
    author & internet detective
    Posts: 42003
    911
    Eclipse IDE VI Editor Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I reviewed the third edition of “Murach's MySQL” four years ago.

    The fourth edition is your typical Murach book. It's great for learning something new because of the paired page format. We have syntax/queries/tables on one side and text on another. I was recently able to find information faster in a Murach book than online (on Python) because of this format!

    Each chapter ends with exercises to reinforce the knowledge. I was happy to see the section on design covered levels of normalizations. I liked the sections on stored procs and transactions. The tables were easy to understand and provided good examples.  The stored program/procedure sections were good as well.

    The new content on AWS was great. And the appendices for Windows and Mac were helpful. This is a great book for someone new to databases.

    I give this book 8 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.
     
    Greenhorn
    Posts: 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    In one word its a great book for both learner and teachers. Each topic elaborately discussed in a simple and friendly way.
     
    Yeah, but is it art? What do you think tiny ad?
    Gift giving made easy with the permaculture playing cards
    https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
    reply
      Bookmark Topic Watch Topic
    • New Topic