REACT, EXPRESS JS, & MySQL: Express & MySQL from Scratch! (part 1)

We will implement react, express, & mysql in this video series! In this video, we will prepare our restful API using Express! Along with it, we are going to use the MySQL database as the data storage as opposed to having no SQL database like MongoDB. This video series of react, express, & mysql will help you visualize what is it like to build a web app using these technology stacks. This react, express, & mysql tutorial will serve only as a basic foundation on learning the full-stack web development using these technologies.

Previous Video: Introduction
https://www.youtube.com/watch?v=xJbSovPbYVI

Next Video: Express & MySQL from Scratch! (part 2)
https://www.youtube.com/watch?v=xgsn6Z60XAM

Timeline
0:35 – Start an Express Application
0:57 – Generate Package.Json File using NPM Init
2:30 – Installation
3:10 – Create the entry point (index.js)
7:00 – Create an endpoint sample
7:54 – Install nodemon
9:35 – Install MySQL
10:15 – Create a database config file for the database connection
11:27 – Import database config file to the index.js
11:45 – Connect to the database
12:26 – Create a custom script in your package.json file
13:14 – Create an endpoint that queries to the database
15:34 – Isolating or grouping your node js functions by creating separate files (give thanks to module.exports)
16:28 – Making your exported files available in the node js application
17:10 – Understanding directory structure (importing files in node js)

NODE JS
https://nodejs.org/en/download/

XAMPP
https://www.apachefriends.org/download.html

GITHUB for the EXPRESS API
https://github.com/jackoftraits/tweeter-express-api

GITHUB for the REACT APP
https://github.com/jackoftraits/tweeter

Sound: www.bensound.com

#react #express #mysql