MariaDB Administration Training

 >>  MariaDB Administration Training

MariaDB Administration Training


 (4.9) | 750 Ratings


Introduction


MariaDB Administration Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Module 1: Getting Started with MariaDB Server

  • Installation in Windows
  • Installation in Other Linux Distributions
  • Installation in Ubuntu

Module 2: MariaDB Server Files And Scripts

  • MariaDB Server and Client
  • MariaDB Programs
  • GUI tools usage

Module 3: Configuring MariaDB

  • MariaDB file system layout
  • Configuring files in Linux
  • Understanding groups and Options

Module 4: Using MariaDB

  • MySQL client
  • Creating, Listing and Dropping Databases
  • Creating, Listing and Dropping Tables
  • Inserting, Reading, Updating and Deleting Data

Module 5: Security in MariaDB

  • User accounts and passwords
  • Creating and Deleting user accounts
  • Setting up permission using roles
  • SSL connection
  • Monitoring connections
  • Authentication plugins

Module 6: Maintenance of MariaDB

  • Log files in MariaDB
  • Types of Backup
  • Backup and Recovery
  • Crash Recovery and Maintenance
  • Getting Table Information
  • Checking and Repairing Tables

Module 7: Query Cache in MariaDB

  • Importance of Query Cache
  • Configuring and Testing Query Cache
  • Maintenance of Query Cache

Module 8: Optimization of MariaDB

  • Controlling of optimizer strategies for MariaDB
  • Configuring the MyISAM segmented key cache
  • Configuring threadpool and Aria pagecache
  • Optimizing queries and semi join subqueries

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Module 1: Getting Started with MariaDB Server

  • Installation in Windows
  • Installation in Other Linux Distributions
  • Installation in Ubuntu

Module 2: MariaDB Server Files And Scripts

  • MariaDB Server and Client
  • MariaDB Programs
  • GUI tools usage

Module 3: Configuring MariaDB

  • MariaDB file system layout
  • Configuring files in Linux
  • Understanding groups and Options

Module 4: Using MariaDB

  • MySQL client
  • Creating, Listing and Dropping Databases
  • Creating, Listing and Dropping Tables
  • Inserting, Reading, Updating and Deleting Data

Module 5: Security in MariaDB

  • User accounts and passwords
  • Creating and Deleting user accounts
  • Setting up permission using roles
  • SSL connection
  • Monitoring connections
  • Authentication plugins

Module 6: Maintenance of MariaDB

  • Log files in MariaDB
  • Types of Backup
  • Backup and Recovery
  • Crash Recovery and Maintenance
  • Getting Table Information
  • Checking and Repairing Tables

Module 7: Query Cache in MariaDB

  • Importance of Query Cache
  • Configuring and Testing Query Cache
  • Maintenance of Query Cache

Module 8: Optimization of MariaDB

  • Controlling of optimizer strategies for MariaDB
  • Configuring the MyISAM segmented key cache
  • Configuring threadpool and Aria pagecache
  • Optimizing queries and semi join subqueries

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry