MariaDB Essentials

More Information
  • 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

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.

  • 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
Page Count 206
Course Length 6 hours 10 minutes
ISBN 9781783982868
Date Of Publication 27 Oct 2015


Federico Razzoli

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.

Emilien Kenler

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 ( 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 Compiègne, 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.