Finally found some footage of the Inner Join / Outer Join database song Craig Campbell and I created for the Schematic Tech Summit in September 2008! (The contribution was: lyrics about 50/50 and 100% of music is original and written by Craig.)
Link to the footage: Inner Join / Outer Join
And the lyrics:
Craig: “Hey Maggie, I think this song’s going to be in A major…”
Maggie “Major?! but I just met’er!”
inner join outer join
do you really know the difference?
inner join outer join
a null could ruin your existence
it doesn’t matter which you choose
whichever database you use
oracle, mysql [and postgres!]
i’ve got a story i should tell
about inner and outer joins
CHORUS
do those phrases sound like gibberish
like bubbles from a talking fish?
or german or italian
or japanese or french or dutch
or maybe klingon?
CHORUS
focus on integrity
and your database will feel pretty
do you want an epic fail
or do you want your app to scale
and reach to Jupiter
where aliens can run queries
to make sure you have your foreign keys
have your ON DELETE CASCADE
relations come to aid!
your world is normalized
CHORUS x 2
Tweets that mention Inner Join / Outer Join – The Database Song - Maggie Nelson -- Topsy.com
on Jan 26th, 2010
@ 8:03 pm:
[...] This post was mentioned on Twitter by devfunnel, Planet PHP, Lenin, Maggie Nelson, balder and others. balder said: For the SQL geeks RT @planetphp: Inner Join / Outer Join – The Database Song – Maggie Nelson http://bit.ly/5yk0Kc #php #planetphp [...]
Maria Lovell
on Jan 28th, 2010
@ 5:17 pm:
I really enjoyed this post. That is nice when you find something that is not only informative but entertaining. Awesome!