In this following exercise, the user sets up an SQL database and creates a CLI to manage the database. Functionalties include viewing all employees by various parameters and adding/removing/updating roles, departments, and employees.
- Create an SQL database, as well as seed data.
- Create a prompt that takes in user input.
- Allow the user the option to view, add, remove, and update employees, roles, departments, etc...
- Create SQL statements for specific scenarios.
- Retrieve respective SQL data and convert them into usable objects.
npm i
node index.js
to run the app.- Use the prompt to navigate to viewing, adding, and updating employees and departments.
- Javascript
- Node.js
- SQL