Jump to content
sacrophyte

brick & mortar SQL class

Recommended Posts

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.

Share this post


Link to post
Share on other sites

They don't allow you to try any SQL commands that would actually modify the database because that would allow people to hack the server. Only reading commands, such as SELECT can be used.

 

I don't think the W3Schools staff provides any way to download their test databases. You'll just have to build your own.

Share this post


Link to post
Share on other sites

Many of the examples will use a WebSQL database if the browser supports it, although I don't think that database will support all of the commands that they're showing.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...