Level Up: Advanced SQL
37mAdvanced2023-03-16
Authors
Jess Pomfret
Database Platform Architect and Microsoft MVP
Course details
Want to test out your advanced SQL skills? This course was designed for you. These concise challenges let you stretch your brain and push your talents to the next level. Join Microsoft MVP and SQL expert Jess Pomfret to find out more about what it takes to become a master SQL user. Learn how to execute some of the more sophisticated SQLite queries, including complex join types, grouping, advanced select options, windowing functions, and more.
This course is integrated with GitHub Codespaces, an instant development environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace.
Each installment of the Level Up series offers at least 15 bite-sized opportunities to practice programming at various levels of difficulty, so you can challenge yourself and reinforce what you’ve learned. Check out the “Using GitHub Codespaces with this course” video to learn how to get a codespace up and running.
This course is integrated with GitHub Codespaces, an instant development environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace.
Each installment of the Level Up series offers at least 15 bite-sized opportunities to practice programming at various levels of difficulty, so you can challenge yourself and reinforce what you’ve learned. Check out the “Using GitHub Codespaces with this course” video to learn how to get a codespace up and running.
Skills covered
Desktop DatabasesSQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Advanced SQL code challenges
- 02 - Using GitHub Codespaces with this course
- 03 - How to execute SQLite queries
1. Joins
- 04 - Create a list of employees and their immediate managers
- 05 - Find salespeople who have zero sales
- 06 - List all customers and their sales, even if some data is gone
2. Grouping
- 07 - How many cars have been sold per employee
- 08 - Find the least and most expensive car sold by each employee
- 09 - Display a report for employees who have sold at least five cars
3. Advanced Select Options
- 10 - Summarize sales per year by using a CTE
- 11 - Display the number of sales for each employee by month for 2021
- 12 - Find the sales of cars that are electric by using a subquery
4. Windowing Functions
- 13 - For each salesperson, rank the car models they've sold the most
- 14 - Create a report showing sales per month and an annual total
- 15 - Display the number of cars sold this month and last month
Conclusion
- 16 - Keep learning
Related courses
- Introduction to Modern Data Engineering with Snowflake
- SQL Practice: Inserting Data with INSERT Statements
- Advanced Python: Practical Database Examples
- SQL Server 2022 Administration
- Oracle Database 19c: Advanced SQL
- ASP.NET Core: Logging with log4net
- Level Up: Advanced Python
- Coding Exercises: Advanced MongoDB