Utilizing ChatGPT 100% in Practical Work
longvacation
No fluff, just the "core" of ChatGPT's 100% utilization. Utilize it well, and your MD, marketing tasks will be 10x faster.
Beginner
ChatGPT, Python, Web Crawling
Put it into practice right away! Practical SQL analysis learned through e-commerce data
This course is suitable for MDs and marketers who want to analyze large amounts of e-commerce data using SQL, as well as job seekers (new or junior) in development roles who want to understand the flow of e-commerce data.
SQL
SQL
What you will gain after the course
SQL
Data Analysis
Querying and analyzing vast amounts of data in the database
From SQL utilization, data extraction, and analysis to visualization...
We will build your confidence in practical application!
SQL was learned, but...
Why is it so difficult when you actually try to do it?
Because you only learned grammar
and haven't worked with
real data!
Because you don't fully
understand the DB structure
actually used in practice!
Because you don't know how to
actually
utilize the output data!
👉 The reason SQL is difficult to use is, after all, because you haven't encountered a SQL course tailored to practical work yet.
For professionals who want to use SQL properly.
muốn sử dụng SQL một cách bài bản.
Do you want to use SQL "well"? There are many SQL courses out there, but it's not easy to actually apply SQL properly. This is because it's difficult to find a course that teaches using real-world business data.
This course is different from existing courses that only teach SQL syntax.
Instead, you will learn how to “solve problems through SQL.”
You will learn how to freely use SQL based on
actual e-commerce service data
ranging from products to discounts, orders, payments, and refunds.
You will understand the complex data flow of products, discounts, orders, payments, and refunds, and gain access to data that is likely to be used in practice. In addition, you will learn simple data visualization methods to create intuitive business reports and analysis materials yourself, enabling a higher level of data analysis.
Real SQL learning for practitioners! Of course, it will be even more helpful if you are in an e-commerce-related industry. We will help you develop the ability to identify “which data to extract with which query in what situation.” Let's take on the challenge together!
This will be especially helpful for these people 🙋♂️
Those who want to learn SQL or
are working in the
e-commerce industry
Those who want to analyze
actual service data
(MDs, Marketers, Planners)
Junior developers
who want to study
e-commerce DB structures
Those who want to try
SQL data visualization
using Python
Check out the learning content
📖học tập 📖
- ✅ We will teach you how to selectively check and analyze the data you need through SQL.
- ✅ You can directly perform data extraction, which previously required a request to the development team every time, by writing SQL yourself.
- ✅ We provide methods for data visualization using Python, based on data extracted from the DB through SQL.
- ✅ You can understand the data flow of core e-commerce data, such as products, discounts, orders, payments, and refunds.
Real-world examples that build practical skills
We will build a database and conduct hands-on practice by crawling actual product information from Coupang product pages.
So that you can utilize data "well"
You can learn useful analysis methods through SQL and Python visualization.
Get closer to SQL queries
The lectures focus on data commonly used in e-commerce practice, and we provide intensive instruction on how to write SQL queries required for various situations you may encounter at work.
Complex DB structures are also OK
You will be able to easily understand and analyze the database structures for e-commerce orders, payments, refunds, and discounts. This will help you in practical service operations where data flows are complex.
The
instructor of this course is 👨💻
longvacation
“I have infused the know-how of an e-commerce developer into this lecture.”
- Former Samsung Electronics S.LSI Division
- Former Lotte Department Store IT Team Backend Developer
- Former eBay Order/Payment Backend Developer
- Current developer at a major domestic e-commerce company
- Extensive experience conducting lectures for non-majors at Frip
Check out the Q&A! 💬
Q. Can I take this course even if I have no prior knowledge of SQL?
The curriculum is divided into sections, and in the first section, I will teach you how to write SQL code from a beginner's perspective. Rather than just explaining basic SQL, the course is designed to gradually introduce advanced SQL techniques as the sections progress, allowing you to learn and apply them naturally.
Q. I am working as an MD/Marketer in e-commerce. Specifically, what can I learn through this course?
You will be able to write SQL yourself without having to wait indefinitely for the development team or being told that data extraction and other requests are currently impossible.
Q. I am preparing for a job as a new developer. What can I learn from this?
You can learn specifically about database configurations that are difficult to learn in school or academy classes. It is especially helpful if you want to get a job at a service company with complex data structures and flows, such as e-commerce. This will directly lead to an increased understanding of the role and will be a useful lecture for interviews or career decisions.
Q. Is there any prior knowledge or preparation required for the class?
No prior knowledge is required. However, a personal PC is necessary as the lecture content and hands-on exercises require the installation of software (free).
Q. Since actual in-house e-commerce data would pose security issues, how do you plan to explain this?
The class will be conducted based on data constructed by crawling product information, selling prices, and discount details from product data displayed on the e-commerce platform Coupang.
💡 Please check before taking the course!
- The curriculum is composed of SQL learning and Python data analysis in a ratio of approximately 7:3.
- When watching the video, we recommend setting the quality to 1080p and the speed to 1.25x.
Recommended for
these people
Who is this course right for?
Someone new to coding
Someone who is curious about the data structure of e-commerce
Need to know before starting?
None
Hello
This is longvacation
479
Learners
48
Reviews
62
Answers
4.6
Rating
3
Courses
A developer who loves programming, traveling, and his wife.
Curriculum
All
29 lectures ∙ (4hr 7min)
Course Materials:
Lecture resources
1. Overview
06:19
Published:
Last updated:
longvacation's other courses
Check out other courses by the instructor!
![[Resume Editing] Backend Web Development New Employment Know-How from an 8-Year E-Commerce DeveloperCourse Thumbnail](https://cdn.inflearn.com/public/courses/328155/cover/e4884afc-5a35-46ed-b4e0-6d1cdc4b4c55/328155-eng.png?w=420)
Similar courses
Explore other courses in the same field!
![[Zero To SQL] The Easiest SQL Course for Immediate Use Even by Non-Majors | Planners/Marketers/Sales/DataCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/338120/cover/01k5phvgb21v638vyanc6stcym?w=420)
![[Soft Data] Learning Basic SQL with ExamplesCourse Thumbnail](https://cdn.inflearn.com/public/course-325916-cover/232a79c6-fc4a-4491-80c1-ffd0b33f0e87?w=420)
![[SQLD Past Exams are the Answer!] 59th Session (25.11.16) Latest Practice Exam Reconstruction - All Questions by Subject and ChapterCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/339593/cover/01kaa9g51rjvrbyxggffhv9tr7?w=420)
![[2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/336953/cover/01kfq68bzb04w1mydc92ysfads?w=420)