
실무에 바로 쓰자! 이커머스 데이터로 배우는 실전 SQL 분석
longvacation
대량의 이커머스 데이터를 SQL을 활용해 분석하고 싶은 MD, 마케터 이커머스 데이터 흐름을 보고 싶어하는 개발 직무 지원자(신입 또는 주니어)에 적합한 강의입니다.
초급
SQL
We will directly extract indicators frequently used in marketing/planning/CRM using SQL.
SQL Basic Grammar
Indicators and SQL frequently extracted from the field
SQL, an essential skill for data analysis!
Learn from the basics step by step through examples.
[Real Data Analyst JD Example]
Data Analyst JD (Job Description)
SQL is always required.
If you can't use SQL
Unable to start data analysis.
[Data extraction using real-world examples]
In this class, we will learn how to use SQL in marketing/CRM/planning, etc.
Learn SQL by directly extracting frequently used indicators.
(repurchase rate, monthly sales, number of buyers, etc.)
The exercise contains several tables.
Use the sample database.
Because you work in the same environment as the actual work,
I am sure it will be of direct help to you.
[Automobile Sales Company DB (including customer information, transaction information, product information, etc.)]
Who is this course right for?
For those who are new to SQL
Planning/marketing staff who need to extract indicators
For those who want to start a career as a data analyst
All
14 lectures ∙ (1hr 27min)
13. Ranking
06:28
14. Subquery
04:44
All
12 reviews
5.0
12 reviews
Reviews 2
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 5.0
$11.00
Explore other courses in the same field!