MariaDB Standard DBA - Agilitics


Maria DB

This class will school you in the essentials of the DBA trade, and 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 tasks such as backups and restoration, monitoring and maintaining databases, and user security. This course will also prepare students for the MariaDB Certified Database Administrator Associate certification exam.

Duration: 3 days
Time: 9am to 5pm

 

 

Learning Objectives

This course teaches participants the following skills:

 Basic SQL knowledge and familiarity with fundamental database concepts Prior experience with MariaDB or MySQL

 

You’ll learn many things in this course related to administering MariaDB. In particular, you’ll learn how to:

 Install, configure and upgrade MariaDB Perform the MariaDB start and shutdown operations Activate and manage MariaDB server logs Describe MariaDB server internals Evaluate data types and character sets Understand MariaDB schema objects including views, triggers and table partitioning Compare and gain an understanding of the multiple storage engines in MariaDB Understand transactions and data locking in MariaDB Manage users, roles and security including data at rest encryption and password strength checking Perform backup and restore operations using different backup methods, such as MariaDB Backup Understand how MariaDB uses resources such as disk and memory Gain an understanding of performance tuning techniques Describe the fundamentals of high availability Configure and monitor MariaDB replication Gain an understanding of MariaDB MaxScale Describe advanced features in Mariadb such as PL/SQL and Windows functions and CTE

Audience Prerequisites

 Basic SQL knowledge and familiarity with fundamental database concepts Prior experience with MariaDB or MySQL

 
× How can I help you?