
P2P Communication Using WebRTC That No One Tells You About
July
$36.30
Beginner / Go, webrtc, p2p, JavaScript, Socket.io
4.0
(10)
100+
You can learn about implementing webcam and peer-to-peer communication using WebRTC.
Beginner
Go, webrtc, p2p
We will inform you about all the security aspects of migration using MySQL and direct operation of DB Server.
141 learners
Level Basic
Course period Unlimited


Reviews from Early Learners
5.0
Roles
I think this is a lecture on concepts that are generally experienced and not directly used. I found it very informative, and I feel a little embarrassed that I only knew how to write general queries. Thank you for the great lecture :)
5.0
유쾌한 캥거루
Not only MySQL, but also for EC2 instances, it is a lecture that directly troubleshoots errors that occur in the part that you build yourself, and it was very helpful. Thank you for the great lecture.
5.0
keny
I also enjoyed the lecture on MySQL query tuning method that you recommended, and I found the lecture very informative. I will leave a few notes because I think it would be good for those who are interested in the lecture. 1. It contains the parts necessary for actual service operation. - This lecture really considers the initial model, from controlling external access to how to configure security. 2. The actual data provided is more helpful than expected. - It provides data that is very easy to test the concepts and methods provided by MySQL, and I think it is the best lecture for practicing development. I enjoyed the lecture. Thank you.
Migration of public data using MySQL
Handling MySQL Access Permissions Using EC2
Google Geocoding API
Security in MySQL
Have you ever built a real service from scratch? This course will teach you everything you need to know about what to consider and what to work on when building a real service.
In the companies you usually work for, you start with all of these environments already set up.
You may never have any questions or concerns, but as your career progresses and you move to different companies, this knowledge becomes essential and required.
Through this lecture, I hope you will learn what kind of environment you should configure in the early stages of a service.
This course will demonstrate how to migrate public data using MySQL, providing the corresponding code and data. Through this course, you'll learn how to optimize inserts in MySQL. Don't be limited by language! The code provided is fully scalable, making it easy to implement in other languages.
In this lecture, we will additionally build a server and install MySQL using AWS's EC2 .
If you dream of becoming a server developer, you need to know how to implement it yourself to optimize costs.
Rather than simply leveraging the services provided as a cluster, experience building an actual MySQL instance and the potential tradeoffs that arise. Through this process, you'll learn how to manage MySQL security and implement it yourself.
By leveraging AWS's cloud system and modifying sshd_config , you'll learn how to manage and control instance security. You'll also learn how to access instances using password-based authentication.
You can learn how to install MySQL on Amazon Linux using dnf and GPG debugging , extract passwords through mysqld.log , and use identified by .
To ensure security in MySQL, we'll configure external database control . This will allow you to learn how to control database access in real-world situations.
By providing Xlsx migration code and data using public data , you can directly work with MySQL. Additionally, you can learn about Insert Optimization and large-scale data processing methods.
This course covers running and controlling a real MySQL server. This includes using queries you wouldn't normally use, setting permissions, and verifying those permissions .
Since many unfamiliar queries may be used, we provide queries to avoid confusion in this area, so don't worry.
When developing a server, the most difficult part is where to get the actual data.
And I think one of the biggest problems is figuring out what kind of query to write.
I've also had similar experiences, and based on that experience, this lecture presents data I personally collected and processed. I also provide code for migrating these files.
Using this material to run an actual migration service and practice queries and process data will be of great help in your learning.
I paid for this course myself, and the migration was done using the Geocoding API.
It provides the code that the migration was performed on, as well as the resulting queries and data results.
Extracting additional data from specific locations is a costly process. I didn't want to suggest this course to my students. I hope they can simply focus on improving their skills using the data I provide.
The lecture was filmed in a MacOS M1 environment.
You can use any IDE you are comfortable with.
This lecture also covers databases using Goland.
This course covers a wide range of topics related to MySQL operation. If you're curious about queries related to service development, this course will be of great help.
This lecture provides actual public data files and migrated MySQL data.
Who is this course right for?
Anyone who wants to build a service using MySQL
Server developer who wants to handle security
For those of you wondering how to configure MySQL on EC2
For those who want to set access restrictions using MySQL User base
Need to know before starting?
Golang [You can use other languages too]
Curiosity about MySQL
Curiosity about building services
3,889
Learners
201
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
20 lectures ∙ (1hr 51min)
Course Materials:
All
10 reviews
4.3
10 reviews
Reviews 14
∙
Average Rating 4.9
Reviews 8
∙
Average Rating 5.0
5
I think this is a lecture on concepts that are generally experienced and not directly used. I found it very informative, and I feel a little embarrassed that I only knew how to write general queries. Thank you for the great lecture :)
Thank you for your kind words. Most of my lectures are about topics that you may not easily come across. I will come back with better lectures in the future :)
Reviews 19
∙
Average Rating 5.0
5
I also enjoyed the lecture on MySQL query tuning method that you recommended, and I found the lecture very informative. I will leave a few notes because I think it would be good for those who are interested in the lecture. 1. It contains the parts necessary for actual service operation. - This lecture really considers the initial model, from controlling external access to how to configure security. 2. The actual data provided is more helpful than expected. - It provides data that is very easy to test the concepts and methods provided by MySQL, and I think it is the best lecture for practicing development. I enjoyed the lecture. Thank you.
Thank you for your kind words. This is actually the method I use in my work or when working on side projects. I hope this method will be of great help to you.🫡
Reviews 2
∙
Average Rating 3.0
1
I am not satisfied with the quality of the lectures.
I'm sorry I couldn't provide you with a satisfactory lecture. Please tell me more about which parts you were not satisfied with. I will prepare to improve those parts. Thank you for leaving a review :)
Reviews 13
∙
Average Rating 5.0
Check out other courses by the instructor!
Explore other courses in the same field!
25% off for new members
$12.00
25%
$22.00