Lynda - Understanding MariaDB for MySQL Users | 236MB

Duration: 2h 10m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

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.

Topics include:

* Why use dynamic columns?

* Creating, updating, and querying dynamic columns

* Installing the CONNECT storage engine

* Connecting to remote data

* Connecting to CSV, INI, and XML files

* Using PIVOT tables

* Accessing database metadata

* Working with the Cassandra storage engine