Course Outline


About MariaDB

Pre-requisites

  • The participants should have basic knowledge of relational databases.
  • Helps to have worked on relational databases.

Duration

  • 2-3 Days

Lab Setup

  • Hardware Configuration
    • A minimum of 20GB of disk space and atleast 4GB of RAM
  • Software Configuration
    • Operating System – Ubuntu 16.04 Desktop or Server Edition

Course Outline for MariaDB

SQL Statements & Structure
  • Understanding SQL Statements
  • SQL Language Structure
  • Geographic & Geometric Features
  • Understanding NoSQL
  • Common Table Expressions
  • Operators
  • Sequences
Built-in Functions
  • String Functions
  • Date and Time Functions
  • Aggregate Functions
  • Numeric Functions
  • Control Flow Functions
Secondary Functions
  • Bit Functions and Operators
  • Encryption, Hashing and Compression Functions
  • Information Functions
  • Miscellaneous Functions
Special Functions
  • Dynamic Columns Functions
  • Geographic Functions
  • JSON Functions
  • Spider Functions
  • Window Functions
Clients & Utilities
  • Mysql cleint
  • Aria Clients and Utilities
  • Backup, Restore and Import Clients
  • Graphical and Enchanced Clients
Migrating to MariaDB
  • MariaDB versus MySQL – Compatibility
  • MariaDB versus MySQL – Features
  • Function Differences between MariaDB and MySQL
  • System Variable Differences between MariaDB and MySQL
  • Upgrading from MySQL to MariaDB
  • Installing MariaDB Alongside MySQL

The classroom training will be provided in Bangalore (Bengaluru), Chennai, Hyderabad or Mumbai and will be conducted in the client's premises. All the necessary hardware/software infrastructure must be provided by the client.