3 ms·
It was nice to find your site in addition the the Khan Academy's SQL course. Maybe I will try to direct my kids to walk through this. I am curious if you know
by mswen 11y ago
It was nice to find your site in addition the the Khan Academy's SQL course. Maybe I will try to direct my kids to walk through this.
I am curious if you know a resource that would start approximately where your site/tool stops. I know there are books and reference manuals - but I would love to see the intermediate SQL version of your tool - including things like cursors, stored procedures and Common Table Expressions.
Or does SQL at the next level lose too much of its uniformity? And, you would have to make separate sites for PostgreSQL, MySQL, SQL Server etc.
- rhc2104 11y agoHi mswen, Unfortunately, I don't know of interactive tutorials that cover the things you mentioned. The Khan Academy tutorial and SQL Bolt seem to have a few topics not covered by SQL Teaching, so that is a start! (Mainly, write queries) SQL Teaching uses SQLite because that way I don't need to maintain a backend to the site. But if there are more advanced topics that can be taught by SQLite, feel free to make a issue in the repo. Pull requests are also welcome!
- mswen 11y agoI mainly learn now by looking up things when I have a need and then hoping to still remember it 3 months from now when I need it again. The material covered in your tutorial is kind of the daily bread and butter stuff that I use and am comfortable with, but I know just enough to understand that there is this whole other level to SQL querying - even without really dealing with Database Administration and index tuning. I guess I will just keep learning as the need becomes apparent. Anyway thanks for making your resource available.