강의

멘토링

로드맵

Programming

/

Back-end

Location Finding with MySQL Geospatial Query and Image Caching with AWS

We will inform you about the platform mass adoption method using AWS (S3, CloudFront) and MySQL (Geospatial Query).

(5.0) 3 reviews

65 learners

  • July
3시간 만에 완강할 수 있는 강의 ⏰
실습 중심
MySQL
s3
cloudfront
Go

Reviews from Early Learners

What you will learn!

  • Image caching using CloudFront

  • Location exploration using geospatial queries

  • MySQL Insert Optimize

  • Image transmission via Edge Location

  • Static data management using S3

How are location-based data managed by dating apps, Baedal Minjok, Yogiyo, etc.? 🤔

Have you ever wondered about developing an app server using more specialized queries than the standard SQL or SubQuery?

To implement the requirements of many of these major apps, you need to use Geospatial Query .

In this course, you will learn about location-based data using Go , MySQL , S3 , and CloudFront , and additionally, image caching to improve user experience.

You will learn how to manage static objects in depth by allowing access to CloudFront using policy management in S3.

If you want to write specialized queries and manage static data, rather than general servers, this course is a must-take and will be of great help.

Features of this course

📌 You can learn about Geospatial Query used in major apps .

📌 It provides insights that are very helpful when applied in practice, such as schema design and caching methodologies .

📌 10% theory, 90% practice . All code is tested and verified to work as expected.

📌 Learn how to manage static data with AWS S3 .

📌 Learn how to leverage Edge Location for mass adoption at your location .

The core topics of the lecture are as follows: 🤔

How does location-based navigation work on major platforms? 🤔

You can learn about location-based navigation functions used in various major apps or platforms.

Let's learn together how to use Geospatial Query using MySQL!

How do you cache static data? 🤔

Have you ever tried simply using static image data??

Accessing and utilizing actual static data is risky and inefficient.

In this lecture, we will learn about CDN, Edge Location , how to process caching, and implement it using AWS !

I recommend this to these people 😆

I want to level up in backend development. I can do bulletin board CRUD, but I'm a backend developer/student who doesn't know what to do next.

I'm interested in space services.
How do delivery apps show you stores near your home? Curious about how to search for a place?

I'm curious about the development process.
For those curious about how developers at large companies conduct development,

What can I learn?? 😆

Your time is valuable. By taking my course, you can focus on these areas.

  • You can get familiar with location search using MySQL location-based queries.

  • It will help you understand what to consider from your position and help you advance your career.

  • You can use S3 to manage static image data.

  • It's very natural to learn how developers at large companies work and how they structure the server skeleton.

Learn this stuff. 😆

[1] Spatial Convenience Functions

In this lecture, you will learn how to handle distance data in a DB and practice implementing and applying an API server that uses latitude and longitude data on an actual map to perform distance search .

[2] AWS Object Control S3

How do we manage image files, such as static objects? In this lecture, you can practice how to manage images based on the user's name value.


The practice will actually involve creating a bucket in S3 and uploading an image directly using code and the console .

[3] AWS CloudFront for Image Cache

What's one of the most important factors for a platform? It's delivering content to users through fast response times.


In this lecture, you will learn how to use CloudFront to cache images in S3 and quickly display image files in the UI.

[4] Using Uber Fx For Dependency Injection

Are you familiar with Uber? In this lecture, you'll learn how to inject dependencies into your project using Uber's fx open source.

Who created this course 😆

  • I've compiled my resume!! Please check my profile.

Things to note before taking the class 😆

Practice environment

  • This lecture is based on MacOS, but it's also suitable for Windows machines.

  • This course is primarily written in Golang. However, since it covers raw query writing, you can take the course in other languages as well.


Recommended for
these people

Who is this course right for?

  • Anyone who wants to improve user experience through image caching

  • Anyone who wants to utilize Geospatial Query used in major apps

  • For those of you who are curious about how large enterprise server developers manage images

  • For those who are curious about the technologies used in platform development in practice

  • For those interested in flexible and scalable development

  • Anyone who wants to utilize various AWS services

Need to know before starting?

  • Go [ This is the default language. You can use any language you like. ]

  • MySQL [It's good to know, but it's okay if you don't know.]

  • AWS Account

Hello
This is

3,586

Learners

169

Reviews

88

Answers

4.5

Rating

15

Courses

자기 소개

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

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

 

경력

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

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

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

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

Curriculum

All

30 lectures ∙ (3hr 17min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

5.0

3 reviews

  • Kkyle님의 프로필 이미지
    Kkyle

    Reviews 6

    Average Rating 5.0

    5

    96% enrolled

    선생님 강의를 수강하면서 견해를 넓히고 이를 기반으로 네이버에 최근에 취업한 뉴비입니다.. ㅎㅎ 다른강의에서도 많은 도움을 받아서, 이 강의도 도움이 될 까 싶어서 수강하게 되었습니다. 결과적으로 많은 도움이 되었습니다. CloudFront를 통한 CDN이라는 주제가 굉장히 낯설었고, 해당 강의를 수강한 후에 회사에서도 적용을 문의 드렸는데 이미 적용중이라고 하시더라구요 ㅎㅎ;; 실제 실무자가 아니면 알 수 없는 좋은 주제의 강의라고 생각을 합니다. 항상 감사드리며, 이후 업데이트 될 Lambda에 대해서도 기대하고 있겠습니다. 감사합니다!!

    • July
      Instructor

      요즘 네이버에서 신입도 채용을 하나보네요 ㅎㅎ 축하드립니다!! 좋은 기회로 시작하게 되셨네요! 좋은 수강평 감사드리며 람다에 대한 부분도 준비해서 새소식으로 찾아뵙겠습니다!

  • 멀머님의 프로필 이미지
    멀머

    Reviews 27

    Average Rating 5.0

    5

    80% enrolled

    geospatial Query, aws s3, lambda, cloudfront 의 기초를 배울 수 있는 강의. 개념적인 내용보다는 실제로 코드를 작성하며 구현하는 모습을 보여주는 강의입니다. 강사님 강의를 계속 듣다보니 golang 에도 조금씩 익숙해 지는것 같아서 관심이 가네요. golang 학습하면서 강의를 다시한번 따라 가며 복습하겠습니다.

    • July
      Instructor

      저는 이론보다는 실습이 훨씬 중요하다고 생각합니다!! 실습을 통해 구현을 하면 이게 어떻게 동작하는지 이해가 더 쉽기 때문이죠!! 이 강의가 많은 도움이 되셨기를 바라겠습니다. 감사합니다 :)

  • kas kim님의 프로필 이미지
    kas kim

    Reviews 4

    Average Rating 5.0

    5

    32% enrolled

    쉽게 보기 힘든 주제의 강의, 플랫폼 개발에 있어서 이런 고려사항도 있다는것을 알게 됨

    • July
      Instructor

      안녕하세요. 실제 플랫폼을 개발하는데에 있어서 필요한 부분을 주제로 다루어보았는데 좋게 봐주셔서 감사합니다. 앞으로도 재미있는 개발 하시길 바랍니다. 감사합니다!!

$34.10

July's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!