inflearn logo
강의

Course

Instructor
inflearn logo
Data Science

/

Data Analysis

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.

(5.0) 2 reviews

143 learners

Level Basic

Course period Unlimited

SQL
SQL
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

484

Learners

48

Reviews

63

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
Published: 
Last updated: 

Reviews

All

2 reviews

5.0

2 reviews

  • mdunnie님의 프로필 이미지
    mdunnie

    Reviews 1

    ∙

    Average Rating 5.0

    5

    19% enrolled

    Thank you so, so much for providing such quick feedback on my questions.

    • freezboi님의 프로필 이미지
      freezboi

      Reviews 4

      ∙

      Average Rating 5.0

      5

      64% enrolled

      It's nice to listen to it lightly without any burden. Thank you.

      longvacation's other courses

      Check out other courses by the instructor!

      Utilizing ChatGPT 100% in Practical WorkCourse Thumbnail

      Utilizing ChatGPT 100% in Practical Work

      longvacation

      $38.50

      Beginner / ChatGPT, Python, Web Crawling, Selenium

      4.4

      (25)

      100+

      No fluff, just the "core" of ChatGPT's 100% utilization. Utilize it well, and your MD, marketing tasks will be 10x faster.

      Beginner

      Beginner

      ChatGPT, Python, Web Crawling

      Utilizing ChatGPT 100% in Practical WorkCourse Thumbnail

      Utilizing ChatGPT 100% in Practical Work

      longvacation

      $38.50

      Beginner / ChatGPT, Python, Web Crawling, Selenium

      4.4

      (25)

      100+
      [Resume Editing] Backend Web Development New Employment Know-How from an 8-Year E-Commerce DeveloperCourse Thumbnail

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

      longvacation

      $34.10

      Beginner / Tech Interview, Interview

      4.8

      (21)

      100+

      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.

      Beginner

      Beginner

      Tech Interview, Interview

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

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

      longvacation

      $34.10

      Beginner / Tech Interview, Interview

      4.8

      (21)

      100+

      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

      [Zero To SQL] The Easiest SQL Course for Immediate Use Even by Non-Majors | Planners/Marketers/Sales/Data

      WON

      $38.50

      22%

      $29.70

      Beginner / SQL, Big Data, Coding Test

      4.3

      (4)

      In an era where you need to handle data even if you don't know coding, a real SQL course for non-majors

      Beginner

      Beginner

      SQL, Big Data, Coding Test

      [Zero To SQL] The Easiest SQL Course for Immediate Use Even by Non-Majors | Planners/Marketers/Sales/DataCourse Thumbnail

      [Zero To SQL] The Easiest SQL Course for Immediate Use Even by Non-Majors | Planners/Marketers/Sales/Data

      WON

      $38.50

      22%

      $29.70

      Beginner / SQL, Big Data, Coding Test

      4.3

      (4)

      E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio PracticeCourse Thumbnail

      E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice

      coddatg

      $26.40

      Basic / SQL, data-visualization, looker-studio, bigquery, Data literacy

      4.7

      (11)

      100+

      Learn SQL not through listing grammar like SELECT and WHERE, but by solving business questions like "What are recent sales?", "Who buys more?", and "What are the Top 5 products?". Practice hands-on in a free environment (BigQuery Sandbox + Looker Studio) and complete analysis results with dashboards. You can gain practical data analysis thinking along with SQL fundamentals without getting bored.

      Basic

      Basic

      SQL, data-visualization, looker-studio

      E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio PracticeCourse Thumbnail

      E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice

      coddatg

      $26.40

      Basic / SQL, data-visualization, looker-studio, bigquery, Data literacy

      4.7

      (11)

      100+
      [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail

      [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-Major

      algolearn

      $61.60

      10%

      $55.00

      Beginner / SQL, Big Data, Data Engineering, SQLD, Coding Test

      4.8

      (48)

      300+
      Update
      Update
      Active Replies
      Active Replies

      SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

      Beginner

      Beginner

      SQL, Big Data, Data Engineering

      [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail

      [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-Major

      algolearn

      $61.60

      10%

      $55.00

      Beginner / SQL, Big Data, Data Engineering, SQLD, Coding Test

      4.8

      (48)

      300+
      Update
      Update
      Active Replies
      Active Replies
      [Soft Data] Learning Basic SQL with ExamplesCourse Thumbnail

      [Soft Data] Learning Basic SQL with Examples

      sof

      $11.00

      Beginner / SQL

      5.0

      (12)

      100+

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

      Beginner

      Beginner

      SQL

      [Soft Data] Learning Basic SQL with ExamplesCourse Thumbnail

      [Soft Data] Learning Basic SQL with Examples

      sof

      $11.00

      Beginner / SQL

      5.0

      (12)

      100+
      SQL data analysis learned through various casesCourse Thumbnail

      SQL data analysis learned through various cases

      dooleyz3525

      $68.20

      Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

      4.9

      (53)

      1,600+

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

      Intermediate

      Intermediate

      SQL, PostgreSQL, DBMS/RDBMS

      SQL data analysis learned through various casesCourse Thumbnail

      SQL data analysis learned through various cases

      dooleyz3525

      $68.20

      Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

      4.9

      (53)

      1,600+
      Do it! Introduction to SQL with Oracle - Taught by the AuthorCourse Thumbnail

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

      groovysunday

      $149.60

      Beginner / SQL, Oracle, DBMS/RDBMS, database, data-analysis

      4.3

      (6)

      Based on Oracle 21C, from concepts to practice, the easiest way to learn SQL for beginners! Taught directly by the author of Easyspub's "Do it! Introduction to SQL with Oracle"! Designed for non-majors and beginners, explained step by step.

      Beginner

      Beginner

      SQL, Oracle, DBMS/RDBMS

      Do it! Introduction to SQL with Oracle - Taught by the AuthorCourse Thumbnail

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

      groovysunday

      $149.60

      Beginner / SQL, Oracle, DBMS/RDBMS, database, data-analysis

      4.3

      (6)

      Data Analysis SQL FundamentalsCourse Thumbnail

      Data Analysis SQL Fundamentals

      dooleyz3525

      $42.90

      Basic / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering

      5.0

      (163)

      2,600+

      Through detailed lectures and hands-on practice on the core elements of SQL, we will provide you with a solid foundation to grow into a SQL analysis expert.

      Basic

      Basic

      SQL, PostgreSQL, DBMS/RDBMS

      Data Analysis SQL FundamentalsCourse Thumbnail

      Data Analysis SQL Fundamentals

      dooleyz3525

      $42.90

      Basic / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering

      5.0

      (163)

      2,600+
      [2026] Yellow Book 176 Practice Problems for Those Who Find SQLD Questions DifficultCourse Thumbnail

      [2026] Yellow Book 176 Practice Problems for Those Who Find SQLD Questions Difficult

      algolearn

      $30.80

      Basic / SQL, Big Data, Oracle, MSSQL, SQLD

      4.4

      (20)

      100+
      Active Replies
      Active Replies

      SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

      Basic

      Basic

      SQL, Big Data, Oracle

      [2026] Yellow Book 176 Practice Problems for Those Who Find SQLD Questions DifficultCourse Thumbnail

      [2026] Yellow Book 176 Practice Problems for Those Who Find SQLD Questions Difficult

      algolearn

      $30.80

      Basic / SQL, Big Data, Oracle, MSSQL, SQLD

      4.4

      (20)

      100+
      Active Replies
      Active Replies
      Hands-on SQLD Practice (Subject 2)Course Thumbnail

      Hands-on SQLD Practice (Subject 2)

      coddatg

      $38.50

      Basic / SQL, Oracle, MSSQL, SQLD

      4.8

      (79)

      700+

      For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

      Basic

      Basic

      SQL, Oracle, MSSQL

      Hands-on SQLD Practice (Subject 2)Course Thumbnail

      Hands-on SQLD Practice (Subject 2)

      coddatg

      $38.50

      Basic / SQL, Oracle, MSSQL, SQLD

      4.8

      (79)

      700+
      SQLD Certification Preparation CourseCourse Thumbnail

      SQLD Certification Preparation Course

      SoYoung Yoon

      $68.20

      Beginner / SQL, SQLD

      4.5

      (8)

      This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

      Beginner

      Beginner

      SQL, SQLD

      SQLD Certification Preparation CourseCourse Thumbnail

      SQLD Certification Preparation Course

      SoYoung Yoon

      $68.20

      Beginner / SQL, SQLD

      4.5

      (8)

      Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]Course Thumbnail

      Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]

      leejm99987374

      $29.70

      Basic / SQL, Oracle, subquery, database-modeling, sql-join

      Update
      Update

      "SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!

      Basic

      Basic

      SQL, Oracle, subquery

      Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]Course Thumbnail

      Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]

      leejm99987374

      $29.70

      Basic / SQL, Oracle, subquery, database-modeling, sql-join

      Update
      Update
      Fashion Retail AnalysisCourse Thumbnail

      Fashion Retail Analysis

      pnuswedu

      Free

      Beginner / scm, SQL, Google Analytics, TEXTOM, Text Mining

      5.0

      (4)

      200+

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

      Beginner

      Beginner

      scm, SQL, Google Analytics

      Fashion Retail AnalysisCourse Thumbnail

      Fashion Retail Analysis

      pnuswedu

      Free

      Beginner / scm, SQL, Google Analytics, TEXTOM, Text Mining

      5.0

      (4)

      200+

      25% off for new members

      $28.50

      25%

      $38.50