Level Up: Advanced SQL

Take your SQL skills to the next level in this interactive, advanced coding course.

Introduction

• Advanced SQL code challenges
• Using GitHub Codespaces with this course
• How to execute SQLite queries

1. Joins

• 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

2. Grouping

• 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

3. Advanced Select Options

• 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

4. Windowing Functions

• 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

Conclusion

• Keep learning