강의

멘토링

로드맵

BEST
Programming

/

Database

Playing with a MySQL Database by Yalco

MySQL for non-majors! This lecture quickly skims through essential concepts with brief explanations, then allows you to learn MySQL hands-on by "playing" with examples on the site.

(4.8) 305 reviews

4,815 learners

  • yalco
MySQL
SQL
DBMS/RDBMS
Data Engineering

Reviews from Early Learners

What you will learn!

  • The concept of relational databases

  • SQL Syntax and Various Applications

  • Various operators and functions in MySQL

  • Creating and deploying a web service using MySQL

Learn fast, master it with your hands!
DB Learning through Play with Yalko 🌠

⭐️ Do you have a university email account?
🎓 Go get the half-price coupon for college students (click) 👉

MySQL, Easy and Fun
Can't I learn? 🤔

Databases are difficult and boring because of the complicated theoretical explanations in books and lectures 😵
But in practice, when you use queries to directly handle data,
You will find that it is not as difficult as it looks, but rather a fun and interesting 🛠️ tool.

🌎 A database used everywhere!
Among them , the most widely used is MySQL🐬
Learn how to work with data.

I've always wanted to create easy-to-use video lectures that focus on practical use so that even people who don't know anything about programming can learn MySQL quickly and easily.

🎬 With the experience I gained from creating coding content and producing lectures on YouTube,
We planned this course so that you can learn MySQL with your hands, not your head .

  • Learn the main, basic grammar of SQL and various MySQL functions to learn how to input, retrieve, combine, and process information.
  • Also, by applying this to your website, you will get a general feel for how a database can be used in practice.

Oh, is this by any chance my story? ✅

  • 😱 I have no programming experience, so learning queries is burdensome.
  • 😵 The concept of MySQL is difficult and I don't know how to study it.
  • 🤔 I'm curious about how I can learn MySQL and use it in real life.

I recommend this to these people!

  • 👓 Non-majors who need to handle databases with SQL statements
  • 📚 Students taking database courses
  • 💻 Beginner developers who need to learn and use MySQL quickly

Learn by 'playing with it'.
You will experience amazing changes.

The MySQL queries you will learn are not difficult programming languages like C or Java, but a collection of simple commands to request specific tasks for data. At first glance, they may seem unfamiliar and complicated, but if you watch the lecture videos and practice by inputting or copying and pasting the examples, you will find that you can learn them easily and enjoyably. MySQL, which you have encountered in school lectures mainly in theory, can be learned much more effectively by ' playing with it' through this lecture.

In the last chapter (5), you will create a website that utilizes a database using MySQL and Node.js. All the codes are organized in a form that can be easily copied and pasted on the website so that even those who have never coded before can follow along. By creating this website and actually deploying it online, you can learn how databases can be applied to software and utilized.

  • You will be able to freely use MySQL's core functions by 'learning them by hand' .
  • You will gain confidence enough to seek out and study more content on your own.
  • You will be able to design a simple database.
  • You will be able to create a website using MySQL and deploy it yourself.

What's special about my lecture ✨

🚀 Quick and easy video lectures

Save your precious time with videos that teach you the essentials without any unnecessary details.
Depending on the student, the speed may feel fast. Be sure to check out the free part!!

🎲 Practical training rather than theory

You can learn MySQL 'as if you were playing' by using various functions in various ways, excluding difficult terms and concept explanations .

🖥️ Convenient practice through webpage

For each course, the main points of the video and the copy-and-paste practice code are organized on the webpage , so you can follow and apply them and easily proceed with the practice. Most of the practice is done on the online MySQL practice page without having to install anything separately on your computer.

😎 Main contents released for free

To ensure that students can study easily and without burden, you can preview the contents, excluding the practical part, for free .


This kind of content
I'm learning 📚

Basic concepts of MySQL

MySQL grammar and function practice through lecture pages

Creating software (web) using MySQL

Check out more of our curriculum!

🌱 Free Part (Sections 0-3) | 💰 Paid Part (Sections 4-5)

  • 🌱 Why Use MySQL and Relational Databases?
  • 🌱 Read, write, modify, and delete data with MySQL
  • 🌱 Use various functions and operator features
  • 🌱 Combine data (JOIN, subquery) to get the information you want
  • 💰 A taste of key constraints, views, transactions, and indexes
  • 💰 Create an online website by applying MySQL in practice


Who is Yalko? 😀

I am a YouTuber who broadcasts the YouTube channel Yalpakhan Coding Dictionary and an author who writes IT books . Based on my experience as a full-stack developer, I create content that explains difficult programming concepts with analogies, easy examples, and sometimes animations so that beginners can easily understand them.

🎬 YouTube Shallow Coding Dictionary Channel (Click!)
📕 Go see Yalko's books (click!)


Frequently Asked Questions
Check it out 💬

Q. Can I take the course even if I am not a major?

Yes, we made it so that even people with no programming knowledge can learn it easily.

Q. Why should I learn databases and SQL?

Regardless of the programming language and framework used, most software requires a database for production and operation. Since SQL allows you to freely handle and efficiently use data in a DB, knowing how to handle SQL is a strong specification for programmers in any field.

Q. Why MySQL?

MySQL is the most widely used database in the world along with Oracle (paid) because it is free to use and has sufficient performance. Since SQL syntax is similar to other databases, if you learn MySQL, you can learn other databases such as Oracle, MS SQL, and PostgreSQL very easily .

Recommended for
these people

Who is this course right for?

  • Non-developer who uses SQL queries for work

  • A person who is studying MySQL for the first time.

  • Anyone who wants to learn about databases as an attribute

Need to know before starting?

  • (Chapter 5 Only) Basic Web Programming Knowledge

Hello
This is

30,749

Learners

1,608

Reviews

93

Answers

4.9

Rating

17

Courses

유튜브 채널 얄팍한 코딩사전을 방송하는 유튜버이자, IT서적들을 집필하는 작가입니다.  풀스택 개발자로 일해 온 경험을 살려, 어려운 프로그래밍 개념들을 초보자들이 이해하기 쉽도록 비유와 쉬운 예제, 때로는 애니메이션으로 설명하는 컨텐츠들을 만들고 있습니다.

🎬   YouTube 얄팍한 코딩사전 채널 (클릭!)
📕  얄코의 책들 보러가기 (클릭!)

Curriculum

All

23 lectures ∙ (4hr 26min)

Published: 
Last updated: 

Reviews

All

305 reviews

4.8

305 reviews

  • sskim님의 프로필 이미지
    sskim

    Reviews 15

    Average Rating 5.0

    5

    70% enrolled

    이해하기 쉽게 하나하나 풀어서 설명해주셔서 너무 좋습니다.

    • 얄팍한 코딩사전
      Instructor

      감사합니다!!!

  • hhhjjjsss님의 프로필 이미지
    hhhjjjsss

    Reviews 4

    Average Rating 5.0

    5

    26% enrolled

    특히나 혼자 갖고노는시간(복습시간)이 제일 재밌네요 ㅎ 얄코님이 사이트에 잘 정리해주신 덕에 블록갖고놀듯이 놀아서 그런가봐요. Chapter1의 강의를 쭉 한번 듣고 혼자서 복습하면서 나중에 이렇게써볼까? 저렇게 써볼까 생각하면서 하니까 재밌어요. 혹시 이걸 다 외워야할까요? 지금은 재밌게하는데 실제 실무에서 사용할때는 까먹을까봐 불안해요.. 아님 당장이라도 내일 까먹어버릴까봐.. 실전에서 사용하실때 팁이 있을지 궁금합니다.

    • 답이 너무 늦었네요 ㅠㅠ 머리속에 다 넣어놓을 필요는 없습니다. 이러이러한 기능들이 있다는 것만 이해해두신 뒤 이후 데이터베이스를 다룰 일이 있을 때 다시 쭉 훑어보시면 돼요~!!

  • 홍익인간님의 프로필 이미지
    홍익인간

    Reviews 2

    Average Rating 5.0

    5

    74% enrolled

    묻지도 따지지도 않고 그냥 좋습니다. 최곱니다~

  • 김제하님의 프로필 이미지
    김제하

    Reviews 15

    Average Rating 4.9

    5

    96% enrolled

    인프런 강의와 함께 얄코님 사이트로 실습 링크와 예시 코드 그리고, 정리된 쿼리 명령문을 볼 수 있어서 너무 좋았습니다. 다른 분들도 이렇게 해주신다면 학습자의 입장에서 훨씬 효율적으로 학습할 수 있겠다고 항상 느낍니다. 유료 강의로 더 다양하게 앞으로 제공되기를 바랍니다.

    • Top님의 프로필 이미지
      Top

      Reviews 37

      Average Rating 4.8

      5

      96% enrolled

      자료나 실습환경 모두 수강생이 편하게 접근할 수 있도록 구성되어있고 강의 시간이 짧아 보여도 내용이 굉장히 많고 알차네요. 살짝 아쉬운 점이 있다면 ERD가 간단하게라도 제공되면 좋을 것 같아요. 그럼 처음 접하시는 분들이 관계형 데이터베이스를 이해하는데 조금 더 도움이 될 것 같아요. 감사합니다. :)

      $15.40

      yalco's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!