
Learning MySQL and MariaDB
Heading in the Right Direction with MySQL and MariaDB
Russell J.T. Dyer(Author)
O'Reilly (Publisher)
1st Edition
Published on 5. May 2015
Book
Paperback/Softback
394 pages
978-1-4493-6290-4 (ISBN)
Description
With an easy, step-by-step approach, this practical guide shows programmers new to databases how to install, effectively use, and maintain MySQL and MariaDB. You'll learn these database systems through real-world examples and many practical tips.
Popular and easy-to-use database engines such as MySQL and MariaDB-a community-driven variant of MySQL-help organizations large and small handle data by providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. Experienced web developers and programmers interested in adding MySQL to their skill sets will also find this book useful.
Topics include:
* An introduction to database systems and the SQL database language
* Installation and basic administration of MySQL and MariaDB
* Functions, subqueries, and other query enhancements
* Methods for accessing MySQL and MariaDB from popular programming languages
More details
Language
English
Place of publication
Sebastopol
United States
Target group
Professional and scholarly
Dimensions
Height: 233 mm
Width: 177 mm
Thickness: 27 mm
Weight
667 gr
ISBN-13
978-1-4493-6290-4 (9781449362904)
Schweitzer Classification
Other editions
Additional editions

E-Book
03/2015
1st Edition
O'Reilly
€44.99
Available for download

E-Book
03/2015
1st Edition
O'Reilly
€42.49
Available for download
Person
Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (www.mysql.com/network/knowledgebase.html). The author of the first edition of "MySQL in a Nutshell", Russell has also written articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, "In Search of Kafka". More information on Russell, along with a list of his published articles with links to them, can be found on his web site at http://russell.dyerhouse.com
Content
- Foreword
- Preface
-
The Software
- Chapter 1: Introduction
- Chapter 2: Installing MySQL and MariaDB
- Chapter 3: The Basics and the mysql Client
-
Database Structures
- Chapter 4: Creating Databases and Tables
- Chapter 5: Altering Tables
-
Basics of Handling Data
- Chapter 6: Inserting Data
- Chapter 7: Selecting Data
- Chapter 8: Updating and Deleting Data
- Chapter 9: Joining and Subquerying Data
-
Built-In Functions
- Chapter 10: String Functions
- Chapter 11: Date and Time Functions
- Chapter 12: Aggregate and Numeric Functions
-
Administration and Beyond
- Chapter 13: User Accounts and Privileges
- Chapter 14: Backing Up and Restoring Databases
- Chapter 15: Bulk Importing Data
- Chapter 16: Application Programming Interfaces
- Colophon