Mastering Of Mariadb

Download Now

MariaDB Development and Administration

What you'll learn

Install and configure MariaDB effectively for optimized performance and security

Understand MariaDB's architecture and utilize it for efficient database management

Perform backups, monitor databases, and audit activity to ensure data integrity

Implement data encryption techniques to protect sensitive information

Transfer data to MariaDB and set up replication for improved data availability.

Create and manage database objects like tables, views, and indexes for efficient data organization

Requirements

Basic Linux skills

Basic SQL skills

Basic knowledge about relational databases

Description

This comprehensive course on MariaDB administration is designed for developers and database administrators looking to master the skills needed for effective MariaDB management. From setting up and configuring MariaDB to understanding its unique architecture, you'll gain hands-on knowledge essential for building and managing robust databases.Throughout the course, we'll dive into critical topics such as benchmarking, creating databases and objects, and performing efficient user and role management to secure your environment. You'll also learn essential backup and recovery strategies, along with auditing and monitoring practices to ensure data integrity and optimal performance.Security is a primary focus, with modules covering data encryption techniques to safeguard sensitive information from unauthorized access. Additionally, we'll explore data transferring to MariaDB, as well as setting up replication for high availability and fault tolerance, ensuring that your data is always accessible and reliable.Whether you're new to MariaDB or looking to deepen your expertise, this course will equip you with the tools and techniques needed to handle complex database environments effectively. By the end, you'll have a thorough understanding of MariaDB, ready to tackle real-world challenges and drive performance in any organization.Enroll today and start mastering MariaDB administration to enhance your database skills and advance your career in the dynamic field of database management!* These videos will be added by the end of November: Monitoring, Backup, upgrade

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Installing MariaDB

Lecture 2 Installing MariaDB

Section 3: Architecture of MariaDB

Lecture 3 Architecture of MariaDB

Section 4: Administration

Lecture 4 Create a Database

Lecture 5 Create User

Lecture 6 Grant Privileges

Lecture 7 Create Role

Lecture 8 Server System Variables

Lecture 9 Binary Log

Lecture 10 Benchmarking

Lecture 11 Basic Configuration

Section 5: Create Objects

Lecture 12 Create Table

Lecture 13 Create Index

Lecture 14 Create Routine

Lecture 15 Create Event

Lecture 16 Create Trigger

Lecture 17 Create View

Section 6: Transaction

Lecture 18 Transaction

Section 7: Auditing and Monitoring

Lecture 19 Audit Plugin

Lecture 20 Information Schema

Lecture 21 Performance Schema

Section 8: Create a Clone

Lecture 22 Create a Clone

Database Developers and Administrators


Download Now