Data Science

Data Analysis

Let's put it into practice! Learn practical SQL analysis with e-commerce data

Name: Let's put it into practice! Learn practical SQL analysis with e-commerce data
Price: 49500 KRW

MDs and marketers who want to analyze large amounts of e-commerce data using SQL This course is suitable for developers (new or junior) who want to see the flow of e-commerce data.

(5.0) 1 reviews

134 learners

longvacation

SQL

What you will learn!

SQL
Data Analysis
Query and analyze massive amounts of data in the database

From SQL utilization to data extraction, analysis, and visualization...
We build your confidence in real-world situations!

I learned S QL, but...
Why is it so difficult when you actually try to do it?

_{Just learn grammar
Actual data
Because I haven't tried it!}

_{Actually used
DB structure well
Because I don't understand!}

_{The printed data
How is it actually?
I don't know if I'll use it !}

👉 The reason why it is difficult to use SQL is because, ultimately, I have not yet found a SQL lecture that is suitable for practical use .

I want to use SQL properly
For practitioners.

Do you want to learn SQL "well"? While there are plenty of SQL courses, actually utilizing SQL effectively can be challenging. It's hard to find courses that focus on practical data.

This course is different from the existing courses that only teach SQL grammar.
Instead, you will learn how to 'solve problems with SQL' .

From products to discounts, orders, payments, and refunds
Based on actual e-commerce service data
Learn how to use SQL fluently.

You'll understand the complex data flows of products, discounts, orders, payments, and refunds, and access data relevant to practical use . You'll also learn simple data visualization techniques to create intuitive business reports and analytics, enabling you to perform advanced data analysis.

Real SQL learning for practitioners! Of course, it'll be especially helpful for those in the e-commerce industry. We'll help you develop the ability to understand "what data to extract and with what query, under what circumstances." Let's tackle this challenge together!

This is especially helpful for these people 🙋‍♂️

_{If you want to learn SQL
In the e-commerce industry
People who are working}

_{Actual service data
Anyone who wants to analyze
(MD, marketer, planner)}

_{E-commerce DB structure
I want to study
Junior Developer}

_{With Python
SQL data visualization
Anyone who wants to try it}

Learning content
Check it out 📖

✅ We will teach you how to selectively check and analyze the necessary data through SQL.
✅ You can now directly extract data by writing SQL, which used to require a request to the development team every time.
✅ We provide a data visualization method using Python based on data extracted from a DB via SQL.
✅ You can understand the data flow of core e-commerce data such as products, discounts, orders, payments, and refunds.

Real examples that develop practical skills

We will build a database by crawling actual product information on Coupang product pages and proceed with practical training.

To make good use of data

You will learn useful analytical techniques through SQL and Python visualization.

Get closer to SQL queries

This course focuses on data likely to be used in e-commerce practice, and focuses on how to write SQL queries for various situations you might encounter at work.

Complex DB structures are also OK

You'll be able to easily understand and analyze the database structure of e-commerce orders, payments, refunds, and discounts. This will be helpful in practical service operations where data flows in a complex manner.

In this lecture
Knowledge sharer is 👨‍💻

longvacation

“ I incorporated the know-how of an e-commerce developer into the lecture. ”

Former Samsung Electronics S.LSI Business Division
Former backend developer at Lotte Department Store's IT team
Former eBay order payment backend developer
Current domestic e-commerce major company developer
Frip has a history of conducting lectures for non-majors.

Check out the Q&A! 💬

Q. Can I take the course even if I don't have any SQL-related knowledge?

The curriculum is divided into sections. The first section covers SQL code writing for beginners. Rather than simply covering introductory SQL, the course gradually moves into more advanced SQL writing, ensuring a natural flow of use.

Q. I work as an MD/marketer in e-commerce. What specifically will I learn from this course?

You'll be able to write SQL directly without having to wait long periods of time for your development team to deliver data extractions or other requests that may not be immediately possible.

Q. I'm preparing for a new developer position. What can I learn?

You can learn specifics about database structure, something difficult to learn in school or academy classes. This is especially helpful if you're seeking employment in a service company like e-commerce, where data structures and flows are complex. This course will naturally enhance your job understanding and be a valuable resource for interviews and job decisions.

Q. Is there any prior knowledge or preparation required for the class?

No prior knowledge is required. However, you will need a personal computer to install the free programs required for the lectures and practical exercises.

Q. How do you plan to explain the security concerns surrounding your company's actual e-commerce data?

This course is based on data collected by crawling product information, sales prices, and discount information from product data exposed on Coupang e-commerce platform.

💡 Please check before taking the class!

The ratio of learning SQL and learning Python data analysis is approximately 7:3 .
When watching the video, we recommend setting the video quality to 1080p and the speed to 1.25x .

Recommended for
these people

Who is this course right for?

For those new to coding
Anyone curious about the data composition of e-commerce

Need to know before starting?

doesn't exist

Hello
This is

456

Learners

Reviews

Answers

4.6

Rating

Courses

프로그래밍과 여행 그리고 아내를 사랑하는 개발자

Curriculum

All

25 lectures ∙ (3hr 43min)

Course Materials:

Lecture resources

Section 1. What you will learn in this course

1 lectures ∙ (6min)

1. Overview
06:19

Section 2. Building a database analysis environment

2 lectures ∙ (11min)

Section 3. SQL Analysis - Product Area

7 lectures ∙ (1hr 5min)

4. Creating a product table by crawling Coupang product information
11:38
5. View product table
08:08
6. Join(1) - Setting up data relationships
13:16
7. Join(2) - Multi-table join
12:13
8. group by(1) - count(quantity): View the number of products by category/supplier
07:15
9. group by(2) - avg(average) / sum(sum): Get the average and sum of sales prices by category
07:07
10. group by(3) - having: Writing useful conditions when using group by
06:10

Section 4. Data correlation analysis using ERD

1 lectures ∙ (12min)

Section 5. SQL Analysis - Discounts and Promotions Area

3 lectures ∙ (25min)

Section 6. SQL Analysis - Order Area

2 lectures ∙ (21min)

Section 7. SQL Analysis - Payment Area

5 lectures ∙ (34min)

Section 8. SQL Data Visualization

4 lectures ∙ (46min)

Published:

Last updated:

Reviews

All

1 reviews

5.0

1 reviews

freezboi4853
Reviews 4
∙
Average Rating 5.0
5
64% enrolled
It's nice to listen to it lightly without any burden. Thank you.

$38.50

longvacation's other courses

Check out other courses by the instructor!

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.

입문

ChatGPT, Python, Web Crawling

Utilizing ChatGPT 100% in Practical Work

longvacation

[Resume Editing] Backend Web Development New Employment Know-How from an 8-Year E-Commerce Developer

longvacation

Here are some tips for interviewing developers that you won't find on the internet. This is the essence of preparing for the web development hiring process.

입문

Tech Interview, Interview

[Resume Editing] Backend Web Development New Employment Know-How from an 8-Year E-Commerce Developer

longvacation

Similar courses

Explore other courses in the same field!

30 Minutes of SQL a Day for Beginners

alpaco

SQL is an indispensable tool in data analysis. What is it and why is it important? If you are a beginner, check it out here!

입문

SQL, MySQL

30 Minutes of SQL a Day for Beginners

alpaco

Intermediate-Advanced SQL and 101 Practical Data Analysis Problem Solutions

funcoding

Master advanced SQL, solve 101 practical data analysis problems at a professional level together, and build a solid SQL data analysis skillset.

초급

SQL, MySQL, DBMS/RDBMS

Intermediate-Advanced SQL and 101 Practical Data Analysis Problem Solutions

funcoding

First steps to SQL coding test

gemmadata

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

초급

Coding Test, SQL, MySQL

First steps to SQL coding test

gemmadata

Do it! Introduction to SQL with Oracle - Direct Instruction by the Author

groovysunday

Based on Oracle 21C, from concept to practice, the easiest way to learn SQL for the first time! Directly taught by the author of EGIS Publishing's 《Do it! SQL for Beginners with Oracle》! We'll teach non-majors and beginners step-by-step.

입문

SQL, Oracle, DBMS/RDBMS

Do it! Introduction to SQL with Oracle - Direct Instruction by the Author

groovysunday

[Soft Data] Learning Basic SQL with Examples

sof

We will directly extract indicators frequently used in marketing/planning/CRM using SQL.

입문

SQL

[Soft Data] Learning Basic SQL with Examples

sof

SQL data analysis learned through various cases

dooleyz3525

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

중급이상

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

Complete Mastery of Azure Data Fundamentals for Data Beginners

daniellee

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

입문

SQL, Big Data, Data Engineering

Complete Mastery of Azure Data Fundamentals for Data Beginners

daniellee

SQLD Certification Preparation Course

eduatoz

This course aims to acquire the state-authorized SQLD certification. SQLD refers to a developer who, based on database and data modeling knowledge, can write accurate SQL for manipulating and extracting data while developing application software.

입문

SQL, SQLD

SQLD Certification Preparation Course

eduatoz

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

masocampus

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

입문

SQL, SQLD

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

masocampus

Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

coddatg

For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

초급

SQL, Oracle, MSSQL

Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

coddatg

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot

datacodelab

SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

입문

SQLD, Big Data, Data Engineering

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot

datacodelab

Fashion Retail Analysis

pnuswedu

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!

입문

scm, SQL, Google Analytics

Fashion Retail Analysis

pnuswedu

Let's put it into practice! Learn practical SQL analysis with e-commerce data

What you will learn!

I learned S QL, but... Why is it so difficult when you actually try to do it?

I want to use SQL properly For practitioners.

This is especially helpful for these people 🙋‍♂️

Learning content Check it out 📖

In this lecture Knowledge sharer is 👨‍💻

longvacation

Check out the Q&A! 💬

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

longvacation's other courses

Similar courses

I learned S QL, but...
Why is it so difficult when you actually try to do it?

I want to use SQL properly
For practitioners.

Learning content
Check it out 📖

In this lecture
Knowledge sharer is 👨‍💻

Recommended for
these people

Hello
This is