MariaDB Tutorial

MariaDB Database Course-MariaDB Database Basics for Perl Developers

Getting Started with MariaDB will give you a detailed explanation of how to install MariaDB and the basics of MariaDB. The goal is for Perl developers to learn the basics of MariaDB and master working with working-level databases. MariaDB is a MySQL-compatible relational database system forked from MySQL. The project was forked when MySQL was acquired by Oracle.

As of 2021, MariaDB and MySQL have a significant difference in their internal source code. There was also a change in the version numbering method. It is also expected that the difference in external functions will widen. Therefore, I decided to create a commentary site for MariaDB.

• Video introduction

MariaDB installation

This is an explanation of how to install MariaDB.

Installing MariaDB on Ubuntu

• MariaDB installation-see database entry
• MariaDB start / stop / initial settings

Connecting to MariaDB database

• Connect to MariaDB database

User management

• Set root password
• Reset the root password
• Create a user --create user
• Password setting, database and table permission setting --grant statement
• Display a list of users
• Delete user

Database management

• use --Select a database
• Create a database
• Display a list of databases --show databases statement
• Drop the database --drop database statement

Basic SQL

• insert statement-insert line
• update statement --line update
• select statement-select line

Saving and loading data

• Output the contents of the table as CSV
• Read CSV file data into table

MariaDB function

• replace function-replaces a string

Table management

• create table --create a table
• Display a list of tables
• Rename table --rename table statement

Field definition

• Change field definition --alter table change column statement
• Initialization and update of datetime type representing datetime at current time

Disk capacity survey

• Check the table capacity and database capacity with MariaDB

Database engine

• Check the type of database engine
• Change the database engine

Foreign key constraint

• Check foreign key constraints
• Remove foreign key constraints

Index

• Create an index
• Delete index
• Check the index

Performance survey

• explain --View SQL execution plan for SQL performance investigation

MariaDB settings

• MariaDB defaults to 3306
• Disable SQL mode "STRICT_TRANS_TABLES"
• Check the SQL mode "sql_mode"

Article list

• Article list

MariaDB related courses

MariaDB related course.

MariaDB related course.

> Web application development

Since web applications are heavily accessed in parallel by clients, storing data in a relational database like MariaDB is almost essential.

• Introduction to Perl Web App Development

Data analysis

When data analysis retrieves data from a database, it is likely that the data is stored in a relational database such as MariaDB.

• Introduction to Data Analysis

Build MariaDB environment on Linux

There is a course on how to learn the basics of Linux and build an environment for MariaDB on Ubuntu.

• Introduction to Linux
• Ubuntu environment construction

Connect to database from Perl program

Learn the basics of Perl and learn how to connect to a database from a Perl program using the OR Mapper.

• Perl Seminar-Introduction to Perl Programming
• DBIx::Custom --Simple database access library with SQL

Ask questions about MariaDB

The Perl Club has a members-only Perl Club Forum where you can ask questions about MariaDB. You can also use Twitter's reply / direct message and Youtube's comment section.

• Perl Club Forum
• Twitter
• Youtube