Learning MySQL and MariaDB

by Russell J.T. Dyer

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

Genres: Computer Science

675 pages, Kindle Edition

First published September 22, 2013

Reviews

[Jorge DeFlon · Rating 4 out of 5]

Una introducción a la base de datos más usada.

Incluye todo lo básico para diseñar y usar bases utilizando dicha plataforma.

Es un libro fácil de leer y completo.
No es ni una referencia completa, ni un artículo básico.

Escrito por uno de los diseñadores originales de MySQL, y ahora jefe de capacitación de MariaDB.

[Delhi Irc]

Location: GG7 IRC
Accession No: DL027472
Location: ND6 IRC
Accession No: DL027473
Location: PTI IRC
Accession No: DL027474

[Megan Farve · Rating 4 out of 5]

Not all the chapters were relevant to what I do with SQL, but the chapters that were relevant were very informative and helpful for creating reports.