Take your SQL skills to the next level in this interactive, advanced coding course.
Overview
Syllabus
Introduction
- Advanced SQL code challenges
- Using GitHub Codespaces with this course
- How to execute SQLite queries
- Create a list of employees and their immediate managers
- Find salespeople who have zero sales
- List all customers and their sales, even if some data is gone
- How many cars have been sold per employee?
- Find the least and most expensive car sold by each employee
- Display a report for employees who have sold more than five cars
- Summarize sales per year by using a CTE
- Display the number of sales for each employee by month for 2021
- Find the sales of cars that are electric by using a subquery
- For each salesperson, rank the car models they've sold the most
- Create a report showing sales per month and an annual total
- Display the number of cars sold this month and last month
- Keep learning
Taught by
Jess Pomfret
