Node, Express, React JS & MySQL full stack web development

Install Visual Studio Code, a popular lightweight code editor from Microsoft, and begin front end web development.

Install Postman and begin using it to test our rusty base, establishing a basic testing workflow in the full stack development course.

Install MySQL Workbench to connect to a database and create the necessary database objects as part of the full stack web development workflow.

Install node js using netinstall, then verify the installation by checking the Indian version on your system.

Create department and employee tables in a MySQL database on Azure, defining department id and name, employee id and name, date of joining, photo file name; insert and select records.

Set up and initialize a back-end project with express and node.js, using mongodb as the database, including creating package.json and index.js with body-parser.

Enable cors by installing the cors module, import it into the project, and apply basic usage to allow all requests; in production, use cors options to whitelist certain domains.

Install the MySQL Node.js module, import it, set up connection details (server name, username, password, database name), and call connection.connect with error handling to verify a successful database connection.

Design and implement API methods for department and employee tables using Node, Express, and MySQL, including get, post, put, and delete endpoints with testing via Postman.

Learn to build a file upload api with express-fileupload, create a photos directory, handle post /employee/savefile, save the uploaded file from req.files.file, and return the file name.

Create a React JS project, run the default template, and wire App to the root. Then install Bootstrap and apply its styling to render a bootstrap-styled heading.

Install reactor dome and create home, department details, and employee health components. Set up a navigation menu and routes for /, /department, and /employee, then verify routing.

Create api endpoints file, import it into department component, and display data from api in a bootstrap table with id, name, and options for edit or delete; refresh on mount.

Implement a Bootstrap modal popup window to add, edit, or delete departments with confirmation, and refresh the grid after API calls.

Copy the department component to build the employee details screen, store data in employees, populate a department dropdown from department data, and display a profile photo computed from variables.

Implement the image upload flow by adding a file input button, creating form data for the file, update the photo file name after upload, and test create, update delete methods.

Implement sorting and filtering for the grid using includes-based filtering, input text boxes, and a toggle for ascending or descending order, with icons and live testing.