Level Up: Advanced SQL

Focused View

Jess Pomfret

37:25

233 View

01 - Introduction

01 - Advanced SQL code challenges.mp4

00:48

02 - Using GitHub Codespaces with this course.mp4

06:01

03 - How to execute SQLite queries.mp4

03:29

02 - 1. Joins

01 - Create a list of employees and their immediate managers.mp4

01:39

02 - Find salespeople who have zero sales.mp4

01:34

03 - List all customers and their sales, even if some data is gone.mp4

03:00

03 - 2. Grouping

01 - How many cars have been sold per employee.mp4

02:00

02 - Find the least and most expensive car sold by each employee.mp4

02:12

03 - Display a report for employees who have sold at least five cars.mp4

01:47

04 - 3. Advanced Select Options

01 - Summarize sales per year by using a CTE.mp4

02:02

02 - Display the number of sales for each employee by month for 2021.mp4

03:02

03 - Find the sales of cars that are electric by using a subquery.mp4

01:53

05 - 4. Windowing Functions

01 - For each salesperson, rank the car models theyve sold the most.mp4

02:31

02 - Create a report showing sales per month and an annual total.mp4

02:12

03 - Display the number of cars sold this month and last month.mp4

02:31

06 - Conclusion

01 - Keep learning.mp4

00:44

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Programming Fundamentals

Database Programming

Microsoft SQL

Jess Pomfret

Instructor's Courses

Jess Pomfret is a Data Platform Architect and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.