MariaDB Essentials: Quickly get up to speed with MariaDB―the leading, drop-in replacement for MySQL, through this practical tutorial - Softcover

Federico Razzoli; Emilien Kenler

Softcover

ISBN 10: 1783982861 ISBN 13: 9781783982868

Publisher: Packt Publishing, 2015

Synopsis

Quickly get up to speed with MariaDB-the leading, drop-in replacement for MySQL, through this practical tutorial

About This Book

• Get to know the basic SQL queries so you can quickly start using MariaDB


• Take control of your data through the advanced features of MariaDB


• Exploit the full potential of MariaDB's exclusive features through quick, practical examples

Who This Book Is For

If you don't know the SQL language, but you want to quickly jump into the SQL world and learn how to use MariaDB, or if you already know how to use MySQL but you want to go further, then this book is ideal for you.

What You Will Learn

• Install and configure MariaDB


• Create databases, tables, and indexes


• Import and export data from and to external files


• Work with views and virtual columns


• Create, read, update, and delete records in your database


• Use dynamic columns


• Set up a powerful full-text search system


• Access your external data from MariaDB through the CONNECT engine

In Detail

This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features.

At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL.

Moving on, you'll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you'll get to grips with full-text searches and queries in MariaDb. You'll also be familiarized with the CONNECT storage engine. At the end of the book, you'll be introduced to the community of MariaDB.

About this title

About the Authors

Emilien Kenler began focusing on game development after working on small web projects in 2008, when he was in High School. Until 2011, he worked for different groups and specialized in system administration. A student of computer science engineering, Emilien founded a company that sold Minecraft servers in 2011. He created a lightweight IaaS (https://github.com/HostYourCreeper/) based on new technologies such as Node.js and RabbitMQ. Thereafter, Emilien worked for TaDaweb as a system administrator, building its infrastructure and creating tools to manage deployment and monitoring. In 2014, he began a new adventure at Wizcorp, Tokyo. In 2014, Emilien graduated from the University of Technology Compiegne, France. He also contributed as a reviewer to Learning Nagios 4, MariaDB High Performance, OpenVZ Essentials, Vagrant Virtual Development Environment Cookbook, and Getting Started with MariaDB Second Edition, all by Packt Publishing.

Federico Razzoli is a software developer, database consultant, and free software supporter. He has been working on websites and database applications since 2000 and used MySQL and other relational databases extensively during this period. He is now a MariaDB Ambassador.

Edition details

• Publisher: Packt Publishing
• Publication date: 2015
• Language: English
• ISBN 10: 1783982861
• ISBN 13: 9781783982868
• Binding: Paperback
• Number of pages: 177