Learning MySQL and MariaDB

Heading in the Right Direction with MySQL and MariaDB

Russell Dyer (Autor)

Buch | Softcover

384 Seiten

2015
O'Reilly Media (Verlag)
978-1-4493-6290-4 (ISBN)

Artikel merken

If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB — you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.

Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.

Create and alter MySQL tables and specify fields and columns within them
Learn how to insert, select, update, delete, join, and subquery data, using practical examples
Use built-in string functions to find, extract, format, and convert text from columns
Learn functions for mathematical or statistical calculations, and for formatting date and time values
Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
Use APIs to connect and query MySQL and MariaDB with PHP and other languages

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (http://www.mysql.com/network/knowledgebase.html). He is the author of MySQL in a Nutshell (http://www.oreilly.com/catalog/mysqlian/) and has writen 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«.

The Software
Chapter 1 Introduction
The Value of MySQL and MariaDB
Mailing Lists and Forums
Other Books and Other Publications
Chapter 2 Installing MySQL and MariaDB
The Installation Packages
Licensing
Finding the Software
Choosing a Distribution
The _AMP Alternatives
Post-Installation
Chapter 3 The Basics and the mysql Client
The mysql Client
Connecting to the Server
Starting to Explore Databases
Summary
Exercises
Database Structures
Chapter 4 Creating Databases and Tables
Creating a Database
Creating Tables
Inserting Data
More Perspectives on Tables
Summary
Exercises
Chapter 5 Altering Tables
Prudence When Altering Tables
Essential Changes
Optional Changes
Indexes
Summary
Exercises
Basics of Handling Data
Chapter 6 Inserting Data
The Syntax
Practical Examples
Other Possibilities
Summary
Exercises
Chapter 7 Selecting Data
Basic Selection
Selecting by a Criteria
Ordering Results
Limiting Results
Combining Tables
Expressions and the Like
Counting and Grouping Results
Summary
Exercises
Chapter 8 Updating and Deleting Data
Updating Data
Deleting Data
Summary
Exercises
Chapter 9 Joining and Subquerying Data
Unifying Results
Joining Tables
Subqueries
Summary
Exercises
Built-In Functions
Chapter 10 String Functions
Formatting Strings
Extracting Text
Searching Strings and Using Lengths
Converting String Types
Compressing Strings
Summary
Exercises
Chapter 11 Date and Time Functions
Date and Time Data Types
Current Date and Time
Extracting Date and Time Components
Formatting Dates and Time
Adjusting to Standards and Time Zones
Adding and Subtracting Dates and Time
Comparing Dates and Times
Summary
Exercises
Chapter 12 Aggregate and Numeric Functions
Aggregate Functions
Numeric Functions
Summary
Exercises
Administration and Beyond
Chapter 13 User Accounts and Privileges
User Account Basics
Restricting the Access of User Accounts
Administrative User Accounts
Revoking Privileges
Deleting a User Account
Changing Passwords and Names
User Roles
Summary
Exercises
Chapter 14 Backing Up and Restoring Databases
Making Backups
Restoring Backups
Developing a Backup Policy
Summary
Exercises
Chapter 15 Bulk Importing Data
Preparing to Import
Loading Data Basics
Better Loading
More Field and Line Definitions
Importing from Outside MySQL
Bulk Exporting Data
Summary
Exercises
Chapter 16 Application Programming Interfaces
Creating API User Accounts
C API
Perl DBI
PHP API
Python
Ruby API
SQL Injection
Summary
Exercises

Colophon

Erscheint lt. Verlag	5.5.2015
Verlagsort	Sebastopol
Sprache	englisch
Maße	178 x 233 mm
Gewicht	649 g
Einbandart	Paperback
Themenwelt	Informatik ► Datenbanken ► MySQL
Schlagworte	Datenbank, SQL, MySQL • MySQL • PHP MySQL
ISBN-10	1-4493-6290-7 / 1449362907
ISBN-13	978-1-4493-6290-4 / 9781449362904
Zustand	Neuware