강의

멘토링

커뮤니티

Programming

/

Database

MySQL operation and migration applied to 100,000 traffic service operation

We will inform you about all the security aspects of migration using MySQL and direct operation of DB Server.

(4.5) 8 reviews

134 learners

  • July
공공데이터
실습 중심
MySQL
ec2
AWS
google-geocoding-api
sshd

Reviews from Early Learners

What you will gain after the course

  • Migration of public data using MySQL

  • Handling MySQL Access Permissions Using EC2

  • Google Geocoding API

  • Security in MySQL

This course covers everything you need to know about service development and deployment. 🤠

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 topic is covered in great detail. 🤠

Public data migration using MySQL

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.

Install and run MySQL on Amazon Linux 2023!

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.

Learn this stuff 🤠

1⃣ Setting up SSH access control on AWS EC2

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.

2⃣ Controlling MySQL on Amazon Linux

You can learn how to install MySQL on Amazon Linux using dnf and GPG debugging , extract passwords through mysqld.log , and use identified by .

3⃣ Controlling MySQL access from outside

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.

4⃣ Public Data Migration

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.

5⃣ Use a variety of queries.

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.

This course provides real public data. 🤠

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 migrated actual data. 🤠

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.

Things to note before taking the course

Practice environment

Learning Materials

  • This lecture provides actual public data files and migrated MySQL data.


Recommended for
these people

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

Hello
This is

3,689

Learners

174

Reviews

88

Answers

4.5

Rating

15

Courses

자기 소개

비전공자 출신으로 판교에서 플랫폼 서버 개발을 담당하여 진행하고 있습니다.

서버 최적화와 다양한 쿼리 튜닝을 좋아합니다.

 

경력

[前] 샌드박스 블록체인 개발자

[前] 넥슨 자회사 백엔드 개발자

[前] 판교 대기업 플랫폼 서버 개발자

[] 판교 모회사 서버 개발자

Curriculum

All

20 lectures ∙ (1hr 51min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

8 reviews

4.5

8 reviews

  • wnsghrnt25861521님의 프로필 이미지
    wnsghrnt25861521

    Reviews 13

    Average Rating 5.0

    5

    30% enrolled

    • 1302님의 프로필 이미지
      1302

      Reviews 7

      Average Rating 5.0

      5

      30% enrolled

      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 :)

      • july
        Instructor

        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 :)

    • jukas5985 [DEL] 250815201525님의 프로필 이미지
      jukas5985 [DEL] 250815201525

      Reviews 14

      Average Rating 4.9

      5

      30% enrolled

      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.

      • sdl1355126님의 프로필 이미지
        sdl1355126

        Reviews 14

        Average Rating 5.0

        5

        65% enrolled

        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.

        • july
          Instructor

          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.🫡

      • jjhgwx님의 프로필 이미지
        jjhgwx

        Reviews 609

        Average Rating 4.9

        5

        25% enrolled

        Thank you for the great lecture!

        $22.00

        July's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!