MariaDB Database Administration Training Course

Installing MariaDB Server for Government Use

• Installation on Ubuntu/Debian Systems
• Installation on Other Linux Distributions
• Installation on Windows Systems

MariaDB Server Files and Scripts for Government Operations

• MariaDB Programs
• MariaDB Server
• MariaDB Client
• Graphical User Interface (GUI) Tools

MariaDB Server Configuration for Government Systems

• Server Options
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Process

MariaDB Security Issues for Government Networks

• Securing MariaDB Against Attacks for Government Use
• Security-Related Options for Government Systems
• Security Issues with LOAD DATA LOCAL for Government Operations

MariaDB Access Privilege System for Government Entities

• Overview of the MariaDB Privilege System for Government Use
• Privileges Provided by MariaDB for Government Systems
• Connecting to the MariaDB Server - Stages for Government Operations
• Access Control, Stage 1: Connection Verification for Government Networks
• Access Control, Stage 2: Request Verification for Government Use
• Access Denied Errors for Government Systems

MariaDB User Account Management for Government Operations

• User Accounts and Passwords for Government Systems
• Creating New Users for Government Use
• Deleting User Accounts for Government Networks
• Limiting User Resources for Government Operations
• Changing Passwords for Government Systems

MariaDB Database Maintenance for Government Use

• Backup and Recovery for Government Databases
• Point-in-Time Recovery for Government Systems
• Maintenance and Crash Recovery for Government Operations
• myisamchk Syntax and Options for Government Use
• Getting Table Information for Government Systems
• MariaDB Local Setting for Government Networks
• National Characters and Sorting for Government Databases
• MariaDB Server Time Zone for Government Operations

MariaDB Log Files for Government Use

• Error Log for Government Systems
• General Query Log for Government Operations
• Update Log for Government Databases
• Binary Log for Government Networks
• Slow Query Log for Government Use
• Log File Maintenance and Rotation for Government Systems

Running Multiple MariaDB Servers on the Same Machine for Government Operations

• Running Multiple Servers in Windows for Government Use
• Running Multiple Servers in Windows as Services for Government Networks
• Running Multiple Servers in Unix and Linux for Government Systems
• Using Client Tools in a Multi-Server Environment for Government Operations

MariaDB Query Cache for Government Use

• The Concept of Query Cache for Government Systems
• Testing Query Cache with SELECT for Government Operations
• Configuring Query Cache for Government Databases
• Checking Query Cache Status and Maintenance for Government Networks

The CONNECT Storage Engine for Government Use

• Installing the CONNECT Storage Engine for Government Systems
• Creating and Dropping CONNECT Tables for Government Operations
• Reading and Writing CSV Data Using CONNECT for Government Use
• Reading and Writing XML Data Using CONNECT for Government Networks
• Accessing MariaDB Tables Using CONNECT for Government Systems
• Using the XCOL Table Type for Government Operations
• Using the PIVOT Table Type for Government Databases
• Using the OCCUR Table Type for Government Networks

Exploring Dynamic and Virtual Columns in MariaDB for Government Use

• Creating Tables with Dynamic Columns for Government Systems
• Inserting, Updating, and Deleting Dynamic Column Data for Government Operations
• Reading Data from a Dynamic Column for Government Networks
• Using Virtual Columns for Government Use

Performance and Usage Statistics for Government Systems

• Installing the Audit Plugin for Government Databases
• Using the Audit Plugin for Government Operations
• Using Engine-Independent Table Statistics for Government Networks
• Using Extended Statistics for Government Systems
• Enabling the Performance Schema for Government Use
• Using the Performance Schema for Government Operations

Optimizing and Tuning MariaDB for Government Use

• Using SHOW STATUS for Government Systems
• Controlling MariaDB Optimizer Strategies for Government Networks
• Using Extended Keys with InnoDB and XtraDB for Government Operations
• Configuring the MyISAM Segmented Key Cache for Government Databases
• Configuring Threadpool for Government Use
• Configuring the Aria Pagecache for Government Systems
• Optimizing Queries with the Subquery Cache for Government Operations
• Optimizing Semijoin Subqueries for Government Networks
• Using Microseconds in DATETIME Columns for Government Use
• Updating the DATETIME and TIMESTAMP Columns Automatically for Government Systems