MySQL Books







 
OSgram.com   >   Shopping   >   Books   >   MySQL
Shop for books about MySQL.

Other web sites about MySQL:Additional pages on this web site, which may be of interest: MySQL is a multi-user database management system. It is developed by MySQL AB, and installed at at least 10 million sites worldwide. The software is dual licensed under the GPL and a proprietary commercial license, as well as being available on a subscription model. Although MySQL can be used with a wide variety of programming tools, it is especially commonly used in conjunction with PHP.

Here are some books about MySQL:

Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.

Murach's MySQL, 2nd Edition

By Joel Murach

Mike Murach Associates
Paperback (612 pages)

Murach s MySQL, 2nd Edition
List Price: $54.50*
Lowest New Price: $42.60*
Lowest Used Price: $29.49*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
  • Mike Murach Associates
Product Description:

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

MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration

By Karthik Appigatla

Packt Publishing - ebooks Account
Released: 2018-01-25
Paperback (446 pages)

MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
List Price: $49.99*
Lowest New Price: $34.40*
Lowest Used Price: $37.73*
Usually ships in 1-2 business days*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
Product Description:

Design and administer enterprise-grade MySQL 8 solutions

Key Features

  • Store, retrieve, and manipulate your data using the latest MySQL 8 features
  • Practical recipes on effective administration in MySQL, with a focus on security, performance tuning, troubleshooting, and more
  • Contains tips, tricks, and best practices for designing, developing, and administering your MySQL 8 database solution without any hassle

Book Description

MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before.

This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more.

With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical tips and tricks to give you the edge over others in designing, developing, and administering your database effectively.

What you will learn

  • Install and configure your MySQL 8 instance without any hassle
  • Get to grips with new features of MySQL 8 like CTE, Window functions and many more
  • Perform backup tasks, recover data and set up various replication topologies for your database
  • Maximize performance by using new features of MySQL 8 like descending indexes, controlling query optimizer and resource groups
  • Learn how to use general table space to suit the SaaS or multi-tenant applications
  • Analyze slow queries using performance schema, sys schema and third party tools
  • Manage and monitor your MySQL instance and implement efficient performance-tuning tasks

Who This Book Is For

If you are a MySQL developer or administrator looking for quick, handy solutions to solve the most common and not-so-common problems in MySQL, this book is for you. MySQL DBAs looking to get up-to-speed with the latest MySQL 8 development and administration features will also find this book very useful. Prior knowledge of Linux and RDBMS is desirable.

Table of Contents

  1. Installation
  2. Using MySQL
  3. Using MySQL (Advanced)
  4. Configuring MySQL
  5. Transactions
  6. Binary Logging
  7. Backup
  8. Restoring data
  9. Replication
  10. Table Maintenance
  11. Managing Tablespace
  12. Managing Logs
  13. Performance Tuning
  14. Security

MySQL: MySQL Tutorials for Beginners Basic to Advanced MySQL Languages

By Dennis Hutten

Released: 2018-02-09
Kindle Edition (122 pages)

MySQL: MySQL Tutorials for Beginners Basic to Advanced MySQL Languages
 
Product Description:
MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming


This tutorial is prepared for the beginners to help them understand the basics-to-advanced concepts related to MySQL languages


Before you start doing practice with various types of examples given in this tutorial, it is being assumed that you are already aware about what a database is, especially an RDBMS and what is a computer programming language

Jump Start MySQL: Master the Database That Powers the Web

By Timothy Boronczyk

O'Reilly Media
Paperback (152 pages)

Jump Start MySQL: Master the Database That Powers the Web
List Price: $29.95*
Lowest New Price: $17.94*
Lowest Used Price: $18.49*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
  • Sitepoint
Product Description:

Get a Jump Start on working with MySQL today!

MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers.

In just one weekend with this hands-on tutorial, you'll learn how to:

  • Get started with MySQL
  • Store, modify, and retrieve data
  • Work with multiple tables
  • Connect to your database through code
  • Program the database
  • Back up your data

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

By Adrian W. West

Apress
Released: 2018-09-29
Paperback (568 pages)

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites
List Price: $49.99*
Lowest New Price: $36.10*
Lowest Used Price: $36.65*
Usually ships in 1-2 business days*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
Product Description:
Build interactive, database-driven websites with PHP 7, MySQL 8, and MariaDB. The focus of this book is on getting you up and running as quickly as possible with real-world applications. In the first two chapters, you will set up your development and testing environment, and then build your first PHP and MariaDB or MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. 
 
The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB and MySQL to create powerful database-driven websites.  
 
Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an interface so that an administrator can view and administer the user database. You will create a message board for users and a method for emailing them. You will also learn the best practices for ensuring that your website databases are secure. Later chapters describe how to create a product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. The final chapter will demonstrate the advantages of migrating to Oracle's MySQL 8. You will be shown step by step migration directions along with a demonstration of the tools available in SQL Workbench.
 
Because you are building the interactive pages yourself, you will know exactly how MySQL, MariaDB, and PHP all work together, and you will be able to add database interactivity to your own websites with ease.

What You Will Learn
  • Build a secure database-driven website using PHP 7, MySQL 8, and MariaDB
  • Create a product catalog
  • Write a message board
  • Move towards e-commerce
  • Employ security and validation measures
  • Migrate to Oracle's MySQL 8 Server platform
Who This Book Is For
 
Web developers with HTML, CSS and a limited Bootstrap experience. Readers need little to no prior experience with PHP and MySQL.


Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

By Eric Vanier & Tejaswi Malepati

Packt Publishing
Released: 2019-01-31
Paperback (286 pages)

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database
List Price: $39.99*
Lowest New Price: $39.99*
Lowest Used Price: $41.42*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
Product Description:

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

Key Features

  • Explore the new and advanced features of MySQL 8.0
  • Use advanced techniques to optimize MySQL performance
  • Create MySQL-based applications for your enterprise with the help of practical examples

Book Description

Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.

By the end of this book, you'll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.

What you will learn

  • Explore new and exciting features of MySQL 8.0
  • Analyze and optimize large MySQL queries
  • Understand MySQL Server 8.0 settings
  • Master the deployment of Group Replication and use it in an InnoDB cluster
  • Monitor large distributed databases
  • Discover different types of backups and recovery methods for your databases
  • Explore tips to help your critical data reach its full potential

Who this book is for

Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

Table of Contents

  1. Introduction and Topics
  2. MySQL 8 - New Features
  3. Indexing Your Data For High Performance
  4. Advanced Data Techniques For Large Queries
  5. MySQL data dictionary in MySQL 8.0
  6. MySQL Server Settings
  7. Group Replication in MySQL 8.0
  8. InnoDB Cluster in MySQL 8.0
  9. Monitoring Your Large Distributed Databases
  10. Authentication and Security Management with MySQL 8.0
  11. Advanced MySQL 8.0 Performance Tips & Techniques

Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5)

By Robin Nixon

O'Reilly Media
Released: 2018-06-08
Paperback (832 pages)

Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5)
List Price: $49.99*
Lowest New Price: $31.06*
Lowest Used Price: $27.99*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
Product Description:

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you’ll tackle dynamic web programming with the latest versions of today’s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries.

Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices. At the end of the book, you’ll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.

  • Explore MySQL, from database structure to complex queries
  • Use the MySQLi extension, PHP’s improved MySQL interface
  • Create dynamic PHP web pages that tailor themselves to the user
  • Manage cookies and sessions and maintain a high level of security
  • Enhance the JavaScript language with jQuery and jQuery mobile libraries
  • Use Ajax calls for background browser-server communication
  • Style your web pages by acquiring CSS2 and CSS3 skills
  • Implement HTML5 features, including geolocation, audio, video, and the canvas element
  • Reformat your websites into mobile web apps

MySQL Cookbook: Solutions for Database Developers and Administrators

By Paul DuBois

O Reilly Media
Paperback (866 pages)

MySQL Cookbook: Solutions for Database Developers and Administrators
List Price: $79.99*
Lowest New Price: $43.06*
Lowest Used Price: $32.99*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
  • O Reilly Media
Product Description:

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

Understanding MySQL Internals: Discovering and Improving a Great Database

By Sasha Pachev

O'Reilly Media
Released: 2007-04-20
Paperback (258 pages)

Understanding MySQL Internals: Discovering and Improving a Great Database
List Price: $49.99*
Lowest New Price: $23.49*
Lowest Used Price: $12.00*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
  • Used Book in Good Condition
Product Description:

Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.



The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:



  • Core server classes, structures, and API
  • The communication protocol between the client and the server
  • Configuration variables, the controls of the server; includes a tutorial on how to add your own
  • Thread-based request handling -- understanding threads and how they are used in MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL's performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication




Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.

Learning MySQL: Get a Handle on Your Data

By Seyed M.M. (Saied) Tahaghoghi

O'Reilly Media
Released: 2006-11-24
Paperback (618 pages)

Learning MySQL: Get a Handle on Your Data
List Price: $54.99*
Lowest New Price: $29.19*
Lowest Used Price: $2.78*
Usually ships in 24 hours*
*(As of 14:02 Pacific 24 Apr 2019 More Info)


Click Here
Product Description:

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.


  Run multiple operating systems on your machine!


 
     
Shopping
 
  Books
   Apache
   BSD
   Eclipse
   Firefox
   GIMP
   GNOME
   GNU
   JBoss
   Linux
   MySQL
   OpenOffice
   Open Source
   Perl
   PHP
   PostgreSQL
   Python
   Ruby
   Security
   Solaris
   SQLite

  Clothing

  Magazines

  Software
 

ATI Echo Server for Linux

News Resources
 
  Companies

  Conferences

  Embedded

  Mobile

  Patents

  Security

  Software

  VoIP
 


 
   
Contact Us   Privacy   Terms Of Use   Advertising/Endorsements Disclosures

Copyright © 2006-2018, Answers 2000 Limited.

Answers 2000 Limited has no opinion about any stories or content of, or views expressed in, any linked news resource or website. Information about companies, organizations, products and services was believed to be correct at the time it was first published on this website, but may out of date by the time you read this website. For current information about any company or organization, readers are advised to check with the applicable company or organization.

Answers 2000 Limited expresses no opinion about any company or organization (including expressing no opinion on any investments in, with, or relating to, any company or organization), product or service. This website is not intended as investment or financial advice.

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
CERTAIN CONTENT THAT APPEARS ON THIS SITE,COMES FROM AMAZON EU S. r.l. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

In Association With Amazon.com
Answers 2000 Limited is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.
In Association With Amazon.co.uk
Answers 2000 Limited is a participant in the Amazon EU Associates Programme, an affiliate advertising programme designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.co.uk.
As an Amazon Associate, our company earns from qualifying purchases. Amazon, the Amazon logo, Endless, and the Endless logo are trademarks of Amazon.com, Inc. or its affiliates.

Disclosure: Our company's websites' content (including this website's content) includes advertisements for our own company's websites, products, and services, and for other organization's websites, products, and services. In the case of links to other organization's websites, our company may receive a payment, (1) if you purchase products or services, or (2) if you sign-up for third party offers, after following links from this website. Unless specifically otherwise stated, information about other organization's products and services, is based on information provided by that organization, the product/service vendor, and/or publicly available information - and should not be taken to mean that we have used the product/service in question. Additionally, our company's websites contain some adverts which we are paid to display, but whose content is not selected by us, such as Google AdSense ads. For more detailed information, please see Advertising/Endorsements Disclosures

Our sites use cookies, some of which may already be set on your computer. Use of our site constitutes consent for this. For details, please see Privacy.

Click privacy for information about our company's privacy, data collection and data retention policies, and your rights.