Okay, we have a
Sponsored Links
This presentation is the property of its rightful owner.
1 / 85

Okay, we have a PowerPoint PPT Presentation


  • 149 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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

  • Developed at IBM

  • Usually NOT considered a programming language


Structured query language

  • Developed at IBM

  • Usually NOT considered a programming language

  • But a “domain specific language”


Structured query language

  • Developed at IBM

  • Usually NOT considered a programming language

  • But a “domain specific language”

  • Aimed at analyzing and manipulating DATA


Suppose I need these two values

Every week on new data


Where is like ‘filter’ in Excel


But we need temperature?


In Excel, we did a lookup


Temperature is here


To fix a bit (move rows up)


This results in Carthesian product


This is called a ‘JOIN’


Very similar to VLOOKUP


We have a temperature field now


We have

the filter


We still need to show: Machine & temperature


Benefit over Excel:

We can have multiple such queries


Benefit over Excel:

We can have multiple such queries


We have the

right data


We have the

right data

But! We need ‘pivot like’ summary on average


AVG of what?

Of everything?

Per machine?


AVG of what?

Of everything?

Per machine?


Almost there!


Almost there!


Suppose I need these two values

Every week on new data


Remember lecture 1?


  • Make repeatable analyses(without clicking)

  • Easily add data


Can’t pick

field names now


We made an easily repeatable analysis!


  • Login