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,948 learners
Level Beginner
Course period Unlimited
Reviews from Early Learners
5.0
홍익인간
No questions asked, just good. It's the best~
5.0
hhhjjjsss
Especially, the time I play with it alone (review time) is the most fun. ㅎ I think it's because I play with it like playing with blocks thanks to Yalko-nim's well-organized site. It's fun to listen to the lecture of Chapter 1 all at once and review it alone, thinking about how I should write it later and how I should write it. Do I have to memorize all of this? I'm having fun now, but I'm worried that I'll forget it when I actually use it in practice.. Or maybe I'll forget it tomorrow.. I wonder if there are any tips for using it in practice.
5.0
neuri
First of all, instructor. Thank you for making such a great lecture! SQL was always a bit overwhelming, but I think I've mastered the basics through this opportunity! And it was so much fun to apply SQL while creating an actual application! The design of the example site was also pretty, so I think it was even more enjoyable. Thank you again. I'll take other lectures as well :)
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 🌠
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 .
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.
🚀 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 .
🌱 Free Part (Sections 0-3) | 💰 Paid Part (Sections 4-5)
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!)
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 .
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
34,140
Learners
1,951
Reviews
96
Answers
4.9
Rating
17
Courses
I am the YouTuber behind the channel Yal-co's Coding Dictionary, as well as an author of IT books. Drawing on my experience as a full-stack developer, I create content that explains difficult programming concepts through metaphors, simple examples, and sometimes animations to make them easy for beginners to understand.
🎬 YouTube Yal-co's Coding Dictionary Channel (Click!)
📕 View Yal-co's Books (Click!)
All
23 lectures ∙ (4hr 26min)
All
324 reviews
4.8
324 reviews
Reviews 8
∙
Average Rating 5.0
5
First of all, instructor. Thank you for making such a great lecture! SQL was always a bit overwhelming, but I think I've mastered the basics through this opportunity! And it was so much fun to apply SQL while creating an actual application! The design of the example site was also pretty, so I think it was even more enjoyable. Thank you again. I'll take other lectures as well :)
Reviews 2
∙
Average Rating 5.0
Reviews 15
∙
Average Rating 4.9
5
It was great to be able to see practice links, example codes, and organized query statements on Yalko's site along with the Inflearn lecture. I always feel that if other people do this, it would be much more efficient for learners to learn. I hope that more diverse paid lectures will be provided in the future.
Reviews 4
∙
Average Rating 5.0
5
Especially, the time I play with it alone (review time) is the most fun. ㅎ I think it's because I play with it like playing with blocks thanks to Yalko-nim's well-organized site. It's fun to listen to the lecture of Chapter 1 all at once and review it alone, thinking about how I should write it later and how I should write it. Do I have to memorize all of this? I'm having fun now, but I'm worried that I'll forget it when I actually use it in practice.. Or maybe I'll forget it tomorrow.. I wonder if there are any tips for using it in practice.
The answer is too late ㅠㅠ You don't need to remember everything in your head. Just understand that there are these functions, and then when you deal with a database in the future, you can look through it again~!!
Reviews 37
∙
Average Rating 4.8
5
Both the materials and the practice environment are organized so that students can easily access them, and although the lecture time seems short, the content is very rich and informative. If there is one thing that is a bit disappointing, it would be good if ERD was provided even in a simple way. I think that would be a little more helpful for beginners to understand relational databases. Thank you. :)
Check out other courses by the instructor!
Explore other courses in the same field!
Limited time deal ends in 05:41:04
$13,090.00
30%
$15.40
![Project Structure and Database Handling for Backend Employment [MySQL, Mongo]Course Thumbnail](https://cdn.inflearn.com/public/courses/332866/cover/002e90d9-1412-4a10-a9c6-39aa22d99671/332866.png?w=420)
![[MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?w=420)
![[Concept Class] SQL Queries You Can Learn and Use ImmediatelyCourse Thumbnail](https://cdn.inflearn.com/public/courses/325313/cover/d0ae99dd-3012-4a2e-a1cd-b7c459a75238/325313-eng-2.png?w=420)
![The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/337578/cover/01jwt82r7jn3c9mzybfn00mdnh?w=420)
![[A hundred words are not as good as seeing once] Basic SQL for data analysisCourse Thumbnail](https://cdn.inflearn.com/public/courses/324566/cover/aa1fac55-6e80-4506-9c92-f32c2b65f93a/sql_basic.png?w=420)
.png?w=420)