강의

멘토링

로드맵

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) 11 reviews

95 learners

  • bradkim
이론 실습 모두
DB_테이블_설계
MariaDB
MySQL

Reviews from Early Learners

What you will learn!

  • 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

2,520

Learners

225

Reviews

105

Answers

4.9

Rating

9

Courses

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

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

프로필 : https://www.linkedin.com/in/seongukkim

Curriculum

All

14 lectures ∙ (5hr 26min)

Published: 
Last updated: 

Reviews

All

11 reviews

4.9

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

  • s1121238291님의 프로필 이미지
    s1121238291

    Reviews 55

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

        • jjj82190404님의 프로필 이미지
          jjj82190404

          Reviews 1

          Average Rating 5.0

          5

          36% enrolled

          Limited time deal

          $19.80

          25%

          $26.40

          bradkim's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!