inflearn logo
inflearn logo

Everything about MariaDB(MySQL) - Advanced

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

MariaDB
MariaDB
MySQL
MySQL
sql-join
sql-join
transaction
transaction
concurrent
concurrent
MariaDB
MariaDB
MySQL
MySQL
sql-join
sql-join
transaction
transaction
concurrent
concurrent
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

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,053

Learners

315

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

More

Curriculum

All

22 lectures ∙ (8hr 52min)

Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • s1121238291님의 프로필 이미지
    s1121238291

    Reviews 75

    Average Rating 4.9

    5

    100% enrolled

    I enjoyed it!

    • yeonhongmin9780님의 프로필 이미지
      yeonhongmin9780

      Reviews 15

      Average Rating 4.7

      5

      32% enrolled

      • dachki님의 프로필 이미지
        dachki

        Reviews 69

        Average Rating 5.0

        5

        64% enrolled

        • djyoon님의 프로필 이미지
          djyoon

          Reviews 9

          Average Rating 5.0

          5

          32% enrolled

          • parksw6402님의 프로필 이미지
            parksw6402

            Reviews 3

            Average Rating 5.0

            5

            100% enrolled

            Thank you for the great lecture.

            bradkim's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $34.10