This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling “Java Servlets and JSP” and “PHP and MySQL” books, this is exactly the database book that web developers should have on their desks. This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who aren’t getting the most from MySQL.
As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of the MySQL enhancements that aren’t covered in older books, such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a whole section on database administrator (DBA) skills, including how to secure and back up databases. And like all Murach books, it uses the distinctive “paired pages” format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.
Today, MySQL is the world’s most popular open-source database, especially for web applications.
And if you’re ready to gain a set of professional MySQL skills, this is the book for you…whether you’re a beginner or whether you’re an experienced MySQL developer who hasn’t had time to master all of its features, especially the ones that have been added in the past few years.
For example, you’ll learn how to:
- Write SQL statements that retrieve, insert, update, and delete database data
- Code complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less
- Handle the problems you typically encounter with various types of data
- Use MySQL functions for everyday tasks like rounding numbers or formatting dates
- Use foreign keys to maintain referential integrity
- Design a database and code the SQL statements that create its tables and indexes…skills that make you a more effective SQL developer, even if these tasks are done by a DBA where you’re working
- Work with an EER model and its related diagrams
- Create views that simplify data access and improve data security
- Use stored procedures, custom functions, triggers, and events to improve developer productivity
- Use transactions to maintain data integrity
- Handle basic DBA tasks like database configuration, security, and backups
Ready to master all of this?
Then let Murach’s MySQL turn you into a top MySQL developer.
Who this book is for
This is the ideal book for application developers who need to work with a MySQL database.
- If you’re new to MySQL, it will teach you everything from coding SQL statements to designing databases to using stored programs that save you time and effort.
- If you have MySQL experience, the “paired-pages” format will make it easy for you to focus on the MySQL features and coding skills that are new to you. (If our format is new to you, please download a sample chapter to see how it works.)
This book is also a good choice for anyone who wants to learn standard SQL. In fact, 90% of what you learn here can be transferred to another database management system such as Oracle or SQL Server.
Finally, this is the right first book for anyone who wants to become a database administrator. Although it doesn’t cover all the issues that DBAs have to deal with, it gives you the solid foundation in database design and management that you need to build on.
What are the prerequisites for using this book?
There aren’t any. Everything you need to know about databases and MySQL is here, so you can gain the MySQL skills you need using this book alone.