Settings

Choices expand_less

This page will help you configure this book to best meet your needs. You tell us how you want to use the book and we will show you the steps to accomplish it. Expand the "Explanation of Choices" section below to get a detailed explanation of implications of the choices you make here.

Once you have made your choices, complete the required information in the "Configuration Steps" section below, then click the "Apply Configuration" button.

If you have a config code, enter it here		help
A configuration code provides a particular value for each of the choices below. If you are working with a professor or a supervisor, she may have given you one.
Privacy	This is my computer and I'm the only user This computer is used by people other than me	help
If you are the only one who uses this computer for this book, we'll keep your information loaded between sessions so you don't need to re-authenticate for each session.
Authentication	No authentication Local authentication on this computer My own authentication service This book's authentication service (fee applies)	help
With no authentication or local authentication, your settings are only stored on this computer. If you use an authentication service, you can log in to any computer and configuration will go with you.
Database	No Database SQLite data.world Oracle Autonomous Database	help
If you choose "No Database" this book will not actually execute your queries. SQLite requires no setup. The data.world option requires you create a free account. Oracle Autonomous Database requies an account and some configuration work to set up your database and build the datasets required for this book's examples.
Generative AI	None Chat GPT	help
Generative AI (such as Chat GPT or Bard) can help you write SQL. If you choose an option other than "None" then this book will include instructions on how to work with the chosen AI engine to build SQL statements.
Book Contents		help
There are several way to work with the content of this book. Make a choice here and see the "Explanation of Choices" section below for more details about your choice.
Be sure to click "Application Configuration" below.

Explanation of Choices expand_more

This section explains the implications of the choices you made in the interview section above

Privacy

Because you have indicated that you are the only user of this computer, this site will remember your configuration between sessions, so even if you close and re-open this browser, you'll remain logged in to this book and any values you have set up will be accessible.

Because you have indicated that other people use this computer, this site will not remember your configuration between sessions, so you close all pages open to this site, we will automatically discard all setting you have made. Because you selected "No authentication", each session will be like starting from scratch. Because you selected "Local authentication", we'll remember your configuration infomration between sessions on this computer; however, if someone else uses this comuter to access this book, thier confiburation choices will displace yours. Because you selected to authenticate with an authentication service, you will be able to access those settings by logging in.

Authentication

You selected "No authentication" so you will never be prompted for a password. Becuase you indicated that you are the only user of this computer, we'll remember your confguration choices between sessionsother people use this computer, we'll discard your confguration choices when you close the last page open to this website. When you re-open this site, it will be just like starting from scratch. This option does not requre additional configuration on your part.

You selected "Local authentication on this computer" so you will be prompted for a password when you access this site. This password will be used to encrypt any settings you choose, so anyone snooping around will not be able to read your settings and we will remember your sessions between settings. However, becuase you inicated that other people use this computer, you should realize that if someone else log in to this site, any settings you have entered will be replaced with their settings. As a result, when you come back to this computer, you'll be starting from scratch.

You chose to use your own authentication service. It will take about 8 minutes to set up but once it is ready, you'll be able to log into this website on any computer and retreive your configuration settings from your authentication service.

You chose to use this book's authentication service, which involves paying a fee for us to manage an account for you. Once you have set it up, you'll be able to log into this website on any computer and access your configuration settings.

Your choice here matches the current configuration. Because reconfiguring this would require you to enter a password (which we do not store), this option will skip changing your authentication configuration. If you do want to reconfigure your current authentication setting, select the option that ends in "(reconfigure)"

Database

You chose "No database" so this book will not allow you to modify any of the queries presented herein. You will still be able to "execute" the queries as they are presented so see the results, but the queries are not really being executed. The book just retreives the saved data sets that match the queries. That's why you are not allowed to exit the queries, without being connected to a database engine, there is know way to figure out what the correct answer set for a query you write. This option does not requre additional configuration on your part.

You chose "SQLite", which is a free and light-weight database engine that can run right here in your browser. This means that when you run any query, the SQLite engine will determine which records belong in answer and will display them for you. Because SQLite runs in your browser, it is extremely fast. However, it also means that only you can access this database and when you close your session, any changes you have made (such as creating a new table and adding data to it) will be lost. This option does not requre additional configuration on your part.

You chose "data.world", a popular data collaboration site. This will require you to set up a free account at data.world and provide some connection information so this book can connect using your account. Because data.world's implementation of SQL is limited to reading data, the parts of this book that talk about creating tables and inserting, updating and deleting data will not be accessible to you.

You chose the "Oracle Autonomous Database" to run the queries in this book. This is the most powerful database engine that this book can work with. It also takes a bit of work to set up. Just like all the other choices, this option is also free. This database allows multiple people to access it simultaneously and any changes you make to the data will persist between sessions.

You chose "Oracle Autonomous Database", which is how your book is currently configured. Because reconfiguring this would require you to enter a password (which we do not store), this option will skip changing your databse configuration. If you do want to reconfigure your current database setting, select "Oracle Autonomous Database (reconfigure)"

Generative Artificial Intelligence

You chose to exclude support for generative AI. This means that the book will not talk about how use use AI engines (such as Chat GPT) to help you write SQL statements. This option does not requre additional configuration on your part.

You chose to include support for Chat GPT so each time the book introduces a new topic, it will show you how to use Chat GPT to generate the SQL needed to accomplish tasks in that topic. This option does not requre additional configuration on your part.

Book Contents

Configuration Steps expand_less

1.	Choose a password that you will use to authenticate yourself. You will need to remember it for the next time you login. We'll use it to encrypt your settings and work so even if someone gets ahold of this computer, they won't be able to read your data. If you forget this password, there is no way to recover it. login Password visibility
2.	This step helps you set up your own authentication service and configure this book to interact with it. This option is free. smart_display Create a Google Account. You probably already have one of these; if so, skip this step. https://accounts.google.com/signup/v2/cr... smart_display Copy the Authentication Service Google Sheet to your Google Drive, deploy the included script, and record the Deployment ID below. https://docs.google.com/spreadsheets... Deployment ID
2.	Choose the subscription level that makes most sense for you. smart_display Create an account for this book's authentication service ***Paylay configuration goes here***
3.	This step helps you set up your account at data.world and configures this book to work with it. smart_display Set up an account at data.world https://data.world/sign-up smart_display Copy your Read/Write token and paste it below https://data.world/settings/advanced Read/Write Token
3.	This step helps you configure your Oracle Autonomous Database and configures this book to work with it. smart_display Set up an Oracle Cloud Account and create a database. https://signup.cloud.oracle.com smart_display Create a Oracle autonomous database. https://signup.cloud.oracle.com Administrator Username Oracle Connection URL Aministrator Password visibility Data Use Use existing data if possible Rebuild datasets from scratch

Information Import/Export expand_more

If you are using the "No Authentication" or the "Login to this Computer" authentication methods, you may want to copy the information about this book's configuration to a different computer. If so, just click the "Export" button here and save the file to a flash drive or email it to yourself. Then you can use the "Import" button on a different computer to load all your settings. If you enter a password when you export, you'll need to enter that same password when you import. If you forget the password, there is no way to recover it.

This will export as much of your configuration information as possible, including keys that give access to your data.world account or your Oracle account (if you have configured access to those database systems). So don't leave the file laying around after you export it, unless you use a password when you export.

Import or Export (File)
Password		visibility help
This is optional but if you enter a password when you export your settings, you will need to specify the same password when you later import the file. The reason for this option is that you are exporting sensitive information. If you dont' use a password when exporting and you accidentally leave the file on a shared computer, a bad actor could use it to submit assessments on your behalf or access your data.world or Oracle Databases (if you have configured them). The password will make the file unusable to someone who does not know it.
Import or Export (Copy & Paste)