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
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
Appendix I PHP API Reference
Author(s): Paul DuBois
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.
- 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
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
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
Author(s): Mr. Andrew Comeau, Mr. Stephen Burge
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
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
- 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
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