Inner Join / Outer Join - The Database Song

2010-01-26

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