📊 SQL Training | CODELEX
This repository consists of exercises to train your skills on SQL. SQLite was chosen because it is platform agnostic, and stores data in a single file which can be accessed easily.
- basic coding knowledge is preferred, especially string manipulations in JavaScipt / TypeScript;
node&npminstalled on your machine- understanding the basic concepts of SQL, tutorials @sqlzoo.net should be enough
SQLite Browser is a visual tool to help you work with a database.
You can download it here.
Opening database file is as easy as finding it on your file system, file extension is .sqlite3
DbVisualizer is tool, very similar to SQLite browser, but supports many diferrent databases. We are interested in database visualisation, to better understand tables and relationships between them.
Start by opening your database file.
You will be prompted for:
- connection name - choose whatever name you want
- database driver - choose SQLite
- database file - select your database file from file system
We are interested in database visualisation, to do that open TABLES in a new tab.
And click on References.
To start working on exercise, open it as a folder in Visual Studio Code and run npm install