강의

멘토링

커뮤니티

Programming

/

Database

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.9) 12 reviews

110 learners

Level Beginner

Course period Unlimited

  • bradkim
MariaDB
MariaDB
MySQL
MySQL
MariaDB
MariaDB
MySQL
MySQL

Reviews from Early Learners

Reviews from Early Learners

4.9

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

3,031

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

14 lectures ∙ (5hr 26min)

Published: 
Last updated: 

Reviews

All

12 reviews

4.9

12 reviews

  • 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.

  • workerysk님의 프로필 이미지
    workerysk

    Reviews 6

    Average Rating 4.8

    5

    36% enrolled

    I appreciate you explaining it so thoroughly.

    • s1121238291님의 프로필 이미지
      s1121238291

      Reviews 74

      Average Rating 4.9

      5

      100% enrolled

      I enjoyed it!

      • hongkaon님의 프로필 이미지
        hongkaon

        Reviews 5

        Average Rating 4.6

        4

        100% enrolled

        While taking a JSP class at school, there was a week where we learned by connecting to a DB, and after listening to the basic MariaDB lecture, it seemed like a good time to review the SQL commands I had forgotten 2 years ago. It seems like a worthwhile lecture for those who are new to SQL.

        • 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. :)

          $26.40

          bradkim's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!