Indicators and SQL frequently extracted from the field
SQL, an essential skill for data analysis! Learn from the basics step by step through examples.
Lecture Introduction
Data Analyst JD
[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.)]
another!
A PDF summarizing the SQL and Python preprocessing process We provide it for free.
Recommended for these people
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
I was able to get a feel for SQL in a short period of time at a low price. However, it is difficult to apply it by just listening to this lecture, and I think I need to practice a lot myself. Thank you, instructor.