MariaDB is a drop-in MySQL replacement that contains enhancements and new features that MySQL doesn't offer. In this course, Sheeri K. Cabral helps you understand how MariaDB differs from MySQL, and why you might want to make the switch. Since the interface and syntax (and the skills required to work with them) are so similar to MySQL, Sheeri concentrates on the differences: dynamic columns, which allow you store different kinds of data in different rows in a single table; and the powerful Cassandra and CONNECT storage engines, which allow you to harness the power of that data. Start watching and deepen your understanding of this alternative relational database system.
What you should know before watching this course
Using the exercise files
Why use MariaDB?
1. Dynamic Columns
Why use a dynamic column?
Creating dynamic columns
Querying dynamic columns
Updating dynamic columns
Adding a dynamic column part to all records
Nested dynamic columns
2. The Power of CONNECT
What is the CONNECT storage engine?
Installing the CONNECT storage engine
Connecting to a remote MySQL database
Executing batch commands on a remote database
Connecting to a CSV file
Connecting to an INI file
Connecting to an XML file
Connecting to other databases with ODBC
Indexing CONNECT tables
3. Advanced CONNECT Storage Engine
Using PIVOT tables
Building OCCUR tables
Querying similar tables as one
Separating lists of objects in a multivalued field
Getting file information in the database
Accessing remote database metadata
Getting remote database metadata
4. The Cassandra Storage Engine
Cassandra storage engine overview and installation
Creating a table
Download File Size:223.58 MB