1 / 85

Okay, we have a

Okay, we have a. Okay, we have a. Now what?. Suppose I need these two values. Every week on new data. Don’t paste!. Make repeatable analyses (without clicking) Easily add data. Structured query language. Structured query language. Developed at IBM. Structured query language.

dorinda-urbina
Download Presentation

Okay, we have a

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Okay, we have a

  2. Okay, we have a Now what?

  3. Suppose I need these two values Every week on new data

  4. Don’t paste!

  5. Make repeatable analyses(without clicking) • Easily add data

  6. Structured query language

  7. Structured query language • Developed at IBM

  8. Structured query language • Developed at IBM • Usually NOT considered a programming language

  9. Structured query language • Developed at IBM • Usually NOT considered a programming language • But a “domain specific language”

  10. Structured query language • Developed at IBM • Usually NOT considered a programming language • But a “domain specific language” • Aimed at analyzing and manipulating DATA

  11. Suppose I need these two values Every week on new data

  12. Where is like ‘filter’ in Excel

  13. But we need temperature?

  14. In Excel, we did a lookup

  15. Temperature is here

  16. To fix a bit (move rows up)

  17. This results in Carthesian product

  18. This is called a ‘JOIN’

  19. Very similar to VLOOKUP

  20. We have a temperature field now

  21. We have the filter

  22. We still need to show: Machine & temperature

  23. Benefit over Excel: We can have multiple such queries

More Related