Course outline for MariaDB
About MariaDB
Pre-requisites for learning MariaDB
- 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
Duration
- 2-3 Days
Training Mode
Online training for MariaDB
We provide:
- Instructor led live training
- Self-paced learning with access to expert coaches
- 24x7 access to cloud labs with end to end working examples
All jnaapti sessions are 100% hands-on. All our instructors are engineers by heart. Activities are derived from real-life problems faced by our expert faculty. Self-paced hands-on sessions are delivered via Virtual Coach.
Classroom training for MariaDB
Classroom sessions are conducted in client locations in:
- Bengaluru
- Chennai
- Hyderabad
- Mumbai
- Delhi/Gurgaon/NCR
Note: Classroom training is for corporate clients only
Detailed 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