3 ms·
As someone who uses a LOT of SQL, and who has taught people before, I like this as a start, but it definitely needs more visualzation, and I recommend how sqlzo
by hobs 12y ago
As someone who uses a LOT of SQL, and who has taught people before, I like this as a start, but it definitely needs more visualzation, and I recommend how sqlzoo represents tables in the top right with an overlay, its a simple and clear break down.
Something like http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/ http://blog.codinghorror.com/a-visual-explanation-of-sql-joi... may help with additional explanations.
I also think that things like sargability need to be discussed early on because while sql/set based stuff can be odd to grok at first, knowing why you are doing the things you do is important in laying the right foundations.