NodeJs API with MySQL and Docker

Name: NodeJs API with MySQL and Docker
Rating: 3.9 (28 reviews)

Create a NodeJs back-end API from scratch with MySQL database server. Deploy to AWS using Docker.

Created byGet Arrays

Last updated 12/2021

English

What you'll learn

NodeJs API
CRUD Operations
MySQL Data Management
Dockerization of application

Course content

11 sections • 26 lectures • 3h 4m total length

Introduction3:09
Explore building a Node.js API with Express and MySQL, implementing persistence, and deploying via Docker to see it live.
Setting up NodeJs7:59
Initialize a node project with npm init, set up a source folder with index.js as the entry, install express, mysql, cors, dotenv, ip, and pino with pino-pretty.
First NodeJs Server9:31

HTTP Response3:56
Create a simple response class for api replies, with a constructor that takes status code, message, and data, automatically adds a timestamp via new Date().toLocaleString(), and exports for frontend responses.
Using HTTP Response4:33
Learn to implement an HTTP response in a NodeJs API by constructing a response object and sending a 200 OK status, optionally including data such as a dummy patients list.

Get Patients5:20
Implement a get patients function that logs request method and url. It queries the database for patients and returns a response with data or a 'no patients found' message.
Create and Get Patients9:25
Create a patient from the request body, insert into the database, and return the created patient; fetch a patient by id with not found and error handling.
Update Patient7:40
Delete Patient5:02
Learn how to delete a patient in a Node.js API with MySQL, checking affected rows for success, handling not found cases, and wiring routes and controller logic.

Docker Intro2:30
Docker Compose9:29
Define a Docker Compose service for a MySQL 8.0 master database, configure environment, volumes, port mappings, an init script, and a dedicated network to connect apps.
Running Container8:58
Test the docker compose setup, verify no errors, then connect to the mysql server on localhost:306, inspect patients db and patients table, and load configuration from the env file.

Requirements

Familiarity with JavaScript
Familiarity with NodeJs
Basic knowledge of Docker

Description

In this course, you will learn and understand how to create a NodeJs back-end API that will connect to a MySQL database server. Then use Docker to dockerize the application. You will also deploy the API using AWS Cloud.

This course teaches how to use create an API from scratch. This course also dives into defining and creating API, exposing API Endpoints over HTTP, and handling HTTP Requests and File Upload through API Endpoints. It covers testing API Endpoints (using an HTTP client - Postman).

This course is short and focuses only building the API and integrating it with persistence using MySQL Database Server. If you would like to learn more and build a full stack application and see how of this in practice, and way much more, please refer to my other course on Udemy, JSON Web Token (JWT) with Spring Security And Angular.

Who this course is for:

Developers wanting to learn about API, how they work, and build one
Beginner or advanced developers wanting to learn about APIs and build one from scratch using NodeJs, and the Express with database integration

NodeJs API with MySQL and Docker

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 21min

Database Setup2 lectures • 14min

HTTP Response2 lectures • 8min

Utilities3 lectures • 23min

Controller4 lectures • 27min

Routes2 lectures • 11min

Docker3 lectures • 21min

Testing1 lecture • 7min

Stored Procedure2 lectures • 19min

Dockerize NodeJs API2 lectures • 18min

Requirements

Description

Who this course is for: