Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Elevate your SQL skills and gain a new perspective of how to maximize SQL.
The Most Addictive Python and SQL Courses
AI Adoption - Drive Business Value and Organizational Impact
Overview
Syllabus
Introduction
- SQL introduction
- What you should know
- Codespaces
- Introducing H+ Sport
- Understanding retail data
- How to add a new product
- How to order sales data
- How to find missing values
- How to remove missing values
- How to make a month column
- Challenge: Add new customer
- Solution: Add new customer
- How to find how many products sold
- How to find which items are discontinued
- How to find any sales people who made no sales
- How to find the top product size sold
- How to find the top three items sold
- How to find sales by month and year
- Challenge: Average daily sales
- Solution: Average daily sales
- How to find top customers
- How to find infrequent customers
- How to determine which state purchases the most products
- How to find what products are sold together
- Repeat customer rate
- Challenge: How to find new customers
- Solution: How to find new customers
- Next steps
Taught by
Megan Silvey
