Everything about MariaDB(MySQL) - Basic

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.

(4.7) 13 reviews

114 learners

Level Beginner

Course period Unlimited

MariaDB
MariaDB
MySQL
MySQL
MariaDB
MariaDB
MySQL
MySQL

Reviews from Early Learners

4.7

5.0

방주영

43% enrolled

I used to study SQL theory for another exam, but I needed practical database skills, so I took the class. I could see that the instructor who taught the class cared about the students. It was impressive that he helped us organize the content by reviewing the topics we had learned. He also helped us review the content by solving SQL problems together. If you are a beginner in SQL, I think it would be better to read the provided course materials and watch the class. Thank you to the instructor for creating such a high-quality class. If there is an advanced course, I will definitely take it.

5.0

석승민

100% enrolled

The voice is nice, so the class content is easy to understand, the explanation is clear, and it is organized once more, so it was a lecture that I remember well. I will listen to the advanced part as well. I hope you will make more good lectures.

5.0

jangsh307

100% enrolled

I was able to quickly grasp the core content in a short amount of time. The clear explanation was excellent. I was so satisfied while listening that I ended up purchasing the advanced courses for Redis, Git, and MariaDB as well. I'll take the rest of the courses and leave a review. Thank you.

What you will gain after the course

  • DDL query (create, alter, drop)

  • DML Query (insert, select, update, delete)

  • mariadb data types (integer, float, string, date)

  • Search by search pattern (like)

  • Constraints (unique, foreign key, primary key, etc.)

  • Flow control (case, if, ifnull, etc.)


Class progress method

This course is for those who want to learn mariadb and mysql DB.

All classes are focused on practice, with a mix of theory and practice.

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, joins, indexes, DB design (normalization), DB dumps, procedures, views, etc.



Teaching materials

All class materials are based on the Notion materials in the link below.

https://picturesque-staircase-f6e.notion.site/MariaDB-6c36d2b451544a07bcb59bd2ab611a3d

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

Learners

361

Reviews

128

Answers

4.9

Rating

10

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

More

Curriculum

All

14 lectures ∙ (5hr 26min)

Published: 
Last updated: 

Reviews

All

13 reviews

4.7

13 reviews

  • rjsgml05226861님의 프로필 이미지
    rjsgml05226861

    Reviews 2

    Average Rating 5.0

    5

    29% enrolled

    Your easy explanations helped me understand quickly.

    • wndud416062304151님의 프로필 이미지
      wndud416062304151

      Reviews 1

      Average Rating 5.0

      5

      43% enrolled

      I used to study SQL theory for another exam, but I needed practical database skills, so I took the class. I could see that the instructor who taught the class cared about the students. It was impressive that he helped us organize the content by reviewing the topics we had learned. He also helped us review the content by solving SQL problems together. If you are a beginner in SQL, I think it would be better to read the provided course materials and watch the class. Thank you to the instructor for creating such a high-quality class. If there is an advanced course, I will definitely take it.

      • bradkim
        Instructor

        Thank you for your thoughtful review. In the advanced course, you will be able to gain a lot of practical knowledge related to DB, so please look forward to it. It will be uploaded soon.

    • jaha03084652님의 프로필 이미지
      jaha03084652

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      I felt lost taking on a simple work project, but thank you for teaching me so well, simply and concisely. :)

      • s1121238291님의 프로필 이미지
        s1121238291

        Reviews 87

        Average Rating 4.9

        5

        100% enrolled

        I enjoyed it!

        • workerysk님의 프로필 이미지
          workerysk

          Reviews 6

          Average Rating 4.8

          5

          36% enrolled

          I appreciate you explaining it so thoroughly.

          bradkim's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!