What do you think?
Rate this book
Murach's MySQL: Training & Reference
The 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.
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.
652 pages, Paperback
Published October 1, 2023
1 person is currently reading
5 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
February 23, 2024
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.
Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
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.
Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
Displaying 1 of 1 review