Complete Your First Project in SQL

Offered By: LinkedIn Learning

Tags

Data Analysis Courses SQL Courses Data Cleaning Courses Data Manipulation Courses Database Management Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Elevate your SQL skills and gain a new perspective of how to maximize SQL.

Syllabus

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

Conclusion

Next steps

Taught by

Megan Silvey

Related Courses

Data Wrangling with MongoDB
MongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX