Introduction to Relational Databases, SQL and Knex

In this project we will cover the basics of Structure Query Language (SQL), Relational Databases, and Knex.js Queries.

Prerequisites

• SQLite Studio Installed.

Project Setup

• clone this repository.
• move into the project folder.
• type npm i to download dependencies.
• type npm run server to start the dev server.

Coding Along

Before using the following scripts it's recommended to remove the database from SQLite Studio.

• type npm run resetdb to reset the database to its initial state.