Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart

Program Search:

Shopping Cart:




*Note: Minimum order cost: €20
Maximum Total Price: €1500
We Recommend:
Lynda.com Sheeri Cabral Understanding MariaDB for MySQL Users €15 buy download


2014
Lynda
Sheeri Cabral
2:10
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.


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


lynda.com/MariaDB-tutorials/Understanding-MariaDB-MySQL-Users/175600-2.html



Download File Size:223.58 MB


Lynda.com Sheeri Cabral Understanding MariaDB for MySQL Users
€15
Customers who bought this program also bought:

Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart      
Copyright 2006-2019 ©   LPStore   All Rights Reserved





Adobe Master Collection CC 2019 €260


Adobe Premiere Elements 2019 17.0 €35


Microsoft Windows 10 Pro With Office and More x64 (1 dvd) €150






Autodesk Revit 2020 Multilingual (1 dvd) €140

             

Autodesk Product Design Suite Ultimate 2020 .sfx (x64) €250






Intuit QuickBooks Enterprise Accountant 18.0 R4 €40


Mindjet MindManager 2019 19.1.197 Multilingual €20


Chief Architect Premier X11 21.1.1.2 x64 €50