강의

멘토링

로드맵

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

131 learners

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

Reviews from Early Learners

What you will learn!

  • 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,586

Learners

169

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

  • 심유석님의 프로필 이미지
    심유석

    Reviews 13

    Average Rating 5.0

    5

    30% enrolled

    • Roles님의 프로필 이미지
      Roles

      Reviews 7

      Average Rating 5.0

      5

      30% enrolled

      일반적으로 경험하고 직접 사용해보지 못하는 개념들에 대한 강의라고 생각합니다. 저는 굉장히 유익하였고, 일반적인 쿼리 작성만 할 줄 알았던 제가 조금 부끄러워지네요. 좋은 강의 감사합니다 :)

      • July
        Instructor

        좋게 봐주셔서 감사합니다. 제 강의의 대부분은 여러분들이 쉽게 접하지 못하는 주제로 준비하고자 노력하고 있습니다. 앞으로 더 좋은 강의로 찾아 뵙겠습니다 :)

    • 유쾌한 캥거루님의 프로필 이미지
      유쾌한 캥거루

      Reviews 14

      Average Rating 4.9

      5

      30% enrolled

      MySQL뿐만 아니라 EC2 인스턴스에 대해, 스스로 구축하는 부분에 발생하는 에러를 직접 트러블 슈팅 해주는 강의로 구성이 되어 있고 많은 도움이 되었습니다. 좋은 강의 감사합니다.

      • keny님의 프로필 이미지
        keny

        Reviews 13

        Average Rating 5.0

        5

        65% enrolled

        추천해주신 MySQL 쿼리 튜닝 방법에 대한 강의도 만족스럽게 잘 들었고, 해당 강의도 되게 유익하게 잘 들었습니다. 강의에 관심이 있으신 분들이 보시면 좋을듯 싶어서 몇가지 글을 남겨 두겠습니다. 1. 진짜 서비스 운영에 필요한 부분이 담겨 있습니다. - 외부 접속에 대한 제어부터 보안을 어떻게 구성하는지 정말 초기 모델에 대한 고려가 되어 있는 강의 입니다. 2. 실제 데이터 제공이 생각보다 유익합니다. - 기존 MySQL에서 제공해 주셨던 개념과 방식을 테스트하기에 굉장히 용이한 데이터를 제공해 주시고, 개발을 연습하기에는 최적의 강의가 아닐까 싶습니다. 강의 잘 들었습니다. 감사합니다.

        • July
          Instructor

          좋게 봐주셔서 감사합니다. 실제로 제가 실무에서 구축하거나 사이드 프로젝트를 진행하는데에 있어서 도입하는 방식입니다. 해당 방식이 많은 도움이 되시기를 바라겠습니다.🫡

      • Jang Jaehoon님의 프로필 이미지
        Jang Jaehoon

        Reviews 591

        Average Rating 4.9

        5

        25% enrolled

        좋은 강의 감사합니다!

        $22.00

        July's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!