课程: SQL Hands-On Practice: Solve Business Problems

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Dealing with hierarchical data

Dealing with hierarchical data - SQL教程

课程: SQL Hands-On Practice: Solve Business Problems

开始一个月试用 购买团队方案

Dealing with hierarchical data

“

- [Instructor] Let's say you need to pull a report for IT that lists each user and their associated admin. You know that all of this data exists in the user table and lists the admin ID for each user, so that's all you need. Mission accomplished, right? Wrong! Can you think of why it might not be helpful to export the admin ID for each user and send the list over to IT? Higher level stakeholders don't think in IDs and variables like we data analysts do. So we have to convert the IDs into something that they can understand, like a user name or email. Thinking like an end user and considering your audience is what can really separate a senior analyst from an entry-level analyst. So let's help them out by matching all of the admin IDs to names so that they don't have to do the manual matching work themselves. The user IDs and admin IDs are both located in the user's table and since all admins are users, all of the admin…

内容