Complete Your First Project in SQL
1h 17mIntermediate2024-03-18
Authors

Megan Silvey
Course details
Grow your knowledge of SQL and gain a new perspective of how to maximize SQL—and learn how to go beyond creating databases and pulling data from tables. This course provides a real-world application SQL programmers can utilize to enhance learning—and a project you can add to your coding portfolios. Instructor Megan Silvey presents a project that focuses on performing an analysis on retail data by utilizing SQL. Analyze data that includes tables with product, sales, and customer information for an ecommerce retailer. Learn about updating information in the tables, analyzing sales data, evaluating customer data, and more. The objective of this course is to provide a life-like application for SQL programmers that they can use to enhance their learning along with providing them with a potential project to add to their portfolio. This project will focus on performing an analysis on retail data by utilizing SQL. The data will include tables with product, sales, and customer information for an e-commerce retailer such as Binaryville robots or H+ Sport from the LinkedIn Learning asset bank. The analysis will include updating information in the tables, analyzing sales data, evaluating customer data, and more.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementProjectData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
Introduction
- SQL introduction
- What you should know
- Codespaces
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
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
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
Conclusion
- Next steps