SQL Teaching
Learning and science
sql tutorial
SHOW HN2015
166points
59comments
#117of 2,565 in 2015
Top 5%of 2015 by points
How HN took it
CuriousMostly questions and neutral comments
3 positive, 10 neutral or asking, 3 mixed, 3 critical, out of 19 comments about the project. Thread score -0.03.
Docs: 1 for, 1 againstPerformance: 0 for, 1 againstExecution: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Good start for beginners
From 2 comments
looks good and might be helpful for somebody starting with SQL . You can add some advanced version as well with some more complex examples and use cases with inner queries ,…
uberneo on HNcompleted the course thanks for the tutorials.
mohdmaqboolalam on HN
Useful for learning SQL basics
From 2 comments
In the 'Select specific columns' lesson, FROM isn't capitalized. Not an error but could cause confusion. Same with AND in its lesson. It might also be nice in the first lesson to…
clay_to_n on HNLooks useful. You should submit this on http://hackr.io as well.
gauravgupta on HN
Objections
Lessons too brief and lack explanation of why
From 2 comments
IMHO, I think the material here is too brief, and insufficiently progressive, to help a beginner move to confidence. To master concepts, people need repetition, and application…
chernevik on HNI 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…
veb on HN
Needs more visualization of tables
From 2 comments
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…
veb on HNAs 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…
hobs on HN
No helpful error feedback on invalid queries
From 1 comment
Looks like a great start! One thing that would be essential is better feedback on errors. Currently, if I enter an invalid SQL query I’m only told that it was incorrect. For…
villek on HN
Requests
More visual table diagrams and joins explanation
From 2 comments
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…
hobs on HNI would most definitely love to see some table design thrown in there as well, with ER diagrams, cardinality, and normalization (bonus points for really explaining why well). I…
andrewstuart2 on HN
Gamification
From 1 comment
One thing that makes CodeAcademy successful is an attention to gamification. I think sketching some of that out is a priority for the next iteration. Clear game mechanics is what…
brudgers on HN
Intermediate examples with joins, having, union, subqueries
From 2 comments
Very nice. Love to see a few more intermediate examples using LEFT and RIGHT OUTER and INNER JOIN, HAVING, UNION, and sub-queries.
nodesocket on HNlooks good and might be helpful for somebody starting with SQL . You can add some advanced version as well with some more complex examples and use cases with inner queries ,…
uberneo on HN
Cover inserts and table design
From 2 comments
Good start. Many others have suggested other query types. I would also suggest that you cover inserts as well.
allworknoplay on HNI would most definitely love to see some table design thrown in there as well, with ER diagrams, cardinality, and normalization (bonus points for really explaining why well). I…
andrewstuart2 on HN
Questions
Why use SQL instead of ORMs
From 1 comment
Why the move away from ORMs? I've certainly banged my head against the wall with them any number of times, but I wouldn't want to give up the compile time checking of queries…
PJDK on HN
Alternatives named
SQLZoo
From 2 comments
I have learnt SQL from https://sqlzoo.net It's a really good site with options of other database system syntax also.
avinassh on HNI guess this is the client-side alternative to SQLZOO[0] which is a fantastic resource I used to use back in the day to sharpen my SQL skills. Been doing SQL for so long now but…
xtrumanx on HN
sql-ex.ru
From 2 comments
I was looking for a way to sharpen my SQL skills a few months ago, and after being annoyed with some of the very, very beginner stuff out there I found this:…
asafira on HNCool, will check, thanks. Despite the clunky UI, I've found that www.sql-ex.com provides the best medium to tricky problems for those wanting a refresher. (MS T-SQL centric.)
domoarevil on HN
pgexercises
From 1 comment
This is a self-plug, but you might find http://pgexercises.com useful as well.
AlisdairO on HN
SQL Island game
From 1 comment
Also: "SQL Island", where you text-adventure-like play a game through SQL http://wwwlgis.informatik.uni-kl.de/extra/game/
contradictioned on HN