SQL NOTEBOOK SCHOOL

Quick environment to learn SQL with NOTEBOOK STYLE using WEB SQL -- LIVE DEMO

Theory sesions:

• Sql Basic Topics - View Slides

Why?

Getting started with SQL requires a database system and their initial setup could be difficult, because in most cases pre-requisites are necesary as:

• Select a data base motor
• Create a local data base or from cloud vendor
• Get credencials
• Get connections
• Install conection tools ot libraries
• Create tables, insert new data, etc...

So, this notebook sql enviroment is redy to use directly in web browser in cliente side with any pre-requisite and their purpose is learn SQL.

Chinook Data Base

As you can se in first image, this data base run directly in the web browser and chinook data base is ready to use.

Limitations

Web SQL is a fetuare based in sql lite data base, but their use is not suported for W3 comunity and consecuently is not suported by all browser, so please check suported browsers.

Third party code

To create this repo was necesary use sqcripts from lerocha and json data from marko-knoebl. In this way DER was extracted from Schema - SPY.

The main editor is based in Codemirror.

Thanks to Tholman for Github Corners.