4 ms·
I have learnt SQL from https://sqlzoo.net https://sqlzoo.net It's a really good site with options of other database system syntax also.
by avinassh 12y ago
I have learnt SQL from https://sqlzoo.net https://sqlzoo.net It's a really good site with options of other database system syntax also.
- MegaLeon 12y agoReturns a "webpage not available" for me. However, if I access it from http://sqlzoo.net/wiki/Main_Page http://sqlzoo.net/wiki/Main_Page it seems fine.
- AlisdairO 12y agoThis is a self-plug, but you might find http://pgexercises.com http://pgexercises.com useful as well.
- hobs 12y agoAs 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.