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

Build a RESTful API with Node.js, Express and PostgreSQL, available at $44.99, has an average rating of 4.3, with 34 lectures, based on 114 reviews, and has 4492 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners to REST ApI It is particularly useful for Beginners to REST ApI.

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

Summary

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

Price: $44.99

Average Rating: 4.3

Number of Lectures: 34

Number of Published Lectures: 33

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 33

Original Price: $69.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginners to REST ApI

Target Audiences

Beginners to REST ApI

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 Expressserver 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: What is an API

Lecture 3: What is Node.js

Lecture 4: What is Express

Lecture 5: What is PostgreSQL

Lecture 6: What is SQL

Chapter 2: Installations

Lecture 1: Installing PostgreSQL

Lecture 2: Installing Node.js

Lecture 3: Updating NPM

Lecture 4: Installing ATom

Lecture 5: Installing nodemon

Lecture 6: Installing Postman

Chapter 3: Database Setup

Lecture 1: Connecting to database from Psql Shell

Lecture 2: Creating a new role ( user account) on PostgresQL

Lecture 3: Create a new database

Lecture 4: Create a table

Lecture 5: Inserting Data into database

Chapter 4: Setting up Express Server

Lecture 1: Creating a package.json file

Lecture 2: Installing Express

Lecture 3: Installing node-postgres (pg)

Lecture 4: Creating application file (index.js)

Lecture 5: Starting Express Server

Lecture 6: Connecting to database from Node.js

Chapter 5: Creating Route Functions

Lecture 1: Create Route to Get all data from database table

Lecture 2: Create Route to Get a single record from database table

Lecture 3: Create Route to Add a new record to database table

Lecture 4: Create Route to UPDATE a single record from database table

Lecture 5: Create Route to DELETE a record from database table

Lecture 6: Exporting Route Functions

Lecture 7: Creating endponts for Route Functions

Lecture 8: Testing API with Postman

Lecture 9: Project Code

Lecture 10: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 4 votes
2 stars: 8 votes
3 stars: 25 votes
4 stars: 42 votes
5 stars: 35 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu