Build a RESTful API with Node.js, Express and PostgreSQL
What you'll 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
Requirements
- Basic knowledge of JavaScript
- Basic knowledge of Node
- Basic knowledge of Express
- Basic knowledge of SQL
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
Who this course is for:
- Beginners to REST ApI
Instructor
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.