Build and Test REST API’s Using: Node.js | Express.js | Python | Django | Postman | PostgreSQL | SQL | MySQL

What you will learn

Build a REST API with Node,Express and PostgreSQL

Build REST API with Python, Django and MySQL

Connect to database with Psql

Create database and table

Setup express server

Connect database to node

Create routes

Create endpoints

Test API with Postman


API is the acronym for Application Programming Interface, which is a software intermediary that allows two applications to talk to each other. Each time you use an app like Facebook, send an instant message, or check the weather on your phone, you’re using an API.

API engineers design, develop, implement, oversee, and adapt APIs – application programming interfaces – for a number of different types of organizations in business, education, science, and other fields in which data queries are made via internet and cloud platforms.

These engineers usually develop APIs using a technology called REST. REST is an acronym for ‘representational state technology.’ Applications created using this technology are referred to as RESTful APIs. API engineers use RESTful APIs to create any number of individual applications and products for an organization. API engineers code in a number of different computer languages that are portable or non-platform dependent, such as Java, Ruby, Scala, JavaScript, as well as hypertext protocol markup language (HTML) for web pages. An API engineer will write code and incorporate existing APIs into that code, or the engineer may write an original API specific to the organization’s needs.

Because APIs serve a number of different organization types, API engineers also consult with the organization’s experts. For example, an API engineer working for a large retail chain will consult with marketing and sales to develop APIs that are specific to those fields and that particular organization. Engineers are also involved in data security and work closely with data security measures and protocols, such as user access control and token management, to protect both the organization from threats and exploits and the end users from experiencing any type of cyber attack. With cloud services rapidly rising on the internet, API engineers work to make cloud data transfers and tasks more efficient by overseeing the data warehouse as well as ensuring that background tasks perform as expected.





Course Introduction

What is an API

What is a REST API

What is Node

What is Express

What is Python

What is Django

What is PostgreSQL

What is SQL

Environment Setup Installations

Installing Python on Windows

Installing Python on Macs

Installing Python on Linux | Ubuntu

Installing Django

Installing PostgreSQL on Windows

Installing PostgreSQL on Macs

Installing PostgreSQL on Linux

Install MySQL

MySQL Workbench

Installing Node

What is NPM

Updating NPM

Installing Text Editor

Installing Postman

What is http

Http Request Methods

Http Response Status Codes

Get Instant Notification of New Courses on our Telegram channel.

Testing Http Request Methods

Build A REST API with Node ,Express and PostgreSQL

Connect to database with Psql Shell

Create a new user account on database

Create a new database

Create a table

Insert data into database

Create a package.json file

Installing Express

Installing node-postgres connector

Creating index.js file (app file)

Starting express server

Connect database to node

Create route to get all data from database table

Create route to get a single record from database table

Create route to add new record to database

Create route to Update a single record in database

Create route to delete record from database

Export route functions

Create endpoints

Test API using Postman

Download Resource Files

Build a REST API with Python ,Django ,MySQL

Create and activate a virtual environment

Install Django

Install REST framework

Install Corsheaders

Create a Django Project

Create a Django App

Register Django app

Django MySQL Database Setup

Initial Migration

Create a Django Model

Creating and applying new migration

Creating a serializer class

Start and stop Django server

Create super user account

Create views: Part 1

Create views: Part 2

Maping views to URLS

Register Model with Admin Site

Create model objects

Test API

Download Source Code