Okay, we have a
Download
1 / 85

Okay, we have a - PowerPoint PPT Presentation


  • 162 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Okay, we have a' - dorinda-urbina


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

Now what?


Suppose I need these two values

Every week on new data





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







This results in Carthesian product


This is called a ‘JOIN’




We have

the filter



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?




Suppose I need these two values

Every week on new data




Can’t pick

field names now



ad