Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

Introduction to MariaDB

  • Course Code: Database MDB1
  • Course Dates: Contact us to schedule.
  • Course Category: Big Data & Data Science Duration: 4 Days

About this Course  

MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available. 

From installing and configuring through basic usage and maintenance, each module in this course leads you on a sequential and logical exploration of everything you need to know about MariaDB.  This course includes the latest release of MariaDB and covers all the latest features and functions.  By the end of this training course, you will know how to install and run MariaDB, and you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.   

This 4-day class teaches you everything you need to know to confidently setup, configure, administer, secure and use MariaDB. 

What You Will Learn 

  • Install MariaBD on Windows, Mac OS X, and Linux 
  • Configure MariaDB for better performance using the features of version 10 
  • Get familiar with the usage of operators for retrieving rows more selectively 
  • Use MariaDB 10’s powerful tools to store, retrieve, and analyze data 
  • Secure MariaDB from unauthorized access 
  • Maintain the databases associated with MariaDB to ensure efficient and optimum functioning 
  • Retrieve data and learn how to sort, summarize, group, and manipulate it 

Course Outline 

1: Installing MariaDB 

  • Choosing a MariaDB series 
  • Installing MariaDB on Windows 
  • Installing MariaDB on Mac OS X 
  • Installing MariaDB on Debian, Ubuntu, and Linux Mint 
  • Installing MariaDB on Fedora, Red Hat, and CentOS 
  • Installing MariaDB on other Linux distributions 
  • MariaDB package security 
  • After the installation 
  • Troubleshooting installation issues 

2: Configuring MariaDB 

  • The MariaDB filesystem layout 
  • Modular configuration on Linux 
  • The anatomy of the MariaDB configuration file 
  • Activating configuration changes 

3: Securing MariaDB 

  • Security layers 
  • Securing MariaDB in 10 seconds 
  • Connecting safely 
  • Server security 
  • Building security 
  • Internal network security 
  • Internet security 

4: Administering MariaDB 

  • User privileges 
  • Creating users 
  • Granting, revoking, and showing permissions 
  • Setting and changing passwords 
  • Removing users 

5: Using MariaDB – Databases and Tables 

  • The mysql command-line client application 
  • Connecting to MariaDB 
  • Using USE to select a database 
  • Using SHOW to list all databases on a server 
  • Creating and deleting databases 
  • Data, tables, and normalization 
  • Creating, altering, and dropping tables 

6: Using MariaDB – Inserting, Updating, and Deleting 

  • Using INSERT 
  • Using UPDATE 
  • Using DELETE 

7: Using MariaDB – Retrieving Data 

  • Retrieving data 
  • Filtering and searching data 
  • Summarizing data 

8: Maintaining MariaDB 

  • MariaDB log files 
  • Optimizing and tuning MariaDB 
  • Backing up, importing, and restoring data 
  • Repairing MariaDB 
View All Courses

    Course Inquiry

    Fill in the details below and we will get back to you as quickly as we can.

    Interested in any of these related courses?