Murach's MySQL, 3rd Edition - Softcover

Murach, Joel

Softcover

ISBN 10: 1943872368 ISBN 13: 9781943872367

Publisher: Mike Murach & Associates Inc., 2019

Synopsis

This is the latest edition of the book that application developers worldwide have used to master MySQL...now updated for MySQL 8 and beyond.

As you would expect, this book shows how to code all the essential SQL statements for working with a MySQL database. You'll use these statements every day to have MySQL do more of your work for you.

But beyond that, it shows how to work with classic MySQL features that take you to new level, such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security. It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security. It shows how to design a database, including how to use MySQL Workbench to create and implement the design. It even presents a starting set of skills for a database administrator (DBA) if you're interested in that career path or if you need to be your own DBA.

In short, it s a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.

About this title

About the Author

Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 20 years now. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. He has had best-selling books in all of those categories! In his books, you can see his clear approach to teaching any subject.

Besides being a successful author, Joel is also a very talented musician. He writes and performs for his band, Joel Murach and the Low Rollers with regularity in the Bay Area.

Review

"I was amazed at how much information was packed into this book. The style of the book made it really easy to read and understand the information.... I learned a lot of new MySQL ideas reading this book, and I will be using it frequently as a reference."

--Paul Turpin, Southeastern Inter-Relational Database Users Group

"A very solid book with plenty of breadth and lots of examples. As a developer with almost 10 years of MySQL experience, I still picked up a lot of new detail on things I thought I knew."

--David Bolton, C/C++/C# Guide, About.com

"I found this to be a great introductory book to MySQL.... The examples make it easy to quickly see the differences between the database system you have been working on and how to do the same thing in MySQL. Because of this book, I know that I could easily transition my skills in developing, managing, and designing an Oracle database application to a MySQL database system."

--Eric "Morty" Mortensen, Northeast Ohio Oracle Users Group

Edition details

• Publisher: Mike Murach & Associates Inc.
• Publication date: 2019
• ISBN 10: 1943872368
• ISBN 13: 9781943872367
• Binding: Paperback
• Language: English
• Edition number: 3
• Number of pages: 628