I believe that visualization plays a huge part in learning. In reality, you'll never see "current tables" looking like that. I checked Google Images ("sqlite result") and it seems that you could benefit heaps by designing your tables a bit better so they look like http://i.stack.imgur.com/9CXVO.png perhaps.
I would also pay a little more attention to explaining what something is, and why you do it like that. Instead to me it feels more like "copy and paste this command, click run" and so you're not really learning at all. Why SELECT? Why am I using *?
I realise these explanations may come in the later lessons, but from the very beginning I should know what these are (syntax-wise). Then, as things become progressively different I can understand and follow.
I love sites like this, I think they're so beneficial but my main gripes are usually just that: the results, they really need to feel more real-world, and practical-like. Then, I want to know the why/what/how about everything in what I'm doing.
That's just me though. I may be good at SQL, but I'm damn sure I've probably missed a lot of simple things!
Is there a way to sign my email up for updates? I'd like to follow the progress!
SQL Teaching is designed for non-technical people that want to learn the basics of data analysis. Just learning SELECT with WHERE clauses and basic joins get them pretty far.
I would also pay a little more attention to explaining what something is, and why you do it like that. Instead to me it feels more like "copy and paste this command, click run" and so you're not really learning at all. Why SELECT? Why am I using *?
I realise these explanations may come in the later lessons, but from the very beginning I should know what these are (syntax-wise). Then, as things become progressively different I can understand and follow.
I love sites like this, I think they're so beneficial but my main gripes are usually just that: the results, they really need to feel more real-world, and practical-like. Then, I want to know the why/what/how about everything in what I'm doing.
That's just me though. I may be good at SQL, but I'm damn sure I've probably missed a lot of simple things!
Is there a way to sign my email up for updates? I'd like to follow the progress!
EDIT: Ah there is: https://github.com/rhc2104/sqlteaching