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.
192 learners
Level Basic
Course period Unlimited
Reviews from Early Learners
5.0
SPRING
I enjoyed it!
5.0
parksw
Thank you for the great lecture.
5.0
mal_los
You explain things clearly and in an easy-to-understand way.
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
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.
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 );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.
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
Inflearn Verified
Career Verified
4,402
Learners
438
Reviews
140
Answers
4.9
Rating
14
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
All
22 lectures ∙ (8hr 52min)
All
7 reviews
4.6
7 reviews
Reviews 3
∙
Average Rating 5.0
Reviews 8
∙
Average Rating 4.9
Reviews 100
∙
Average Rating 4.9
Reviews 19
∙
Average Rating 4.6
Reviews 9
∙
Average Rating 5.0
Check out other courses by the instructor!
Explore other courses in the same field!
![[A hundred words are not as good as seeing once] Basic SQL for data analysisCourse Thumbnail](https://cdn.inflearn.com/public/courses/324566/cover/aa1fac55-6e80-4506-9c92-f32c2b65f93a/sql_basic.png?w=420)
