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
Description
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.
English
Language
Content
Introduction
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
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