inflearn logo

MariaDB Database Practical Completion - From Installation to Operation

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

1 learners are taking this course

Level Basic

Course period 1 months

SQL
SQL
MariaDB
MariaDB
database
database
cron
cron
optimizing
optimizing
SQL
SQL
MariaDB
MariaDB
database
database
cron
cron
optimizing
optimizing

What you will gain after the course

  • Understanding of MariaDB structure and ability to write basic SQL queries

  • Data manipulation techniques using joins, subqueries, and CRUD

  • Practical skills in table design, performance optimization, and backup and recovery

MariaDB Practical Completion
From Installation to Operation, Build a Solid Foundation!

Build practical database construction capabilities.


Starting from the installation and understanding of the MariaDB structure, you will learn SQL utilization,
functions, joins, and subqueries step by step.
Complete your database development and operation capabilities through practice focused on core practical functions.
Grow into a practical-oriented database expert..


MariaDB Practical Completion
Master everything from database basics to advanced operations.

It covers all core practical functions, including MariaDB installation, SQL query writing, function utilization, JOIN, Subquery, table design, performance management, and backup and recovery.



Beyond simple theoretical learning, you will develop the database management and development skills required in actual production environments.
Gain practical experience ranging from CRUD to loading external data.



From table creation to partition management, INDEX utilization, and log management.
Experience the entire process for stable database operation and performance optimization.

MariaDB Practical Completion:
Mastering from Installation to Operation

Section 1 - MariaDB Configuration and Overview

Configure the environment for MariaDB installation and learn the overall overview of the database along with the installation process in a Windows environment.

Section 2 - Understanding MariaDB Architecture

Understand the core structure of MariaDB and learn the characteristics and purposes of various storage engines to build a foundation for data management.

Section 3 - Basic SQL Query Utilization (1)

Understand the basic concepts of SQL and learn how to effectively search for data using the SELECT clause for data retrieval and the WHERE clause for conditional processing.

Section 4 - Basic SQL Query Utilization (2)

You will acquire advanced SQL query writing techniques for grouping, setting conditions, sorting, and paging data using the GROUP BY, HAVING, ORDER BY, and LIMIT clauses.

Section 5 - Utilizing Various Functions

Improve your data manipulation and analysis skills by utilizing various built-in functions provided by MariaDB, such as string, date, numeric, and control functions.

Section 6 - Table Join Techniques

Understand the concept of database normalization and practice various Join techniques to effectively combine data from multiple tables.

Section 7 - Utilizing Subqueries and CRUD

You will learn how to write subqueries (nested queries), efficiently perform Create, Read, Update, and Delete (CRUD) operations, and load external data.

Section 8 - Table Creation and Management

You will learn how to create and manage database tables, as well as master management techniques for special tables such as partitioned tables and CSV tables.

Section 9 - Database Performance Optimization

Optimize the performance of the MariaDB database and explore efficient operational methods through INDEX utilization strategies and log management.

Section 10 - Database Backup and Recovery

To ensure the stable operation of the database, we will understand the basic concepts of backup and recovery and practice various backup and recovery methods to prepare for data loss.

Mastering Core Practical Skills

Point 1. Mastering MariaDB Core

You will learn the entire process from MariaDB installation to operation through practice-oriented training. You can build a solid foundation through step-by-step learning, from understanding the basic structure of databases to writing SQL queries, utilizing functions, joins, and subqueries.


Point 2. Mastering Practical SQL

You will learn essential SQL syntax for data retrieval and processing, including SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT. By practicing functions and data manipulation techniques frequently used in real-world tasks through practical exercises, you will maximize your SQL proficiency.


Point 3. Database Design and Optimization

Learn table design methods for efficient data management and acquire practical know-how to optimize database performance through INDEX utilization and log management. You can master advanced techniques that can be applied to actual production environments.


Point 4. Backup/Recovery for Stable Operation

You will systematically learn backup and recovery strategies to prevent data loss and ensure system stability. By practicing various backup and recovery methods, you will develop the professional expertise to prepare for unexpected situations.


Mastering MariaDB database practice,
did it feel difficult?
This course was created specifically for people like you.


✔️ Beginners who want to learn MariaDB thoroughly from the basics to practical application

  • Those who want to learn step-by-step, from MariaDB installation to its basic structure

  • Those who want to master practical usage, from basic SQL queries to functions and joins

  • Those who want to complete core practical competencies such as database design, performance management, and backup/recovery

✔️ Backend developers and data practitioners who want to improve their SQL application skills

  • Those who want to learn efficient data manipulation methods using CRUD, joins, and subqueries

  • Those who want to create better services by mastering database performance optimization techniques

  • Those who want to improve their SQL skills for immediate application in real-world tasks

✔️ Practitioners in charge of database operation and management

  • Those who want to learn advanced management techniques such as MariaDB storage engines and partitioned tables

  • Those who want to gain practical performance management know-how, such as INDEX utilization and log management

  • Those who want to establish data backup and recovery strategies and develop stable DB operation capabilities


Learn everything about MariaDB and
complete your solid database practical skills!

Notes before taking the course


Practice Environment

  • Installation of the latest version of MariaDB is required.

  • A PC with Windows OS installed is recommended.

  • It is helpful to have basic knowledge of SQL and MariaDB.

Prerequisites and Important Notes

  • Understanding basic database concepts will be helpful for learning.

  • Prior study of basic SQL syntax is recommended.

  • Since this is a practice-oriented course, PC environment configuration is important.

Learning Materials

  • Lecture slide PDF materials are provided.


Recommended for
these people

Who is this course right for?

  • Office workers and developers who are new to MariaDB and want to build a solid foundation in database basics.

  • Backend developers and data practitioners who need to utilize SQL

  • Corporate executives and employees performing database operation and management tasks

Need to know before starting?

  • Basic computer operation and file management skills

  • Basic understanding of programming or data processing

  • Interest in database concepts or professional necessity

Hello
This is wendy34647345

Prime Contents Lab Co., Ltd. reads learning trends and designs its own courses. We constantly contemplate "who needs what." Based on the expertise of leading authors in each field, we create original educational programs ranging from IT/AI to the humanities that go beyond simple knowledge transfer to help achieve practical growth. Elevate your capabilities to the next level with the premium lectures proposed by Prime Contents Lab.

More

Curriculum

All

50 lectures ∙ (7hr 5min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

wendy34647345's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$56.10

33%

$84.70