Concept Map: SELECT Statement (SQL)

Jan 22, 2014 • Abigail Cabunoc

While all the hipsters are out muddling with NoSQL data, you can use the tried and true method of extracting data from your good old relational database with the handy SELECT statement! Assumes learners know what a database is (with a brief refresher on tables/rows). Should be teachable in 5min. I used my highlighters for the first time!

Feedback welcome. Be honest, I can take it, I swear. As I was drawing this, I realized I was unsure whether the WHERE clause should filter back onto the SELECT or the Result set. I settled on Result set since that’s what happens in my brain.

Concept Map: SELECT Statement (SQL)<figcaption class="wp-caption-text">Concept Map: SELECT Statement (SQL). How to extract data from a good old fashioned relational database</figcaption></figure>