Course outline for MariaDB
TechnologyMariaDBDuration
* 2-3 Days
LevelPrerequisites listed
About MariaDB
Pre-requisites
- The participants should have basic knowledge of relational databases.
- Helps to have worked on relational databases.
Lab Setup
- Hardware Configuration
- A minimum of 20GB of disk space and atleast 4GB of RAM
- Software Configuration
- Operating System – Ubuntu 20.04/22.04 Desktop or Server Edition
How we train
Online training for MariaDB
- Instructor-led live cohorts
- Self-paced learning with expert coaches
- 24x7 cloud labs with end-to-end examples
All sessions are 100% hands-on. Labs and activities are derived from real-world work our engineers deliver.
Classroom training
Available for corporate teams in:
- Bengaluru
- Chennai
- Hyderabad
- Mumbai
- Delhi/Gurgaon/NCR
- Pune
Note: Classroom training is for corporate clients only.
Self-paced hands-on sessions are delivered via VirtualCoach.
Detailed Course Outline
Hands-onSQL 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