강의

멘토링

커뮤니티

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

(4.5) 4 reviews

67 learners

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

Reviews from Early Learners

What you will gain after the course

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

Learners

174

Reviews

88

Answers

4.5

Rating

15

Courses

자기 소개

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

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

 

경력

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

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

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

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

Curriculum

All

30 lectures ∙ (3hr 17min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

4.5

4 reviews

  • yuhojin8037329님의 프로필 이미지
    yuhojin8037329

    Reviews 6

    Average Rating 5.0

    5

    96% enrolled

    I am a newbie who recently got a job at Naver after broadening my perspective while taking the teacher's lecture. ㅎㅎ I received a lot of help from other lectures, so I took this lecture because I thought it would be helpful. As a result, it was very helpful. The topic of CDN through CloudFront was very unfamiliar to me, and after taking the lecture, I asked my company about applying it, but they said they were already applying it ㅎㅎ;; I think it is a good lecture on a topic that only actual practitioners would know. I am always grateful, and I look forward to the future updates on Lambda. Thank you!!

    • july
      Instructor

      I see Naver is hiring new employees these days. Congratulations!! You've started off with a great opportunity! Thank you for your good review. I'll prepare a section on Lambda and come back with more news!

  • kkh023918234님의 프로필 이미지
    kkh023918234

    Reviews 27

    Average Rating 5.0

    5

    80% enrolled

    A lecture where you can learn the basics of geospatial query, aws s3, lambda, and cloudfront. This lecture shows you how to actually write code and implement it rather than just conceptual content. As I continue to listen to the lecture, I feel like I'm getting a little more familiar with golang, so I'm interested. I'll follow the lecture again and review it while learning golang.

    • july
      Instructor

      I think practice is much more important than theory!! It's easier to understand how it works if you implement it through practice!! I hope this lecture was helpful. Thank you :)

  • hojikas1237295님의 프로필 이미지
    hojikas1237295

    Reviews 4

    Average Rating 5.0

    5

    32% enrolled

    I learned that there are considerations like this in platform development, a lecture on a topic that is not easy to see.

    • july
      Instructor

      Hello. I've covered the necessary parts for developing an actual platform, so thank you for your kind words. I hope you continue to have fun developing. Thank you!!

  • hidongmin37님의 프로필 이미지
    hidongmin37

    Reviews 76

    Average Rating 4.8

    3

    60% enrolled

    $34.10

    July's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!