Server Configuration
This site can store some information about your preferences and credentials on this compter using cookies. Be thoughtful about this setting. Selecting "I'm the only user of this computer" will make this book easier to use but will result in values being stored on this computer that would allow a bad actor who gets his or her hands on this compter to access to your databases, submission data, and query history.
This is a shared computer.
I'm the only user of this computer.
This book allows you to execute its queries using SQLite without any additional configuration. In the un-configured mode, you will not have access to any of your query history or be able to save query assessments before submitting them. If you want these features or if you want be able to run this book's queries and assessments using data.world or Oracle, you will need to do a bit more configuration. You can configure this book to suppor these advanced features registering as a paid-user or by configuring a Google Sheet to act as your own, private server.
Register as a paid user: You have two options as follows.
- One-year subscription: For $10 you can create an account that will enable the advanced features and give access to two (2) auto-grading query assessments (an $8 value). Access will continue for one (1) year from the time you subscribe.
- Five-year subscription: For $35 you can create an account that will enable the advanced features and give access to eight (8) auto-grading query assessments (a $32 value). Access will continue for four (4) year from the time you subscribe.
Log in as a paid user to enable the advanced features:
Login form coming soon.
Configure your own server (free): This will take a bit of effort, but if you are technically mineded, it won't be too bad. You will need to copy a Google sheet, open the Google Apps Script editor and deploy the included code as a web app. The whole process should take less than eight (8) minutes. Because Google has not reviewed the code, you'll see several warnings that your actions may not be safe. If this makes you queasy, you may prefer one of the paid options listed above. Here's a link to a video that will walk you through the process.
Provide the configuration details for your private server:
Deployment ID: | |
User Name: | |
Password: | |