Content

Module 1

13m
SQL Query Basics
Virtual Lab
13m
Retrieving Data
Assessment
13m
Audit the Orders
Assessment
13m
Keeping Privacy While Retrieving Data
Assessment
13m
SQL Specifying Your Results
Virtual Lab
13m
Working with the SUBSCRIPTIONS Table
Assessment
13m
Filtering Cancellations
Assessment
13m
Filtering for the Yearly Premium Package
Assessment
13m
Math with SQL
Virtual Lab
13m
Finding Revenue per Day
Assessment
13m
Finding Incorrect Order Totals
Assessment
13m
Checking the Current Inventory Level
Assessment
13m
Bringing it All Together: SQL Basics
Assessment
13m
SQL Logical Operators
Virtual Lab
13m
Commonalities in High Value Orders
Assessment
13m
Replenishing Low Stocked Items
Assessment
13m
Finding Order Records
Assessment
13m
SQL Logical Operators - AND & OR
Virtual Lab
13m
Checking on Low Inventory Products
Assessment
13m
Reaching Out to Customers Who Cancelled Their Subscriptions
Assessment
13m
Researching Subscriptions from a Specific Date
Assessment
13m
SQL Logical Operators - LIKE
Virtual Lab
13m
Analyzing Customers' Email Addresses with Specific Domains
Assessment
13m
Analyzing Customers' Email Addresses without Specific Domains
Assessment
13m
Finding Email Addresses with "Bad Data" - % Symbol
Assessment
13m
SQL Logical Operators - IN
Virtual Lab
13m
Researching the Success of Premium Plans
Assessment
13m
Targeting Ads Based on Location
Assessment
13m
SQL Logical Operators - BETWEEN
Virtual Lab
13m
Finding the Subscriptions About to Expire
Assessment
13m
Finding Orders within a Specific Time Period and Amount
Assessment
13m
Bringing it All Together: Logical Operators
Assessment
13m
SQL Null Values
Virtual Lab
13m
Finding Orders That Were Not Refunded
Assessment
13m
Finding Orders That Were Refunded
Assessment
13m
SQL Putting Results in Order
Virtual Lab
13m
Pull a Report of Items with Lowest Inventory on Top
Assessment
13m
Pull a Report of Items with Highest Inventory on Top
Assessment
13m
Pull a Report of the Most Discounted Items
Assessment
13m
Bringing it All Together: Null Values and Ordering
Assessment
13m
SQL Aggregate Functions - MAX & MIN
Virtual Lab
13m
Finding the Highest Amount Refunded to a Customer
Assessment
13m
Finding the Exact Date and Time of the First Ever Purchase
Assessment
13m
Finding the Highest Order Amount Purchased
Assessment
13m
SQL Aggregate Functions - COUNT
Virtual Lab
13m
Finding the Total Amount of Items Refunded
Assessment
13m
Finding the Number of Subscriptions About to Expire
Assessment
13m
Finding Orders that Used an AMEX Credit Card
Assessment
13m
SQL Aggregate Functions - SUM
Virtual Lab
13m
Finding Total Revenue for an Individual Month and Year
Assessment
13m
Finding Total Number of Items That Haven't Been Replenished
Assessment
13m
Calculating the Average Order Value for the Year
Assessment
13m
SQL Aggregate Functions - AVG
Virtual Lab
13m
Calculating the Average Order Value for the Year Using the AVG Function
Assessment
13m
Calculating the Average Order Quantity
Assessment
13m
Calculating the Percentage of Tax
Assessment
13m
SQL Grouping Your Data
Virtual Lab
13m
Finding the Total Revenue Per Day
Assessment
13m
Finding the Most Total Items Sold Between Two Dates
Assessment
13m
Finding the Total Number of Cancellations for Each Type of Subscription
Assessment
13m
Finding the Total Number of Cancellations for Each Type of Subscription by Date
Assessment
13m
Comparing Completed and Cancelled Subscriptions
Assessment
13m
Bringing It All Together: Aggregate Functions & Grouping Your Data
Assessment
13m
SQL Using Unique Values
Virtual Lab
13m
Finding Customers That Bought the Most Unique Items
Assessment
13m
Calculating the Average Number of Orders per Unique Customer
Assessment
13m
SQL Filtering Aggregated Queries
Virtual Lab
13m
Finding the Customers with 3 or More Refunds
Assessment
13m
Finding the Items That Have Been Returned the Most
Assessment
13m
Finding the Customers That Have Never Cancelled Their Subscriptions
Assessment
13m
SQL CASE Statements
Virtual Lab
13m
Finding Similarities in Orders
Assessment
13m
Finding How User Experience Affects Orders
Assessment
13m
Investigating Customer Behavior Based on Their Acquisition Platform
Assessment
13m
Bringing it All Together: Unique Values, Filtering Aggregated Queries, & CASE Statements
Assessment
13m
SQL Working with Data Types
Virtual Lab
13m
Pull a Report of the Most Combined Inventory from Both Facilities
Assessment
13m
Find the Total Number of Items Stocked Each Day at Facility A
Assessment
13m
Pull a List of Users Who Started a Subscription in a Specific Month and Year
Assessment
13m
Finding the Last 4 Digits of Credit Cards Associated with Specific Orders
Assessment
13m
SQL Working With Dates
Virtual Lab
13m
Helping the Marketing Team Decide on a Promotion
Assessment
13m
Finding the Total Revenue by Month Using the DATE_TRUNC Function
Assessment
13m
Finding the Total Revenue by Month Using the DATE_PART Function
Assessment
13m
Finding the Average Order Value for Each Day of the Week
Assessment
13m
Finding the Average Number of Weeks until a User Cancels
Assessment
13m
SQL Working With Strings
Virtual Lab
13m
Researching Customers' Email Domains
Assessment
13m
Finding the Most Visited Product Pages using the SPLIT_PART Function
Assessment
13m
Combining Columns using the CONCAT and LOWER Functions
Assessment
13m
Bringing it All Together: Data Types, Dates, and Strings
Assessment
13m
SQL Joining Datasets
Virtual Lab
13m
Finding the Total Revenue Brought in by Subscriptions Each Month
Assessment
13m
Finding the Total Quantity Sold for Each Product Type
Assessment
13m
Finding the Total Qualtity Returned for Each Product Type
Assessment
13m
SQL Outer Joins
Virtual Lab
13m
Displaying Monthly Revenues and Refunds Side-by-Side
Assessment
13m
Displaying Quarterly Revenues and Refunds Side-by-Side
Assessment
13m
SQL More Join Techniques
Virtual Lab
13m
Finding Products That Were Added to Customers' Orders Last
Assessment
13m
Finding Information on Orders for Customer Outreach
Assessment
13m
Finding the Total Percentage of Items Sold
Assessment
13m
Creating a List of Customer Email Addresses That Meet a Certain Criteria
Assessment
13m
Bringing it All Together: Joining Datasets, Outer Joins, and Join Techniques
Assessment
13m
Finding Products with over 100 Items in Stock
Assessment
13m
SQL Subqueries
Virtual Lab
13m
Finding Customers' Email Addresses That Cancelled within a Week
Assessment
13m
Adding a Column to Find Total Number of Lifetime Orders
Assessment
13m
Using a Subquery to Find the Customers' Email Addresses with a Specific Domain
Assessment
13m
SQL Common Table Expressions
Virtual Lab
13m
Finding the Time Elapsed between Orders
Assessment
13m
Using CTEs to Find a Count of Repeat Orders
Assessment
13m
Comparing the Number of Items Sold Each Day with the Items Returned Each Day
Assessment
13m
SQL UNION
Virtual Lab
13m
Using a UNION to Combine Multiple Queries
Assessment
13m
Bringing it All Together: Subqueries, Common Table Expressions, and UNION
Assessment
13m
SQL Window Function Basics
Virtual Lab
13m
Using a Window Function to Compare an Item's Inventory Level to the Product's Average Inventory Level
Assessment
13m
Analyzing Orders during Promotional Periods
Assessment
13m
Using a Window Function to Increment a Count for Every Order
Assessment
13m
SQL Window Functions - Numbering & Ranking
Virtual Lab
13m
Analyzing the Sequence of Customers' Orders
Assessment
13m
Analyzing Customers' Second Orders
Assessment
13m
Analyzing Customers' Second Orders - Removing the Gaps
Assessment
13m
Ranking the Best States for Total Revenue
Assessment
13m
SQL Window Functions - Aggregates
Virtual Lab
13m
Finding Revenue by Week for Each Plan Type
Assessment
13m
Editing Your Report to Include the Number of Subscriptions and an Overall Count by Week
Assessment
13m
Bringing it All Together: Window Function Basics, Numbering & Ranking, and Aggregates
Assessment
13m
SQL Window Functions - LAG & LEAD
Virtual Lab
13m
Analyzing Key Performance Indicators: Previous Subscriptions
Assessment
13m
Analyzing Key Performance Indicators: Next Subscriptions
Assessment
13m
SQL Window Functions - FIRST_VALUE
Virtual Lab
13m
Using a FIRST_VALUE Window Function
Assessment
13m
Bringing it All Together: Window Functions LAG, LEAD, and FIRST_VALUE
Assessment

Description

Learn SQL by stepping into the role of a data scientist for two fictional companies.

Congratulations! You are now the data scientist for two fictional companies: a retail company (Monday Boots) and a software-as-a-service (SaaS) company. Throughout this course you will face real-world challenges that will require you to pull reports and manipulate databases in order to help your colleagues make well informed business decisions.

In this course you will explore topics, such as: Query basics, Logical operators: AND, OR, LIKE, IN, & BETWEEN, Aggregate functions: MAX, MIN, COUNT, SUM, & AVG, CASE statements, Joining datasets, Window functions: LAG, LEAD, & FIRST_VALUE ... and much more!

Prerequisites

No prior experience is required to complete this course.

Provided By

Next Tech

Course Components

Virtual Labs to gain hands on experience and apply what you learned
Assessments to gauge understanding and comprehension

Certificate of Completion

Certificate Of Completion

Complete this entire course to earn a Hands-On with SQL Certificate of Completion