We are a family owned USA based Corporate Training Company determined to help professionals, teams, and organizations improve.

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.

banner-img
Home » Technology » Big Data & Data Science » Introduction to MariaDB

Course Skill Level:

Foundational to Intermediate

Course Duration:

4 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Big Data & Data Science

  • Course Code:

    IMARIAN21J09

Who should attend & recommended skills:

Those with basic SQL & Maria DB experience

Who should attend & recommended skills

  • Those seeking to explore and learn how to use features that make MariaDB different from other databases in its class, in a practical, hands-on way.
  • SQL: Basic (1-2 years’ experience)
  • Maria DB: Basic (1-2 years’ experience) helpful, not required.

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.

Skills acquired & topics covered

  • Install MariaDB 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 breakdown / modules

  • 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

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

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

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

  • 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

  • Using INSERT
  • Using UPDATE
  • Using DELETE

  • Retrieving data
  • Filtering and searching data
  • Summarizing data

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

Browse our programs to take the next step toward advancing yourself, your team, and organization.

Browse Courses