Mastering Of Mariadb
Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
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
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 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
