This practical reference guide is suited for beginning developers and IT professionals who need to learn how to download and install MariaDB and use the SQL script language. Written by Rodrigo Ribeiro, author of the popular eBook "MySQL 5.6 – Beginners Book" also on Amazon Kindle Store, this book is a must have for developers that use or want to get started with MariaDB or are considering a migration from MySQL.
The SQL language basics is described in detail to create databases, tables, views, procedures and functions, but not only that. This book presents the basics of database design showing how to build foreign keys to relate tables and build strong database structures. All of this is presented using MariaDB latest version and HeidiSQL, the default database software interface that is shipped with the MariaDB installation. Transactions, events, triggers and more recent features that aren’t found in earlier publications are described in detail, keeping a hands-on spirit from beginning to end.
The SQL language basics is described in detail to create databases, tables, views, procedures and functions, but not only that. This book presents the basics of database design showing how to build foreign keys to relate tables and build strong database structures. All of this is presented using MariaDB latest version and HeidiSQL, the default database software interface that is shipped with the MariaDB installation. Transactions, events, triggers and more recent features that aren’t found in earlier publications are described in detail, keeping a hands-on spirit from beginning to end.
