3 ms·
Don't forget the venerable SQLZoo - I have referred a zillion people to it over the years. https://www.sqlzoo.net/wiki/SQL_Tutorial https://www.sqlzoo.net/wiki/
by hobs 3y ago
Don't forget the venerable SQLZoo - I have referred a zillion people to it over the years. https://www.sqlzoo.net/wiki/SQL_Tutorial https://www.sqlzoo.net/wiki/SQL_Tutorial
Edit: also an inaccuracy that's minor but can bite you if you're not careful - they mention temporary tables are in memory not on disk - that's not true in almost all sql databases, they are just connection specific eg they don't persist after you disconnect.
Some databases are optimized for a temp table to be a throwaway, but that can be a good or bad thing depending on the use case.
- vavooom 3y agoI am also a fan of Mode's SQL Tutorial: https://mode.com/sql-tutorial https://mode.com/sql-tutorial
- wanderingmind 3y agoWhere is the datasources to practice them?
- hobs 3y agoEach query has a built in data source/test but dbfiddle and friends are great if you want to do some setup.