Skip to content

MariaDB Training in Singapore and India

Save 22% Save 22%
Original price Rs. 174,000.00
Original price Rs. 174,000.00 - Original price Rs. 174,000.00
Original price Rs. 174,000.00
Current price Rs. 135,000.00
Rs. 135,000.00 - Rs. 135,000.00
Current price Rs. 135,000.00
Overview
MariaDB Training by Cloud Enabled Pte Ltd in Singapore and India
Course Summary

This class will school you in the essentials of the DBA trade, extend your skill set to all aspects of administering MariaDB. We’ll cover MariaDB concepts and essential tools, in addition to optimal use of resources available for your databases. We’ll also thoroughly review core administrative task such as backups and restoration, monitoring and maintaining database, and user security.

Course Objectives
Course Pre- requisites
  • Basic SQL knowledge
  • Working knowledge of MariaDB is recommended, but not needed
Course Duration
  • 21 hours – 3 days
Course Outline

Installing MariaDB server

  • Installing in Ubuntu/Debian
  • Installing in other Linux Distributions
  • Installation on Windows

Introduction

  • What is MariaDB
  • Features of MariaDB
  • Perform the MariaDB start and shutdown operations
  • Activate and Manage MariaDB server logs

MariaDB Log Files

  • Error Log
  • General Query Log
  • Update Log
  • Binary Log
  • Slow Query Log
  • Log File Maintenance and Rotation

Performance and Usage Statistics

  • Describe MariaDB Server Essentials
  • Evaluate the data types and character sets
  • Understand MariaDB schema objects such as views, triggers, and table partitioning
  • Compare and gain an understanding of the multiple storage engines in MariaDB
  • Understand transactions and data locking in Maria DB
  • Manager users, roles and security including data at rest encryption
  • Perform back and restore operations using different backup methods
  • Maria DB resources utilization
  • Performance tuning techniques
  • High availability
  • Monitor MariaDB replication
  • PL/SQL and Windows functions on Maria DB
  • Summary and Closing Remarks
Training Delivery Mode

Online - Live Instructor Led training 

Due to Covid - we dont engage classroom training till situations are ok

Got Questions

Please email to info@thecloudenabled.com and we will be happy to help

This course is designed , developed and delivered by Cloud Enabled Pte Ltd