课程: SQL Practice: Window Functions

What you should know - SQL教程

课程: SQL Practice: Window Functions

开始一个月试用

What you should know

“

- [Narrator] In this Code Challenge course, I expect you to be familiar with using window functions in SQL. We'll explore a couple of common window functions that are widely used in data analysis and reporting. The challenges start out with some fundamentals, and become more involved as the course moves on. If you need to refresh your SQL knowledge, take a look at these courses in the LinkedIn Learning Library. In the challenges, we provide a database that describes a small neighborhood restaurant. We'll see tables like employees, reservations, orders, dishes, and so on. Each challenge will give you an Entity Relationship Diagram to describe the table or tables being used. And feel free to select star on the tables to look at the actual data. If you do, the interface will show that the output is a wrong answer, but don't worry there's no points or time or anything like that that you'll lose, or risk having taken away. To work on these challenges you don't need to install any separate software. The Coding Challenge environment is part of the LinkedIn learning course page. We'll explore how that works in the next video.

内容