cta quote button

Best MySQL Books to Read

Read More

How Much Does It Cost to Hire Web Developers in Ukraine?

Our pricing is completely transparent: you pay your engineers’ salaries and a flat monthly fee for our services. No hidden charges.

Read More

1. Murach’s MySQL, 2nd Edition (2015)

"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.

Author(s): Joel Murach

2. MySQL (5th Edition) (Developer’s Library) (2013)

MySQL, Fifth Edition by Paul DuBois
The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6

MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).

Author Paul DuBois describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.

The fifth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.5, as well as to add new coverage of features introduced with MySQL 5.6.

MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.

Paul DuBois' MySQL, Fifth Edition, is the definitive guide to fully exploiting all the power and versatility of MySQL 5.5 and MySQL 5.6

Contents at a Glance

Part I: General MySQL Use
Chapter 1 Getting Started with MySQL
Chapter 2 Using SQL to Manage Data
Chapter 3 Data Types
Chapter 4 Views and Stored Programs
Chapter 5 Query Optimization

Part II: Using MySQL Programming Interfaces
Chapter 6 Introduction to MySQL Programming
Chapter 7 Writing MySQL Programs Using C
Chapter 8 Writing MySQL Programs Using Perl DBI
Chapter 9 Writing MySQL Programs Using PHP

Part III: MySQL Administration
Chapter 10 Introduction to MySQL Administration
Chapter 11 The MySQL Data Directory
Chapter 12 General MySQL Administration
Chapter 13 Security and Access Control
Chapter 14 Database Maintenance, Backups, and Replication

Part IV: Appendixes
Appendix A Software Required to Use This Book
Appendix B Data Type Reference
Appendix C Operator and Function Reference
Appendix D System, Status, and User Variable Reference
Appendix E SQL Syntax Reference
Appendix F MySQL Program Reference

Online Appendixes:

Appendix G C API Reference
Appendix H Perl DBI API Reference
Appendix I PHP API Reference

Author(s): Paul DuBois

3. Learning MySQL: Get a Handle on Your Data (2006)

Whether you’re running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you’ll find the MySQL database engineuseful for answering questions such as:

  • Which are my top ten fastest-selling products?
  • How frequently does this person come to our facility?
  • What was the highest, lowest, and average score of the team last season?

MySQL, the most popular open-source database, offers the power ofa relational database in a package that’s easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data.

After covering the basics, the book travels far into MySQL’ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security.

Topic include:

  • Installation on Linux, Windows, and Mac OS X
  • Basic and advanced querying using SQL
  • User management and security
  • Backups and recovery
  • Tuning for improved efficiency
  • Developing command-line and web database applications using thePHP and Perl programming languages

The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies.

Whether you’ve never touched a database or have already completedsome MySQL projects, you’ll find insights in Learning MySQLthat will last a career.

Author(s): Seyed M.M. (Saied) Tahaghoghi, Hugh Williams

4. MySQL Crash Course (2005)

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, full text search, and much more
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and Cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

Author(s): Ben Forta

5. MySQL Cookbook: Solutions for Database Developers and Administrators (2014)

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch.

Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to:

  • Use the mysql client and write MySQL-based programs
  • Create, populate, and select data from tables
  • Store, retrieve, and manipulate strings
  • Work with dates and times
  • Sort query results and generate summaries
  • Use stored routines, triggers, and scheduled events
  • Import, export, validate, and reformat data
  • Perform transactions and work with statistics
  • Process web input, and generate web content from query results
  • Use MySQL-based web session management
  • Provide security and server administration

Author(s): Paul DuBois

6. High Performance MySQL: Optimization, Backups, and Replication (2012)

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

  • Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategies—including new tools for hot online backups

Author(s): Baron Schwartz, Peter Zaitsev

7. MySQL Explained: Your Step By Step Guide to Database Design (2017)

MySQL Explained is a step-by-step tutorial for everyone who’s ready to learn about the database software most commonly used for storing information behind some of today’s most popular websites and online applications. Written especially for people outside the technology field, MySQL Explained provides the background information you need to get familiar with database theory and the principles behind organizing data. This book starts from the ground up, helping the reader to understand the very definition of a database, the forms it can take and the different options for storing information. By the end of this book, you’ll understand the reasons for choosing MySQL, the options for installing it and the tools that it offers to store and safeguard your data. If you are in any way involved in designing or managing a website or data solution of any kind, you owe it to yourself to understand the tools involved. Quality database management systems are essential in today’s data-driven world and such essential tools should not be a mystery to those who depend on them. MySQL Explained can help you unravel the mystery and learn more about a technology that will be around for a long time to come. This edition provides improvements in formatting and readability over the 2015 edition.

Author(s): Mr. Andrew Comeau, Mr. Stephen Burge

8. Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5) (2014)

Build interactive data-driven websites with the potent combination of open-source technologies and web standards even if you have only basic HTML knowledge With this popular hands-on guide youll tackle dynamic web programming with the help of todays core technologies PHP MySQL JavaScript jQuery CSS and HTML5 Explore each technology separately learn how to use them together and pick up valuable web programming practices along the way At the end of the book youll put everything together to build a fully functional social networking site using XAMPP or any development stack you choose Learn PHP in-depth along with the basics of object-oriented programmingExplore MySQL from database structure to complex queriesUse the MySQLi Extension PHPs improved MySQL interfaceCreate dynamic PHP web pages that tailor themselves to the userManage cookies and sessions and maintain a high level of securityMaster the JavaScript language-and enhance it with jQueryUse Ajax calls for background browserserver communicationAcquire CSS2 and CSS3 skills for professionally styling your web pagesImplement all of the new HTML5 features including geolocation audio video and the canvas

Author(s): Robin Nixon

9. MySQL Pocket Reference: SQL Statements, Functions and Utilities and more (Pocket Reference (O’Reilly)) (2007)

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need — quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

  • How to configure MySQL, such as setting the root password
  • MySQL data types, including numerics, strings, dates, and complex types
  • SQL syntax, commands, data types, operators, and functions
  • Arithmetic, comparison and logical operators
  • Aggregate and general functions
  • Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers

You don’t have time to stop and thumb through an exhaustive reference when you’re hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

Author(s): George Reese

10. PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition) (2017)

Learn PHP and MySQL programming— the quick and easy way!

 

Easy visual approach uses demonstrations and real-world examples to guide you step by step through advanced techniques for dynamic Web development using PHP and MySQL.

• Concise steps and explanations let you get up and running in no time.

• Essential reference guide keeps you coming back again and again.

• Whether you’re new to programming or an experienced veteran just needing to get up to speed on PHP and MySQL, this book will teach you all you need to know, including the latest changes in the languages, and much more!

Author(s): Larry Ullman

11. PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies (2013)

Get the basics on four key web programming tools in one great book!

PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications.

  • Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sites
  • Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks
  • Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface
  • Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts

With seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all.

Author(s): Steve Suehring, Janet Valade

12. Murach’s PHP and MySQL, 2nd Edition (2014)

"I can’t count how many PHP books I have purchased over the years trying to learn the language. Murach’s was the first book that helped me grasp the concepts and got me onto actually scripting in PHP."

That’s what one developer said in an online review of the first edition of Murach’s PHP and MySQL. Now, this 2nd Edition does an even better job of delivering the real-world skills you need to develop database-driven websites using PHP and MySQL, two of today’s most popular open-source software tools.

Section 1 is a quick-start course that shows how to use the latest versions of PHP, MySQL, the Apache web server, and the NetBeans IDE to build your first PHP applications. And right from the start, you’ll learn to create applications that conform to the MVC pattern, so they’ll be easier to maintain as they grow.

Then, Section 2 takes you deep into PHP by covering the skills you’ll use every day in professional applications, like how to work with form data, dates, arrays, sessions, cookies, functions, objects, regular expressions, and exceptions. Likewise, Section 3 dives into MySQL, teaching you how to design and create a database, as well as how to access and maintain the data in a database like the professionals do. Finally, Section 4 teaches you important web programming skills like how to secure web pages, prevent SQL injection attacks, guard against XSS attacks, send email, upload files, process images, and access content from other websites.

Complete sample applications (all using HTML5 and CSS3) along with chapter exercises provide training support throughout. A great choice for any developer who wants to master PHP without a lot of frustration and unnecessary expense.

Author(s): Joel Murach, Ray Harris