Properly Selling Git & GitHub - by Yalco
yalco
A friendly and easy course that even coding beginners can follow! The ultimate course that turns working developers into Git experts!
입문
Git, GitHub
BEST
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.
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 📚
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
30,480
Learners
1,567
Reviews
86
Answers
4.9
Rating
17
Courses
유튜브 채널 얄팍한 코딩사전을 방송하는 유튜버이자, IT서적들을 집필하는 작가입니다. 풀스택 개발자로 일해 온 경험을 살려, 어려운 프로그래밍 개념들을 초보자들이 이해하기 쉽도록 비유와 쉬운 예제, 때로는 애니메이션으로 설명하는 컨텐츠들을 만들고 있습니다.
🎬 YouTube 얄팍한 코딩사전 채널 (클릭!)
📕 얄코의 책들 보러가기 (클릭!)
Curriculum
All
23 lectures ∙ (4hr 26min)
Published:
Last updated:
Reviews
All
304 reviews
4.8
304 reviews
imnewnew09180387Reviews 4
∙
Average Rating 5.0
5
26% enrolledEspecially, 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.
- yalcoInstructor
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~!!
- beingshift112380
Reviews 2
∙
Average Rating 5.0
- highnnnyes1734
Reviews 37
∙
Average Rating 4.8
5
96% enrolledBoth 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. :)
- neuri932678
Reviews 8
∙
Average Rating 5.0
5
100% enrolledFirst 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 :)
Limited time deal ends in 6 days
$12.10
21%
$15.40
yalco's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![Project Structure and Database Handling for Backend Employment [MySQL, Mongo]강의 썸네일](https://cdn.inflearn.com/public/courses/332866/cover/002e90d9-1412-4a10-a9c6-39aa22d99671/332866.png?f=avif&w=420)
![[Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market Analysis강의 썸네일](https://cdn.inflearn.com/public/courses/330079/cover/c142fdb2-b4fa-4b6a-9e8f-7bd48aed7635/fullstack-db-1.jpg?f=avif&w=420)
![[A Hundred Words are Not as Good as Seeing Once] SQL Practical Guide for Data Analysis (Free Mini Course)강의 썸네일](https://cdn.inflearn.com/public/courses/326716/cover/e4917b63-2f4e-4607-953a-b1cdf8bb1a67/326716-eng.png?f=avif&w=420)
![[MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
