Murach’s MySQL, 2nd Edition

“If you ever wanted to learn to use MySQL, write SQL queries, create database elements, then this is the book to pick up.” (JavaRanch.com)

“I was amazed at how much information was packed into this book.”

“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.”

“I found this to be a great introductory book to MySQL.”

“Has already proven to be helpful in solving several challenges I’ve encountered on my current MySQL project.”

That’s a sampling of what developers said about the 1st Edition of Murach’s MySQL.

Now, this 2nd Edition has been updated and improved throughout. As a result, it’s easier than ever to use for learning MySQL from scratch, for switching to MySQL from another flavor of SQL (like MS SQL Server or Oracle), or for quickly looking up the forgotten details that are so essential as you develop database applications.

Section 1 introduces you to relational databases and SQL, shows you how to use the graphical MySQL Workbench to work with a MySQL database, and teaches you to code SQL queries to retrieve, add, update, and delete data in a MySQL database. Section 2 goes deeper into querying, showing you how to work with summary queries, subqueries, data types, and functions. Section 3 shows you how to design a MySQL database using an EER model, implement the design, and create views. Section 4 shows how to create stored procedures that provide functionality similar to procedural programming languages like PHP, Java, C++, C#, and VB. And Section 5 introduces you to database administration tasks like securing and backing up database data.

Whether you start from the beginning or jump in anywhere, it’s a great guide for MySQL users at any level.

Table of Contents

Section 1 – An Introduction to MySQL
Chapter 1 – An Introduction to Relational Databases
Chapter 2 – How to Use MySQL Workbench and Other Development Tools
Chapter 3 – How to Retrieve Data from a Single Table
Chapter 4 – How to Retrieve Data from Two or More Tables
Chapter 5 – How to Insert, Update, and Delete Data

Section 2 – More SQL Skills as You Need Them
Chapter 6 – How to Code Summary Queries
Chapter 7 – How to Code Subqueries
Chapter 8 – How to Work with Data Types
Chapter 9 – How to Use Functions

Section 3 – Database Design and Implementation
Chapter 10 – How to Design a Database
Chapter 11 – How to Create Databases, Tables, and Indexes
Chapter 12 – How to Create Views

Section 4 – Stored Program Development
Chapter 13 – Language Skills for Writing Stored Programs
Chapter 14 – How to Use Transactions and Locking
Chapter 15 – How to Create Stored procedures and Functions
Chapter 16 – How to Create Triggers and Events

Section 5 – Database Administration
Chapter 17 – An Introduction to Database Administration
Chapter 18 – How to Secure a Database
Chapter 19 – How to Back Up and Restore a Database

Appendix A – How to Install the Software for This Book on Windows
Appendix B – How to Install the Software for This Book on Mac OS X