Popular and Notable Books on MySQL

Popular and Notable Books on MySQL

Books in list (18)


Title: MySQL Pocket Reference

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.

Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure.

Author(s): George Reese
ISBN 13: 9780596514266
Pages: 134
Rate book Rate this book
This book is in (3) other book lists, learn more.

Title: PHP and MySQL Web Development, 4th Edition (Developer's Library Series)

PHP and MySQL Web Development, Fourth Edition
The definitive guide to building database-drive Web applications with PHP and MySQL

PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.


PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.

This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.

The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.

TABLE OF CONTENTS

Part I: Using PHP

1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling

Part II: Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming

Part III: E-Commerce and Security
14 Running an E-Commerce Site
15 E-commerce Security Issues
16 Web Application Security
17 Implementing Authentication with PHP and MySQL
18 Implementing Secure Transactions with PHP and MySQL

Part IV: Advanced PHP Techniques
19 Interacting with the File System and the Server
20 Using Network and Protocol Functions
21 Managing the Date and Time
22 Generating Images
23 Using Session Control in PHP
24 Other Useful Features

Part V: Building Practical PHP and MySQL Projects

25 Using PHP and MySQL for Large Projects
26 Debugging
27 Building User Authentication and Personalization
28 Building a Shopping Cart
29 Building a Web-Based Email Service
30 Building a Mailing List Manager
31 Building Web Forums
32 Generating Personalized PDF Documents
33 Connecting to Web Services with XML and SOAP
34 Building Web 2.0 Applications with Ajax

Part VI: Appendixes
Appendix A: Installing PHP and MySQL Appendix B: Web Resources


An intermediate to advanced guide to PHP and MySQL, the free, open-sourced Web development products. Offers coverage of object-oriented Web programming, creating services using SSL and authentication, and other applications. The CD-ROM includes full versions of PHP, MySQL, and Apache for Windows and Linux/Unix systems, several graphics libraries, files containing the code listings in the book, and the entire book in PDF format.

Author(s): Luke Welling
ISBN 13: 9780672329166
Pages: 968
Rate book Rate this book
This book is in (4) other book lists, learn more.

Title: Sams Teach Yourself SQL in 10 Minutes

Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results.

By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language.

Lessons cover IBM DB2, Microsoft® Access, Microsoft SQL Server™, MySQL, Oracle®, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base.

Full-color code examples help you understand how SQL statements are structured

Tips point out shortcuts and solutions

Cautions help you avoid common pitfalls

Notes explain additional concepts, and provide additional information

10 minutes is all you need to learn how to…

  • Use the major SQL statements
  • Construct complex SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use aggregate functions to summarize data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, and more
Author(s): Ben Forta
ISBN 13: 9780672336072
Pages: 288
Rate book Rate this book
This book is in (4) other book lists, learn more.

Title: Murach's PHP and MySQL, 2nd Edition

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
ISBN 13: 9781890774790
Pages: 878
Rate book Rate this book
This book is in (3) other book lists, learn more.

Title: PHP and MySQL Web Development

"PHP and MySQL Web Development shows how to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server." "This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, managing content, and connecting to Web services using XML." The third edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to include coverage of PHP 5 - including its new object model, better exception handling, and SimpleXML - as well as features introduced in MySQL 5, such as stored procedures.

An intermediate to advanced guide to PHP and MySQL, the free, open-sourced Web development products. Offers coverage of object-oriented Web programming, creating services using SSL and authentication, and other applications. The CD-ROM includes full versions of PHP, MySQL, and Apache for Windows and Linux/Unix systems, several graphics libraries, files containing the code listings in the book, and the entire book in PDF format.

Author(s): Luke Welling
ISBN 13: 9780321833891
Pages: 1008
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: MySQL Administrator's Bible

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Author(s): Sheeri K. Cabral
ISBN 13: 9780470416914
Pages: 888
Rate book Rate this book
This book is in (3) other book lists, learn more.

Title: MySQL Crash Course

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
ISBN 13: 9780672327124
Pages: 336
Rate book Rate this book
This book is in (3) other book lists, learn more.

Title: Learning PHP, MySQL & JavaScript

At the end of the book, you’ll put everything together to build a fully functional social networking site, using XAMPP or any development stack you choose.
Author(s): Robin Nixon
ISBN 13: 9781491918661
Pages: 812
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: Understanding MySQL Internals: Discovering and Improving a Great Database

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.

Like the bestselling "Understanding the Linux Kernel," this new guide goes to the heart of the MySQL database, another leading open source software project.

Author(s): Sasha Pachev
ISBN 13: 9780596009571
Pages: 258
Rate book Rate this book
This book is in (3) other book lists, learn more.

Title: MySQL introduction

This book teaches you how to work with MySQL - a popular relational database management system. You will learn how to download and install MySQL on your Windows or Linux system. You will learn how to access MySQL through the command line or GUI, how to create a database, how to query a database, sort results, and much more. We will also guide you through some more advanced MySQL topics, such as MySQL functions, aliases, keys, and such. Here is a list of topics covered in this book: Chapter 1 - Introduction - you will learn what MySQL is and how to install it on Windows or Linux. Chapter 2 - SQL command syntax - we will start working with SQL, a special-purpose programming language used for managing data held in MySQL. We will show you the SQL syntax and some basic commands: how to create a database, how to create a table, and how to create a user. Chapter 3 - Important SQL commands - we will show you some common SQL command used to manage a database. We will describe how you can insert new records in a table, modify a table, update the contents of a field... Chapter 4 - Advanced usage - we will show you some advanced MySQL topics. You will learn how to define primary keys, how to work with MySQL functions, what aliases are and how to combine multiple SELECT statements.
Author(s): Antun Peicevic;Marko Maslac
ISBN 13: 9781530507290
Pages: 42
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: MySQL

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 Appendix G C API Reference Appendix H Perl DBI API Reference Appendix I PHP API Reference

Author(s): Paul DuBois
ISBN 13: 9780321833877
Pages: 1153
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: Head First PHP & MySQL (Head First Series)

If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.

Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.

  • Use PHP to transform static HTML pages into dynamic web sites
  • Create and populate your own MySQL database tables, and work with data stored in files
  • Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY
  • Use cookies and sessions to track visitors' login information and personalize the site for users
  • Protect your data from SQL injection attacks
  • Use regular expressions to validate information on forms
  • Dynamically display text based on session info and create images on the fly
  • Pull syndicated data from other sites using PHP and XML
Throughout the book, you'll build sophisticated examples — including a mailing list, a job board, and an online dating site — to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
Author(s): Lynn Beighley
ISBN 13: 9780596006303
Pages: 814
Rate book Rate this book
This book is in (4) other book lists, learn more.

Title: Murach's MySQL, 2nd Edition

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
ISBN 13: 9781890774820
Pages: 612
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: MySQL for Python: Database Access Made Easy

Author(s): Lukaszewski, Phd Albert
ISBN 13: 9781849510189
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: High Performance MySQL: Optimization, Backups, and Replication

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
ISBN 13: 9781449314286
Pages: 828
Rate book Rate this book
This book is in (2) other book lists, learn more.

Title: Learning MySQL

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful 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 of a relational database in a package that's easy to set up and administer, and Learning MySQL provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.

After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-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 the PHP and Perl programming languages

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

Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in Learning MySQL that will last a career.

This new book in the popular Learning series offers an easy-to-use resource for newcomers to the MySQL relational database. This tutorial explains in plain English how to set up MySQL and related software from the beginning, and how to do common tasks.

Author(s): Seyed M.M. Saied Tahaghoghi
ISBN 13: 9780596008642
Pages: 622
Rate book Rate this book
This book is in (3) other book lists, learn more.

 


Next book list: Books On How to Program and Learn Python >>