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
240
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
Seven New Principles of Software Engineering
yegor256
0
500
Secure Your Coding Agent Like It’s Malware (v1.5) 🇬🇧 @Code.talks 2026
richargh
0
150
AI時代のTerminal環境を UNIX哲学で設計・運用する
yasunori0418
1
350
Beyond Chatbots: Agentic UI with Open Standards @W-JAX 2026, München
manfredsteyer
PRO
0
100
Growing PicoRuby's Ecosystem on ESP32
yuuu
2
140
protojson における文字化けの扱い
kazuki1023
0
430
学びを記事・スライド・Xへ高速展開する― AI-assisted Learning Loopで回すコンテンツ生成術
ochtum
0
210
AIで開発が速くなった先で、開発チームは何を目指すか
shihochan
1
2.1k
どうしても Eloquent でリポジトリパターンをやりたいんだ #phpcon_niigata / phpcon-niigata-2026
shogogg
0
340
手の動かし方がわからなかった私が個人開発者になるまで
usagi0920_pochi
0
100
우리의 Nitro Modules는 당신의 Turbo Modules보다 아름답다
l2hyunwoo
0
260
AI時代のIaC入門 〜なぜインフラをコードで管理したいのか?〜 / Introduction to IaC in the AI Era
akihisaikeda
6
1.5k
Featured
See All Featured
Producing Creativity
orderedlist
PRO
348
41k
First, design no harm
axbom
PRO
2
1.4k
The Curse of the Amulet
leimatthew05
4
17k
The Anti-SEO Checklist Checklist. Pubcon Cyber Week
ryanjones
0
300
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
17k
HTML-Aware ERB: The Path to Reactive Rendering @ RubyCon 2026, Rimini, Italy
marcoroth
6
930
GraphQLとの向き合い方2022年版
quramy
50
15k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
techseoconnect
PRO
0
490
What's in a price? How to price your products and services
michaelherold
247
13k
Reality Check: Gamification 10 Years Later
codingconduct
0
2.4k
Large-scale JavaScript Application Architecture
addyosmani
516
110k
We Analyzed 250 Million AI Search Results: Here's What I Found
joshbly
2
2.1k