Build a RESTful API with Node.js, Express and PostgreSQL

Create your own API server running on Node.js and hooked up to an active PostgreSQL database.

4.10 (104 reviews)
Udemy
platform
English
language
Web Development
category
Build a RESTful API with Node.js, Express  and PostgreSQL
4,444
students
2 hours
content
Mar 2023
last update
$44.99
regular price

What you will learn

Installing PostgreSQL, Nodejs and Express

Creating new database user account (role)

Creating database and table

Inserting data into database table

Connecting to database from nodejs application

Create Route Functions

Export functions

Create endpoints for CRUD operation on API

Testing API using Postman as API Client

Description

A useful and handy aspect of being a modern web developer is knowing how to work with APIs to facilitate communication between different software systems.

In this course, you’ll learn how to create your own RESTful API in a Node.js environment running on an Express server and utilizing a PostgreSQL database. We will use Postman as our API client to interact with the API Server.

REST stands for Representational State Transfer and defines a set of standards for web services.  It is an architectural style as well as an approach for communications purposes that is often used in various web services development.

An API is an interface that different software programs use to communicate with each other.

RESTful API is an API that conforms to the REST architectural style and constraints. REST systems are stateless, scalable,cacheable, and have a uniform interface.

RESTful APIs most commonly utilize HTTP requests.Four of the most common HTTP methods are :

GET, POST, PUT, and DELETE, which are the methods by which a developer can create a CRUD system – create, read, update, delete.  REST   it is an application program interface (API) that makes use of the HTTP requests to GET, PUT, POST and DELETE the data over WWW. (World Wide Web)

The main functions used in any REST-based architecture are:

GET − Provides read-only access to a resource.

PUT − Creates a new resource.

DELETE − Removes a resource.

POST − Updates an existing resource or creates a new resource.


You learn how to:

  • Create a new database user account

  • Create a database and a table

  • Insert data into database

  • Build an express server

  • Connect to PostgreSQL Database from Node application

  • Create Route Functions

  • Export  route functions into main application file

  • Create endpoints for route functions

  • Call the web API with Postman and perform CRUD operations


Content

Introduction

Introduction
What is an API
What is Node.js
What is Express
What is PostgreSQL
What is SQL

Installations

Installing PostgreSQL
Installing Node.js
Updating NPM
Installing ATom
Installing nodemon
Installing Postman

Database Setup

Connecting to database from Psql Shell
Creating a new role ( user account) on PostgresQL
Create a new database
Create a table
Inserting Data into database

Setting up Express Server

Creating a package.json file
Installing Express
Installing node-postgres (pg)
Creating application file
Starting Express Server
Connecting to database from Node.js

Creating Route Functions

Create Route to Get all data from database table
Create Route to Get a single record from database table
Create Route to Add a new record to database table
Create Route to UPDATE a single record from database table
Create Route to DELETE a record from database table
Exporting Route Functions
Creating endponts for Route Functions
Testing API with Postman
Project Code

Reviews

Dana
September 6, 2023
The course was just perfect for me and I learnt lots of new things. I wish you could add a section on how to fetch the data in the app and also to deploy the app to a server.
Caio
June 4, 2022
In the early sections, there were a few already created files that got me confused at first, but I just ignored the fact they were already there, since we didn't see how to create a node project yet
Romina
June 1, 2022
Por que no tiene el subtitulado en español. mi cuenta esta configurada como tal. Y no esta dentro de las opciones el cambio. Al menos siguiendo los pasos de la sección de FAQs no he tenido exito.
Aaron
May 24, 2022
A*** lectures. Concise, simple and straight to the point! He teaches you what you need in the simplest and most efficient manner!
Ali
May 2, 2022
Clear and concise approach, it will definitely help someone who's looking for applicable examples to glue his knowledge areas. Loved the basic way of putting up an application together. But it lacked some Express fundamentals like Express router!.
Raymond
April 26, 2021
The course was a quick intro to using PostgreSQL, Express, and Node. The approach of copying and pasting blocks of code and explaining the code was an interesting approach. It did require pausing the video in order to type the code myself and then go over the explanations. This course did not get into the Express router though, and it did not cover how to handle updates with partial data.
Chris
March 15, 2021
I believe the instructor needs to look at how other courses have been put together and gain some tips from them. His level of detail and step by step is good until section 21 and at this point if you are not comfortable already with node or programming you would begin to have difficulties. Minor format changes and a change of what should be in the main file that isn't explained causes issues. the files generated and zipped as a part of the class would help resolve and give you something to compare your work to. This is also a no frills exactly what the title says it is course. You are getting exactly $11 worth of training not a penny more. It is exactly what you can find reading online tutorials in which he's just added video and audio to them. In summary this comes off as a beginner instructor who needs to work on his craft. That said, you can accomplish exactly what the course is offering which is the only reason I'm not asking for a refund.
Richard
January 4, 2021
Key code never provided for index.js The instructor never responded to this question, and NO instructor information provided. Defective disappointing course and no support.
Nazarij
May 24, 2020
I am interested in the rest of the course, but one lecture was missing, in which some required functions were created. To follow the course I had to open the source code, which was at the end (31), and copy some of it. If it could be possible to correct the missing lecture, I would rate in higher. Also, It would be beneficial to post information about what lectures are offered and which course to do next.

Charts

Price

Build a RESTful API with Node.js, Express  and PostgreSQL - Price chart

Rating

Build a RESTful API with Node.js, Express  and PostgreSQL - Ratings chart

Enrollment distribution

Build a RESTful API with Node.js, Express  and PostgreSQL - Distribution chart

Related Topics

3050372
udemy ID
4/25/2020
course created date
5/4/2020
course indexed date
Angelcrc Seven
course submited by