Everything about MariaDB(MySQL) - Advanced

Name: Everything about MariaDB(MySQL) - Advanced
Price: 44000 KRW
Rating: 5 (5 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.

(5.0) 5 reviews

180 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

3,471

Learners

368

Reviews

130

Answers

4.9

Rating

Courses

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

Hello, I am instructor Seonguk Kim (bradkim). 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 at a bootcamp. 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

Contact: 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

5 reviews

5.0

5 reviews

parksw6402
Reviews 3
∙
Average Rating 5.0
03/27/2025
5
100% enrolled
Thank you for the great lecture.
s1121238291
Reviews 87
∙
Average Rating 4.9
06/25/2025
5
100% enrolled
I enjoyed it!
dachki
Reviews 74
∙
Average Rating 5.0
01/09/2026
5
64% enrolled
yeonhongmin9780
Reviews 19
∙
Average Rating 4.6
04/27/2025
5
32% 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!

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

Spring production server deployment using EKS (feat. everything about DevOps)

bradkim

You will learn about domain purchase and deploying a Spring Boot production server using EKS, Docker basics, Kubernetes basics, AWS basics, CI/CD automation through GitHub Actions, ArgoCD, and general DevOps topics such as Prometheus/Grafana, etc.

Basic

AWS, Docker, Kubernetes

Spring production server deployment using EKS (feat. everything about DevOps)

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

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

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

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

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

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

MariaDB client development, HeidiSQL

swa

Learn how to write SQL queries and work with databases using the MariaDB client development tool HeidiSQL.

Intermediate

SQL, MariaDB, HeidiSQL

MariaDB client development, HeidiSQL

swa

Master Kotlin through Real Project Practice

Hong

Let's build a project using Ktor, the most popular project in Kotlin, and master Kotlin! 😆

Beginner

Kotlin, MySQL, ktor

Master Kotlin through Real Project Practice

Hong

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

Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board

kuke

We will learn how to create a system to support large amounts of data and traffic by creating it directly with Spring Boot.

Intermediate

Spring Boot, MySQL, Redis

Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board

kuke

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

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

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

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

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

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

[A hundred words are not as good as seeing once] Basic SQL for data analysis

datarian

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

Beginner

SQL, MySQL

[A hundred words are not as good as seeing once] Basic SQL for data analysis

datarian

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

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