Book Configuration

This book can be configured to work in several differnt modes. Some require additional information to enable.

check_box_outline_blankBook Only: This is the most basic configuration. The book's content is static; examples will be presented using the SQL standard syntax and cannot be modified. Although you will be able to run the examples displayed and see results, they are not being executed by a relational database management system—it's just a simulation.

Here's the Direct Link to open this book without a datbase engine.

check_box_outline_blankSQLite: The book's examples and queries will be executed using SQLite, a lightweight relational database management system. This is the default mode and requires no additional setup. All queries are run locally and any tables created or data entered are lost when you end your session.

Here's the Direct Link to open this book for SQLite.

check_box_outline_blankdata.world: The book's examples and queries will be executed using data.world, a popular data-sharing site. This mode requires that you have a data.world account and supply your read/write token to be able to execute queries. Becuase data.world noes not allow you to modify data, the book's interactive features will be restricted to data extraction and analytics. So, you will not be able to run SQL statements that insert, update or delete data.

To execute queries using data.world, please enter your Read/Write token from the advanced settings of your data.world account.

Read/Write token:		class="material-symbols-outlined button inline-icon">help

check_box_outline_blankOracle Autonomous Database: The book's examples and queries will be executed using your Oracle Autonomous Database, a free, powerful, relational database you configure in the Oracle cloud. This mode provides the complete database experience. You can execute queries that read and modify data that will persist between sessions.

It appears that the database you are using does not have the examples used in this book. To add them, supply the credentials for a database account with permissions to create users. The "admin" account will do.

check_box


check_box_outline_blank

person

navigate_before

Table of Contents

expand_more

navigate_next

Loading Page hourglass_empty