5 ms·

This is great! I created http://sqlteaching.com http://sqlteaching.com , so it's wonderful to see Khan Academy's take. If anyone from KA would like to chat wi

by rhc2104 11y ago

This is great! I created http://sqlteaching.com http://sqlteaching.com , so it's wonderful to see Khan Academy's take. If anyone from KA would like to chat with me about SQL tutorials or anything else in general, feel free to reach out- rhc2104@columbia.edu

tsumnia 11y ago
I love your site and plan to use it as a teaching tool for my Wed Development course I'm teaching. As a request, are you working on a user system to record completed lessons? As an extension, are you looking into making a classroom management system akin to Codecademy? I'd love to create a classroom, have students log in, complete the necessary lessons and have the means to know where they are in the overall plan. If you'd like some help getting that going, let me know! I'm in the process of developing typing exercises for my courses to give students extra practice with the basics.
- rhc2104 11y ago
  Hi tsumnia, Thanks for the feedback! One nice thing about SQL Teaching is that it is completely client-side. This is possible because somebody compiled SQLite to JavaScript: https://github.com/kripken/sql.js/ https://github.com/kripken/sql.js/ Thus, I would have a bias against adding a classroom management system which would require some kind of backend database that I would need to keep running (funny, I know). However, SQL Teaching is open source https://github.com/rhc2104/sqlteaching https://github.com/rhc2104/sqlteaching , so I would update the site if you were to add the feature, or you could just take the JavaScript files and integrate it into your site!
  - tsumnia 11y ago
    Not funny at all! Its something that I am toying with on my end as well. I'll have to play with it this summer and let you know if I get anything rolling!
- pamelafox 11y ago
  Pamela from KA here. We're using the same client-side SQL solution as sqlteaching.com (which is great!). Our editing environment is here and open source: https://github.com/Khan/live-editor https://github.com/Khan/live-editor KA does have classroom tools and progress reports, but we don't have the ability for teachers to create their own lessons (if that's what you're looking for). More details on that here: https://www.khanacademy.org/coach-res/reference-for-coaches/teaching-computing/a/tracking-progress-of-programming-students https://www.khanacademy.org/coach-res/reference-for-coaches/... It's a lot of work to create the classroom management itself (that's done by a whole separate team at KA) so it's not something most folks tack on to teaching sites.
wildster 11y ago
Your going to get a load of spam putting you email address up here like that.
deleted 11y ago
[deleted]
kiyoto 11y ago
I've definitely recommended your service to my friends looking to learn SQL. Also, I made my share of contribution to the SQL pedagogy by writing blog articles on "SQL for Excel Users": http://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-calculating-customer-lifetime-value-part-1/ http://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-ca...
IkmoIkmo 11y ago
Thanks! Will check out both sites.
deleted 11y ago
[deleted]
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 ago
  Hi 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 ago
    I 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.
MarcScott 11y ago
I used your site recently to help my GCSE students revise for their CS exam. It was perfect, so thanks for all your efforts in creating it.
benbristow 11y ago
Hey. Thanks for this, it's absolutely fantastic. Been using SQL for a while now but never got the hang of joins and could never find an easy guide for them. This was the simplest explanation I could find.
- Obi_Juan_Kenobi 11y ago
  Some people find graphics like this helpful for conceptualizing them : http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visu...

by rhc2104 11y ago

tsumnia 11y ago

I love your site and plan to use it as a teaching tool for my Wed Development course I'm teaching. As a request, are you working on a user system to record completed lessons? As an extension, are you looking into making a classroom management system akin to Codecademy? I'd love to create a classroom, have students log in, complete the necessary lessons and have the means to know where they are in the overall plan. If you'd like some help getting that going, let me know! I'm in the process of developing typing exercises for my courses to give students extra practice with the basics.

rhc2104 11y ago
Hi tsumnia, Thanks for the feedback! One nice thing about SQL Teaching is that it is completely client-side. This is possible because somebody compiled SQLite to JavaScript: https://github.com/kripken/sql.js/ https://github.com/kripken/sql.js/ Thus, I would have a bias against adding a classroom management system which would require some kind of backend database that I would need to keep running (funny, I know). However, SQL Teaching is open source https://github.com/rhc2104/sqlteaching https://github.com/rhc2104/sqlteaching , so I would update the site if you were to add the feature, or you could just take the JavaScript files and integrate it into your site!
- tsumnia 11y ago
  Not funny at all! Its something that I am toying with on my end as well. I'll have to play with it this summer and let you know if I get anything rolling!
pamelafox 11y ago
Pamela from KA here. We're using the same client-side SQL solution as sqlteaching.com (which is great!). Our editing environment is here and open source: https://github.com/Khan/live-editor https://github.com/Khan/live-editor KA does have classroom tools and progress reports, but we don't have the ability for teachers to create their own lessons (if that's what you're looking for). More details on that here: https://www.khanacademy.org/coach-res/reference-for-coaches/teaching-computing/a/tracking-progress-of-programming-students https://www.khanacademy.org/coach-res/reference-for-coaches/... It's a lot of work to create the classroom management itself (that's done by a whole separate team at KA) so it's not something most folks tack on to teaching sites.

wildster 11y ago

Your going to get a load of spam putting you email address up here like that.

deleted 11y ago

[deleted]

kiyoto 11y ago

I've definitely recommended your service to my friends looking to learn SQL. Also, I made my share of contribution to the SQL pedagogy by writing blog articles on "SQL for Excel Users": http://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-calculating-customer-lifetime-value-part-1/ http://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-ca...

IkmoIkmo 11y ago

Thanks! Will check out both sites.

deleted 11y ago

[deleted]

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 ago
Hi 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 ago
  I 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.

MarcScott 11y ago

I used your site recently to help my GCSE students revise for their CS exam. It was perfect, so thanks for all your efforts in creating it.

benbristow 11y ago

Hey. Thanks for this, it's absolutely fantastic. Been using SQL for a while now but never got the hang of joins and could never find an easy guide for them. This was the simplest explanation I could find.

Obi_Juan_Kenobi 11y ago
Some people find graphics like this helpful for conceptualizing them : http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visu...