Introduction
SQL introduction
()
What you should know
()
Codespaces
()
1. Maintaining Data
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
()
2. Exploring Sales Data
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
()
3. Exploring Customer Data
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
()