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

165 learners

Level Basic

Course period Unlimited

bradkim

이론 실습 모두

최적화

db설계

MariaDB

MySQL

sql-join

transaction

concurrent

이론 실습 모두

최적화

db설계

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`

3,028

Learners

312

Reviews

122

Answers

4.9

Rating

9

Courses

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

Hello, I am instructor Seonguk Kim (bradkim). I graduated from Yonsei University and have worked as a software engineer for over 8 years at major corporations and startups. Currently, I am working as a full-time instructor at a bootcamp. As an instructor with both practical industry experience and teaching expertise, I will deliver essential knowledge in an easy-to-understand manner.

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

`Curriculum`

All

22 lectures ∙ (8hr 52min)


1. 0. Instructions
03:54
2. Transaction Overview
17:06
3. Transaction Practice
31:46


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


6. JOIN Basic38:05
7. JOIN related SQL problem solving27:22
8. UNION and Subqueries27:40
9. GROUPBY and aggregate functions26:06
10. having condition and sql problem solving28:46

Published:

Last updated:

`Reviews`

All

5 reviews

5.0

5 reviews

s1121238291Reviews 74 ∙ Average Rating 4.9
5
100% enrolled
I enjoyed it!
yeonhongmin9780Reviews 15 ∙ Average Rating 4.7
5
32% enrolled
parksw6402Reviews 3 ∙ Average Rating 5.0
5
100% enrolled
Thank you for the great lecture.
djyoonReviews 9 ∙ Average Rating 5.0
5
32% enrolled
dachkiReviews 64 ∙ Average Rating 5.0
5
64% enrolled

$34.10

`bradkim's other courses`

Check out other courses by the instructor!


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.
초급
websocket, pubsub, Spring Boot
Websocket/STOMP Chat Service (spring, vue, redis)
bradkim


Quick Start Guide to Spring Cloud Basics (MSA)
bradkim
Learn about configuring an MSA server using Spring Cloud.
초급
Spring Cloud, MSA, eureka
Quick Start Guide to Spring Cloud Basics (MSA)
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.
입문
Redis, devops, database
Redis Basics Every Developer Should Know
bradkim


Everything about MariaDB(MySQL) - Basic
bradkim
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.
입문
MariaDB, MySQL
Everything about MariaDB(MySQL) - Basic
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.
초급
AWS, Docker, Kubernetes
Spring production server deployment using EKS (feat. everything about DevOps)
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 you'll encounter in the field.
입문
Git, GitHub, gitlab
Git/GitHub for Practical Use (feat. Resolving Various Conflict Situations)
bradkim


Kakao, Google SNS login (springboot3, vue3)
bradkim
Implementing Kakao and Google login using Spring Boot. JWT token-based login is implemented. A simple screen is configured through Vue3.
초급
OAuth, oauth2, JWT
Kakao, Google SNS login (springboot3, vue3)
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.
입문
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
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.
입문
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.
초급
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).
초급
MySQL, s3, cloudfront
Location Finding with MySQL Geospatial Query and Image Caching with AWS
July


Building a Stateful Service for Large-Scale Chat TPS
July
I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.
초급
Node.js, MySQL, Go
Building a Stateful Service for Large-Scale Chat TPS
July


Master Kotlin through Real Project Practice
Hong
Let's build a project using Ktor, the most popular project in Kotlin, and master Kotlin! 😆
입문
Kotlin, MySQL, ktor
Master Kotlin through Real Project Practice
Hong


Data analysis starting with SQL and Google Sheets
pbj0812
I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.
입문
SQL, Google Sheets, DBMS/RDBMS
Data analysis starting with SQL and Google Sheets
pbj0812


MySQL for Hundreds of Millions of Platform Data: Insights from a Kakao Interviewer
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.
입문
MySQL, DBMS/RDBMS, Data Engineering
MySQL for Hundreds of Millions of Platform Data: Insights from a Kakao Interviewer
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.
초급
Java, MySQL, utf-8
Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It
nullnull8537


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.
중급이상
SQL, HeidiSQL, MariaDB
Creating a table using public data CSV file
swa


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!!
초급
MySQL, SQL, Big Data
MySQL Master Course for Data Analysts and IT Engineers!
moduai


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.
입문
PHP, phpmyadmin, MySQL
Complete mastery of PHP programming practices! with MySQL
usefulit

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 .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

bradkim's other courses

Similar courses