Everything about MariaDB(MySQL) - Advanced

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

157 learners

bradkim

이론 실습 모두

최적화

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`

2,805

Learners

290

Reviews

121

Answers

5.0

Rating

9

Courses

💪💪💪실무와 강의 경력을 갖춘 전문가 💪💪💪

안녕하세요 김선국(bradkim) 강사입니다. 연세대학교를 졸업하고 대기업, 스타트업 등에서 8년 이상을 소프트웨어 엔지니어로 일해왔습니다. 현재는 부트캠프에서 전업 강사로 일하고 있습니다. 실무 경험과 강의 경험을 모두 갖춘 강사로서, 여러분들에게 반드시 알아야할 지식들 위주로 알기쉽게 전달 드리겠습니다.

프로필 : 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

3 reviews

5.0

3 reviews

s1121238291Reviews 67 ∙ Average Rating 4.9
5
100% enrolled
I enjoyed it!
yeonhongmin9780Reviews 15 ∙ Average Rating 4.7
5
32% enrolled
parksw6402Reviews 2 ∙ Average Rating 5.0
5
100% enrolled
Thank you for the great lecture.

Limited time deal ends in 7 days

$30,800.00

30%

$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


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


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


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


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


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


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


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

`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


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


DATABASE 1&2 - MySQL
Egoing Lee
It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.
초급
MySQL, DBMS/RDBMS
DATABASE 1&2 - MySQL
Egoing Lee


Create automation using Google Authenticator, QR, and Cron
July
In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site.

We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!
초급
Go, MySQL, Web Scraping
Create automation using Google Authenticator, QR, and Cron
July


Workflow-Based Large-Scale Traffic Processing Techniques with Kakao Developers (Interviewers)
Hong
How to Handle Explosive Traffic Growth? Learn to build resilient and flexibly scalable architectures through practical design patterns based on EDA (Event-Driven Architecture) using Kafka, Spring, CDC, and Temporal. Explained clearly and simply with real-world experience from Kakao developers, making it understandable even for non-majors. A hands-on focused course covering real-time data flow, event processing, and microservice integration all at once!
입문
Spring, Kotlin, MySQL
Workflow-Based Large-Scale Traffic Processing Techniques with Kakao Developers (Interviewers)
Hong


Concepts and tuning methods considered when migrating 20 billion data to MySQL
July
We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.
초급
MySQL, mysql-workbench, mysql-query
Concepts and tuning methods considered when migrating 20 billion data to MySQL
July


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


[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.
입문
SQL, MySQL, kakao-service
[A hundred words are not as good as seeing once] Basic SQL for data analysis
datarian


AI Era Smart SQL Learning [Beginner]
tani
I learned it the hard way, so you can learn it the easy way
I've discarded unnecessary theory and included only the SQL essentials.
Quickly build your SQL confidence.
입문
SQL, MySQL, DBMS/RDBMS
AI Era Smart SQL Learning [Beginner]
tani


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

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