Everything about MariaDB(MySQL) - Advanced

Name: Everything about MariaDB(MySQL) - Advanced
Price: 30800 KRW
Rating: 4.5 (6 reviews)

Learn everything you need to know about MariaDB (MySQL) as a developer, including beginners, backend developers, and SQLD exam preparation students. The class is focused on hands-on practice, where you will build your own DB.

(4.5) 6 reviews

187 learners

Level Basic

Course period Unlimited

bradkim

MariaDB

MySQL

sql-join

transaction

concurrent

MariaDB

MySQL

sql-join

transaction

concurrent

What you will gain after the course

transaction
Concurrency Issues and Solutions
join(inner, outer) statement
group by and aggregate functions
DB design (ERD design, normalization)
db dump task
Procedures and views

Class progress method

This class is for those who want to learn mariadb and mysql DB. All classes are conducted with a focus on practice while also covering theory.

In the basics, you will learn mainly about DB installation, DDL syntax for table construction (CREATE, ALTER, DROP), DML syntax for processing data within tables (insert, select, update, delete), types, constraints, etc.

In the advanced section, you will learn about transactions, concurrency issue resolution, joins, indexes, DB design (ERD design, normalization), DB dump operations, procedures, and views.

If you skip the basics and take the advanced course

Those who have basic knowledge of SQL queries can skip the basics and go to the advanced section. (You should know queries such as lookups and inserts and what pk and fk are. That should be enough.)

However, since the advanced course is conducted using the DB built in advance in the basic course, if you build the DB according to the procedure below, you will have no difficulty taking the advanced course right away.

 1 ) Download and install mariadb, install workbench (or dbeaver, datagrip), install vscode

2 ) Board database creation query statement
CREATE DATABASE board; USE board;

3 ) Create author table and insert data 

3 -1 ) Create a table
CREATE TABLE author (id INT NOT NULL AUTO_INCREMENT, name VARCHAR ( 100 ) DEFAULT 'anonymous' , email VARCHAR ( 255 ) NOT NULL , password VARCHAR ( 20 ), age TINYINT UNSIGNED, gender CHAR ( 1 ), self_introduction TEXT, profile_image VARCHAR ( 255 ), role ENUM( 'user' , 'admin' ) NOT NULL DEFAULT 'user' , PRIMARY KEY (id), UNIQUE (email));

3 -2 ) Data insertion
INSERT INTO author (name, email, password) VALUES ( 'hong1' , 'hong1@naver.com' , '1234' ), ( 'hong2' , 'hong2@naver.com' , '1234' ), ( 'hong3' , 'hong3@naver.com' , '1234' ), ( 'hong4' , 'hong4@naver.com' , '1234' ), ( 'hong4' , 'hong5@naver.com' , '1234' );


4 ) Create posts table and insert data

4 -1 ) Create a table
CREATE TABLE posts (id INT NOT NULL AUTO_INCREMENT, title VARCHAR ( 255 ) NOT NULL , contents VARCHAR ( 3000 ), author_id INT , price DECIMAL ( 10 , 3 ), created_time DATETIME DEFAULT CURRENT_TIMESTAMP (), user_id CHAR ( 36 ) DEFAULT UUID(), PRIMARY KEY (id), KEY (author_id), CONSTRAINT post_author_fk FOREIGN KEY (author_id) REFERENCES author (id) ON DELETE CASCADE);

4 -2 ) Insert data
INSERT INTO posts (title, contents, author_id, price) VALUES ( 'java' , 'java is ...' , 1 , null ),( 'python' , 'python is ...' , 1 , null ),( 'java2' , null , 1 , 10.346 );

Teaching materials

All class materials are based on the Notion materials in the link below.

https://picturesque-staircase-f6e.notion.site/MariaDB-0637f39566314a32a50988b42fb09454?pvs=74

In addition to the text material above, the instructor organizes various command statements that occur during DB practice into materials during class to make them easier to review.

Recommended for
these people

Who is this course right for?

Development Beginner
Backend Developer
Those preparing for exams related to databases such as SQL
General public interested in db

Hello
This is bradkim

Inflearn Verified

Career Verified

3,738

Learners

402

Reviews

135

Answers

4.9

Rating

Courses

💪💪💪An expert with both practical and teaching experience 💪💪💪

Hello, I'm Seonguk Kim. I graduated from Yonsei University and have worked as a software engineer at major corporations and startups. Currently, I am working as a full-time instructor for corporate training and bootcamps. As an instructor with both practical and teaching experience, I will deliver essential knowledge in an easy-to-understand manner.

Profile : https://www.linkedin.com/in/seongukkim

Corporate training inquiries: ksg39412@naver.com

Curriculum

All

22 lectures ∙ (8hr 52min)

Section 1. transaction

3 lectures ∙ (52min)

Section 2. Concurrency Issues

2 lectures ∙ (1hr 9min)

4. Concurrency and Isolation Levels
52:41
5. Solving concurrency issues (program level)
17:16

Section 3. JOIN(INNER JOIN, OUTER JOIN)

5 lectures ∙ (2hr 27min)

6. JOIN Basic
38:05
7. JOIN related SQL problem solving
27:22
8. UNION and Subqueries
27:40
9. GROUPBY and aggregate functions
26:06
10. having condition and sql problem solving
28:46

Section 4. INDEX

2 lectures ∙ (41min)

Section 5. ERD design

6 lectures ∙ (2hr 14min)

Section 6. DB dump, user management, VIEW, procedure

4 lectures ∙ (1hr 25min)

Published: 12/23/2024

Last updated: 06/12/2025

Reviews

All

6 reviews

4.5

6 reviews

parksw6402
Reviews 3
∙
Average Rating 5.0
03/27/2025
5
100% enrolled
Thank you for the great lecture.
s1121238291
Reviews 91
∙
Average Rating 4.9
06/25/2025
5
100% enrolled
I enjoyed it!
yeonhongmin9780
Reviews 19
∙
Average Rating 4.6
04/27/2025
5
32% enrolled
dachki
Reviews 74
∙
Average Rating 5.0
01/09/2026
5
64% enrolled
djyoon
Reviews 9
∙
Average Rating 5.0
01/26/2026
5
32% enrolled

bradkim's other courses

Check out other courses by the instructor!

Everything about AI Agent Development Learned by Building a Chatbot (FastAPI, RAG, Vector, LangChain, sLLM/Fine-tuning)

bradkim

You will learn about RAG, VectorDB, LangChain, OpenAI, sLLM, and fine-tuning, which encompass the most important AI-related technologies at this time.

Beginner

RAG, vector-database, FastAPI

Everything about AI Agent Development Learned by Building a Chatbot (FastAPI, RAG, Vector, LangChain, sLLM/Fine-tuning)

bradkim

Deploying a Spring Production Server Using EKS (feat. Everything About DevOps)

bradkim

You will learn about the overall DevOps process, including domain purchasing, deploying Spring Boot production servers using EKS, Docker basics, Kubernetes basics, AWS basics, CI/CD automation via GitHub Actions, ArgoCD, and Prometheus/Grafana.

Basic

AWS, Docker, Kubernetes

Deploying a Spring Production Server Using EKS (feat. Everything About DevOps)

bradkim

Practical Kafka: Getting Straight to the Core Fast

bradkim

Learn the basic, essential, and practical knowledge of Kafka that software developers need to know. We will integrate Kafka using Spring Boot and conduct hands-on exercises for sending and receiving messages tailored to various real-world scenarios.

Beginner

Spring Boot, Kafka, MSA

Practical Kafka: Getting Straight to the Core Fast

bradkim

Websocket/STOMP Chat Service (spring, vue, redis)

bradkim

We develop a chat service using web socket/stomp and springboot. We also configure a simple screen using vue.js, which is a relatively easy framework. We also configure multi-server scalability design using redis pub/sub.

Basic

websocket, pubsub, Spring Boot

Websocket/STOMP Chat Service (spring, vue, redis)

bradkim

Kakao, Google SNS Login (springboot3, vue3)

bradkim

Implement Kakao and Google login using Spring Boot. JWT token-based login will be implemented. A simple interface will be constructed using Vue 3.

Basic

OAuth, oauth2, JWT

Kakao, Google SNS Login (springboot3, vue3)

bradkim

Redis Basics Every Developer Should Know

bradkim

Learn the basic data structures of REDIS and examples of practical use of REDIS through redis-cli (command) practice.

Beginner

Redis, devops, database

Redis Basics Every Developer Should Know

bradkim

Quick Start Guide to Spring Cloud Basics (MSA)

bradkim

Learn about configuring an MSA server using Spring Cloud.

Basic

Spring Cloud, MSA, eureka

Quick Start Guide to Spring Cloud Basics (MSA)

bradkim

Git/GitHub for Practical Use (feat. Resolving Various Conflict Situations)

bradkim

You will learn everything from the basic knowledge of Git/GitHub to practical solutions and strategies for various conflict situations encountered in the field.

Beginner

Git, GitHub, gitlab

Git/GitHub for Practical Use (feat. Resolving Various Conflict Situations)

bradkim

Everything about MariaDB(MySQL) - Basic

bradkim

Beginner

MariaDB, MySQL

Everything about MariaDB(MySQL) - Basic

bradkim

Basic Linux (Ubuntu) knowledge for developers

bradkim

Learn essential Linux knowledge that every developer should know, even if they're not a DevOps or Linux expert. The class will be hands-on and practice-oriented.

Beginner

Linux, ubuntu, Shell Script

Basic Linux (Ubuntu) knowledge for developers

bradkim

Similar courses

Explore other courses in the same field!

Everything about MariaDB(MySQL) - Basic

bradkim

Beginner

MariaDB, MySQL

Everything about MariaDB(MySQL) - Basic

bradkim

@Sico - Learn MySQL Properly (Perfect Basics)

seniorcoding

The importance of MySQL is constantly being highlighted in various aspects. Through this lecture, you will learn step by step and through this, you will jump to the intermediate level in one go.

Basic

MySQL

@Sico - Learn MySQL Properly (Perfect Basics)

seniorcoding

Location Finding with MySQL Geospatial Query and Image Caching with AWS

July

We will inform you about the platform mass adoption method using AWS (S3, CloudFront) and MySQL (Geospatial Query).

Basic

MySQL, s3, cloudfront

Location Finding with MySQL Geospatial Query and Image Caching with AWS

July

Project Structure and Database Handling for Backend Employment [MySQL, Mongo]

July

This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

Basic

MySQL, MongoDB, ERD

Project Structure and Database Handling for Backend Employment [MySQL, Mongo]

July

MariaDB Database Practical Completion - From Installation to Operation

wendy34647345

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.

Basic

SQL, MariaDB, database

MariaDB Database Practical Completion - From Installation to Operation

wendy34647345

MySQL from a Kakao Interviewer Handling 1 Trillion++ Data Points

Hong

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

Beginner

MySQL, DBMS/RDBMS, Data Engineering

MySQL from a Kakao Interviewer Handling 1 Trillion++ Data Points

Hong

Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It

nullnull8537

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

Basic

Java, MySQL, utf-8

Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It

nullnull8537

Data Modeling using JPA

oncoding

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.

Intermediate

Java, MySQL, Spring Boot

Data Modeling using JPA

oncoding

Complete mastery of PHP programming practices! with MySQL

usefulit

This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

Beginner

PHP, phpmyadmin, MySQL

Complete mastery of PHP programming practices! with MySQL

usefulit

MySQL Master Course for Data Analysts and IT Engineers!

moduai

A must-have subject for aspiring developers and those looking to get a job in big data!!

Basic

MySQL, SQL, Big Data

MySQL Master Course for Data Analysts and IT Engineers!

moduai

PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

Hong

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

Beginner

MySQL, PostgreSQL, Oracle

PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

Hong

Creating a table using public data CSV file

swa

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

Intermediate

SQL, HeidiSQL, MariaDB

Creating a table using public data CSV file

swa

Smart SQL Learning Methods in the AI Era [Introductory]

tani

I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

Beginner

SQL, MySQL, DBMS/RDBMS

Smart SQL Learning Methods in the AI Era [Introductory]

tani

Everything about MariaDB(MySQL) - Advanced

What you will gain after the course

Class progress method

If you skip the basics and take the advanced course

Teaching materials

Recommended for these people

HelloThis is bradkim

Curriculum

Reviews

bradkim's other courses

Similar courses

Recommended for
these people

Hello
This is bradkim