Lynda - Understanding MariaDB for MySQL Users (2014)

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.

Introduction
4m 49s
Welcome
1m 4s
What you should know before watching this course
1m 4s
Using the exercise files
1m 36s
Why use MariaDB?
1m 5s

1. Dynamic Columns
30m 37s
Why use a dynamic column?
2m 45s
Creating dynamic columns
4m 43s
Querying dynamic columns
7m 14s
Updating dynamic columns
4m 5s
Adding a dynamic column part to all records
7m 3s
Nested dynamic columns
4m 47s

2. The Power of CONNECT
47m 15s
What is the CONNECT storage engine?
3m 21s
Installing the CONNECT storage engine
3m 5s
Connecting to a remote MySQL database
4m 56s
Executing batch commands on a remote database
7m 21s
Connecting to a CSV file
6m 21s
Connecting to an INI file
5m 17s
Connecting to an XML file
10m 8s
Connecting to other databases with ODBC
4m 33s
Indexing CONNECT tables
2m 13s

3. Advanced CONNECT Storage Engine
32m 6s
Using PIVOT tables
4m 57s
Building OCCUR tables
2m 56s
Querying similar tables as one
4m 43s
Separating lists of objects in a multivalued field
4m 59s
Getting file information in the database
4m 48s
Accessing remote database metadata
4m 31s
Getting remote database metadata
5m 12s

4. The Cassandra Storage Engine
14m 21s
Cassandra storage engine overview and installation
4m 52s
Creating a table
5m 21s
Querying data
4m 8s

Conclusion
1m 46s
Next steps
1m 46s