
P2P Communication Using WebRTC That No One Tells You About
July
You can learn about implementing webcam and peer-to-peer communication using WebRTC.
Beginner
Go, webrtc, p2p
We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.
448 learners
Level Basic
Course period Unlimited


Reviews from Early Learners
5.0
์ ์พํ ์บฅ๊ฑฐ๋ฃจ
I think this is a good lecture that focuses on the parts that you need to be careful about when writing queries rather than the basic concepts. I think that in this lecture, you can learn a lot about performance improvement and tuning improvement rather than learning about queries. In fact, I think that queries can be developed through ChatGPT in general, so I was more satisfied with this lecture that focused on theories.
5.0
gy.lyu
I think it will be a great help in my work.
5.0
๋ฉ๋จธ
Before listening to the lecture, it would be better to study the concepts once with the keywords in the lecture table of contents. Rather than a detailed lecture on the concepts, this lecture focuses more on the parts that need more attention when writing queries and the advice from the instructor's experience.
Things to be aware of when using MySQL
Writing queries in MySQL
Various constraints in MySQL
Locks in MySQL
In my recent work, I migrated 20 billion records of data from MongoDB to MySQL, which resulted in cost savings and normalization.
To cut to the chase, there's no right answer. I don't know if I'm doing it right or if it could be further optimized.
However, we deployed the service normally and without interruption, and I would like to share with you the areas we considered and paid attention to for optimization during this process.
Through this lecture, I hope you will learn about the charm of DB and the concerns of backend developers .
๐ The topic is 100% based on my own experience.
๐ It includes things I would like to share in addition to what I experienced.
๐ I will look into any parts where my personal explanation is lacking and let you know.
๐ I will tell you about my actual practical experience.

backend developer
DB: Can't you just write a query?

DB Engineer
I want to share and inform you about these things.

job seekers
I need to prepare for a job as a developer, and I'm curious about RDB.
Multi-Column Index [Composite Index]
Explain Query [Query Analysis]
Covering Index [Index Optimization]
RDB vs. ElasticSearch [Index and Inverted Index]
ORDER BY [Sort Optimization]
INSERT [Insert Optimization]
AUTO_INCREMENT LOCK [ AUTO_INCREMENT Lock ]
Index Dive [Query Planning Optimization]
Prefix Index [Index Lightening]
MySQL Lock [ MySQL Integrity and Concurrency ]
DeadLock [Understanding DeadLock through Case Analysis]
No OFFSET [Query Tuning]
Skip Locked [ Session Management ]
I have diverse experiences from startups to metaverse and platform service development. Recently, I migrated a service that handled 20 billion MongoDB data to MySQL, and now I am a platform server developer that handles 20 billion MySQL data.
This lecture will be based on MacOS. MySQL Workbench will be used, so please install it.
This course primarily focuses on MySQL.
But none of the companies I've experienced use a single DB.
Of course, in the case of a startup, it is configured with one DB.
We select and utilize various DBs according to the situation, legacy, and environment.
So I think MySQL alone may not be enough.
If you are curious about MongoDB, a leading NoSQL platform, the lecture below will be of great help.
How to build a data pipeline with over 20 billion records using MongoDB
This lecture mainly covers practical queries.
Who is this course right for?
For those who are new to DB
For those who are curious about large-scale data design
For those who are curious about the basic concepts of MySQL
3,871
Learners
196
Reviews
88
Answers
4.4
Rating
15
Courses
Introduction
As a non-major, I am currently working as a platform server developer in Pangyo.
I enjoy server optimization and various query tuning, and I strive to explain simple features to you in a quick and easy-to-understand manner.
Experience
[Former] Sandbox Blockchain Developer
[Former] Backend Developer at a Nexon subsidiary
[Former] Platform Server Developer at a major tech company in Pangyo
[Current] Server Developer at a Pangyo-based parent company
All
13 lectures โ (2hr 6min)
All
31 reviews
4.2
31 reviews
Reviews 7
โ
Average Rating 5.0
5
Thank you for the great lecture. It was filled with great content that is useful in practice, such as things to pay attention to when writing queries rather than basic concepts, and things to pay attention to in order to improve performance, so I felt that my thinking has broadened.
The lecture itself focused on writing queries in MySQL. As the data increases, there are many cases where this part is overlooked and problems cannot be solved. ใ ใ I hope that my lecture will help you feel more interested in DB and learn more. Thank you!
Reviews 14
โ
Average Rating 4.9
5
I think this is a good lecture that focuses on the parts that you need to be careful about when writing queries rather than the basic concepts. I think that in this lecture, you can learn a lot about performance improvement and tuning improvement rather than learning about queries. In fact, I think that queries can be developed through ChatGPT in general, so I was more satisfied with this lecture that focused on theories.
Many people use MySQL and I wanted to share the way I dealt with it. As you left, I think AI is actually more accurate than me when it comes to queries. ใ ใ So I covered the theory and optimization part rather than queries. Thank you for your good review.๐
Reviews 27
โ
Average Rating 5.0
5
Before listening to the lecture, it would be better to study the concepts once with the keywords in the lecture table of contents. Rather than a detailed lecture on the concepts, this lecture focuses more on the parts that need more attention when writing queries and the advice from the instructor's experience.
Thank you for the good course review. This lecture is something I have personally experienced and applied in my work. I personally do not like theory because the developer's role is to implement it. So I just wanted to show you how I experienced it and implemented it!! I hope it was helpful. Thank you!!
Reviews 4
โ
Average Rating 3.3
2
Personally, I had high expectations after seeing the table of contents, but the definitions were explained verbally and only lightly passed through the DB client. It may be a difference in style because it is a personal matter, but I wondered if it would have been better if the theory part had been prepared in PPT and explained, and then the prepared queries had been tested on the client. The font size was small, so I thought long queries or commands would have been used, but that was not the case. It was a lecture that left me with many regrets. I enjoyed the lecture. Thank you.
I think there were some parts that were disappointing because the nature of my lectures is that I focus on delivering the theoretical parts orally rather than preparing them in PPT and working on the code myself. ใ ใ I will try to be more careful in the future and provide a better environment to listen to the lectures. Thank you for leaving a good review!!
Check out other courses by the instructor!
Explore other courses in the same field!