Join Sheeri Cabral for an in-depth discussion in this video Next steps, part of MariaDB for MySQL Users.
…MariaDB is a fork of MySQL.…Ir has many features that help DBAs and developers work more efficiently.…Dynamic Columns allow MariaDB to work with semi-structured data.…Tables can have more than one dynamic column, and dynamic columns can be nested.…The CONNECT storage engine was originally designed to mimic the FEDERATED and…FEDERATED X storage engines.…Those storage engines connect to remote MySQL databases.…The CONNECT storage engine does that and much more.…
It's possible to connect not only to MySQL databases, but…any data store that uses ODBC drivers.…Postgres, Oracle, Microsoft SQL server,…even Microsoft Excel formatted spreadsheets.…The CONNECT storage engine allows database tables to be made out of…many different kinds of text files.…CSV, INI, and CSF files, and XML files.…Reading and writing files in remote databases is easy.…There's even a special CONNECT table type that reads metadata from…remote databases and files.…Going beyond just connection, the CONNECT storage engine can…summarize information in a pivot table and unsummarize in occur tables.…
- 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
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.