Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Level Up: Advanced SQL

via LinkedIn Learning

Write review
Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → GetSmarter Ad

MIT Sloan: Lead AI Adoption Across Your Organization — Not Just Pilot It

Learn More →

Overview

Syllabus

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

Taught by

Jess Pomfret

Reviews

4.5 rating at LinkedIn Learning based on 593 ratings

Start your review of Level Up: Advanced SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.