sacrophyte

I love what w3schools is doing with the SQL tutorial - good stuff. I noticed that one of the most fundamental elements of w3schools (the "Try it now" button) goes missing about half-way through the SQL Tutorial. May I ask why? I teach sql at a local community colleg. I have gone through several textbooks with mixed results, and I am always keeping my eyes open for new ways to teach. I would love to incorporate w3schools SQL tutorial into my class; do you have a db dump available for download of the tables you use? One of my lessons will be having students figuring out how to get the data from the tutorial into a local database, but having the entire dataset available up front would be handy. If such a db dump is not available, no worries - easy enough to generate one. Thanks again for your time and attention.

I love the work going on at w3Schools - awesome stuff! For the SQL Tutorial, might I suggest a accessible logical model for the tables? For instance, in the "Try it" demo pages, there is a right-hand-side pane with all the available tables, but there is no way to just view the columns of those tables without leaving behind the current sql worksheet. It would be tremendously helpful if users/students could view, via some kind of client-side magic (javascript?), the model of the tables. Ideally, this would include the metadata like primary key and constraint information, but just starting with the name of the columns would be sweet. Thanks for your time and attention.