qewbi sql

-- QEWBI SQL Command Window

/* Note: If you navigate away from this page you will lose all your saved data! Save your data file before navigating away.
      Files are saved in SQLite format. */

-- Keyboard Shortcuts 
-- Ctrl-Enter: Execute query window code. 
-- Ctrl-S: Save your in-memory database to a local data file. You can reload it from file at any time.
-- Ctrl-D: Clear the editor window.

--  ***** Do not hit refresh on the browser, as this will clear the current database out of memory and it cannot be recovered. *****

-- Click Execute to test the database by creating and querying the following tables.
            DROP TABLE IF EXISTS Instructions;
            DROP TABLE IF EXISTS Learning;
            CREATE TABLE Instructions ([Instructions Info] text);
            CREATE TABLE Learning ([Learning Info] text);

INSERT INTO Instructions VALUES ('Welcome to the QEWBI SQL Creator!');
            INSERT INTO Instructions VALUES ('Support for all standard SQL DML and DDL statements');
            INSERT INTO Instructions VALUES ('Note: If you navigate away from this page your work and data will be lost.');
            INSERT INTO Instructions VALUES ('Save your database using the Save button (or CTRL-S) and reload it on your next visit.');

INSERT INTO Learning VALUES ('Use this tool as part of the qewbi.com learning curriculum.');
            INSERT INTO Learning VALUES ('Our instruction includes lessons for SQL Beginners and SQL Explorers.');
            INSERT INTO Learning VALUES ('You can also learn how to build more complex designs such as qewbs and data warehouses.');

SELECT * from Instructions;
            SELECT * from Learning;

Load DB :

Results will be displayed here

sql query designer

Data Model

This diagram shows the initial data model created by the starter script.
If you make changes to the schema then this diagram will not be in synch with the database in memory.

Download Sample Databases

Northwind Database

Chinook Database