Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Query Live Database
Search
Christina Koch
August 23, 2016
Programming
710
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Query Live Database
Christina Koch
August 23, 2016
Transcript
16 slides
QUERIES FOR A LIVE STUDENT DB used in conjunc+on
with www.datacarpentry.org/sql-‐ecology-‐lesson/
Fill out your cards • Name: first name
• Height: in INCHES • Dept (department): close enough (just pick one if you don’t have a home department) • DoC (Dog or Cat): Dog, Cat, Both, Neither, or leave blank
None
SELECT name FROM students
select name,name from StUdEnTs
SELECT name, height FROM students
SELECT name, height*2.54 FROM students
None
SELECT name, dept FROM students WHERE height <= 66
SELECT name, dept FROM students WHERE DoC IN (‘Dog’,
‘Cat’)
SELECT name, height*2.54 FROM students ORDER BY height
SELECT name, height*2.54 FROM students WHERE height >= 68
ORDER BY name DESC
None
SELECT COUNT(*) FROM students
SELECT COUNT(*) FROM students GROUP BY DoC
SELECT MAX(height), MIN(height) FROM students GROUP BY DoC
More Decks by Christina Koch
See All by Christina Koch
Data Carpentry SQL Introduction
christinalk
0
1.4k
The Office Hours Data Conundrum
christinalk
0
220
A Different Kind of Carpentry
christinalk
0
250
Best Practices For All
christinalk
0
190
Workshop Development en breve
christinalk
0
130
Software Portability
christinalk
0
350
Software Licenses and Interpreted Languages
christinalk
0
180
Research Computing Taxonomy
christinalk
0
270
HTCondor User Tutorial
christinalk
0
390
Other Decks in Programming
See All in Programming
Beyond Chatbots: Agentic UI with Open Standards @W-JAX 2026, München
manfredsteyer
PRO
0
130
Getting Started with Vibe Coding
miccheng
0
250
小さなアプリを作って公開するまで
onozaty
0
230
Going Full Circle with Virtual Graphs and Relational Databases
michaelsimons
1
100
AI時代のIaC入門 〜なぜインフラをコードで管理したいのか?〜 / Introduction to IaC in the AI Era
akihisaikeda
6
1.6k
React Native経験者が Flutterを30⽇間触って驚いたこと
3saito
0
210
imagewebp()の向こう側: WebPはなぜ JPEG・PNGより軽いのか
yuzneri
0
150
Scalaの型でマルチテナントの認可を守る
nextbeatdev
0
180
Distance field of Julia set
kinakomoti321
0
330
作れるエンジニアから、価値を届けるエンジニアへ
ryunakayama
1
630
AIコーディング時代のKotest ユニットテストから APIレベルの仕様固定化テストへ
ooga04
0
330
ビジネスロジックを堅牢に~Scala 3のドメインプリミティブ~
j5ik2o
0
220
Featured
See All Featured
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
uxyall
2
4k
Introduction to Domain-Driven Design and Collaborative software design
baasie
1
1.1k
Chasing Engaging Ingredients in Design
codingconduct
0
400
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
360
31k
It's Worth the Effort
3n
188
29k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
33
5.9k
Groundhog Day: Seeking Process in Gaming for Health
codingconduct
0
490
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
123
22k
The Mindset for Success: Future Career Progression
greggifford
PRO
0
570
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
37
6.7k
Context Engineering - Making Every Token Count
addyosmani
9
1.3k
HDC tutorial
michielstock
2
1k