Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API

In this course, we will learn the basic tools that every Web developer needs to know. We will start from the scratch by learning how to implement web APIs development with CSS, Restful APIs Coding and MySQL.

Learn to code CSS, Restful APIs Coding and MySQL database is The first step to Coding you need to learn to succeed in web development, it is easy to learn and understand our online CSS design, Restful APIs PHP Coding and MySQL Training course is designed for you with the complete steps to require learn Complete Developer topics.

At this Development course is without a doubt the most comprehensive API development course available online. Even if you have zero programming experience on API, this course will take you from beginner to mastery. Here's why:

The course is taught by the lead instructor having 20+ years of professional experience.

Become a Web Developer with just ONE course. Developers complete course for web design, development with front-end design, coding and database queries!

The course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Apple, Facebook, Google and Netflix.

The curriculum was developed over a period of four years, with comprehensive student testing and feedback who are working and applying these coding examples.

We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startup.

We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web developer. You'll learn:

Build coding for Secure Restful APIs
Get a job as a junior web API developer
Create your own stunning, layouts for awesome websites
Start their own online business
Master client-end design using CSS3, back-end development Restful API, PHP coding with MySQL
Apply JSON Object, RestFul API, MySQL and CSS3 on real-world web service tasks
Create fully function web APIs apps using PHP Coding, MySQL and CSS

What are the requirements or prerequisites for taking your course?

Basic coding needed(optional). You will learn everything you need to know
No software is required in advance of the course (all software used in the course is free)
No pre-knowledge is required - you will learn from basic on APIs

Who is this course for?

Beginner Restful APIs, PHP coding, MySQL and CSS developers curious about APIs development
Anyone who wants to generate new income streams
Anyone who wants to build Secure Restful web APIs
Anyone who wants to become financially independent
Anyone who wants to start their own business or become freelance
Anyone who wants to become a API stack web developer

By the end of this course, you will be fluently programming and be ready to make any website you can dream of.
Sign up today, and look forward to:
HD Video Lectures
Code Challenges and Coding Exercises
Beautiful Real-World dynamic Projects

Course content

21 sections • 139 lectures • 17hrs 15mins

CSS Introduction 34mins

Introduction - 02mins

How to ask a Great Questions - 01mins

Introduction CSS - 06mins

Choosing Code Editor - 03mins

Installing Code Editor (Sublime Text) - 03mins

CSS Syntax - 04mins

Creating a first page with CSS Style - 12mins

CSS Basic 01hrs 17mins

Inline CSS - 05mins

Internal CSS - 05mins

External CSS - 09mins

CSS Classes - 09mins

CSS IDs - 06mins

Colors - 08mins

Backgrounds - 03mins

Floating - 08mins

Positioning - 05mins

Margins - 07mins

Padding - 03mins

Borders - 03mins

CSS Intermediate 01hrs 37mins

Styling Text - 06mins

Aligning Text - 03mins

Styling Links - 10mins

Font Family - 07mins

Font Styles - 03mins

Applying Google Fonts - 07mins

Box Model - 08mins

Icons - 08mins

Tables - 15mins

Navigation-Menu - 11mins

Dropdowns - 15mins

CSS Advanced 01hrs 24mins

Advanced Selectors - 05mins

Forms - 16mins

Website Layout - 20mins

Rounded Corners - 08mins

Color Keywords - 05mins

Animations - 07mins

Pseudo Classes - 03mins

Gradients - 02mins

Shadows - 03mins

Calculations - 05mins

Creating Responsive Page - 06mins

CSS Expert 44mins

Button Styles - 06mins

Pagination - 06mins

Multiple Columns - 05mins

Image Reflection - 02mins

UI - UX Design - 09mins

Social Media Icons - 07mins

External CSS Style adding - 05mins

Restful API Introduction 39mins

Section Introduction - 02mins

Installing XAMPP for PHP, MySQL and Apache - 12mins

Installing Code Editor(Visual Studio Code) - 06mins

Postman API platform installation - 05mins

Composer installation - 04mins

Creating PHP Project on XAMPP - 03mins

Hello World Program - 05mins

Restful API Basic 27mins

What is PHP - 08mins

What is Restful API - 05mins

HTTP request GET, POST, PUT or DELETE - 05mins

REST API project structure - 06mins

HTTP request GET, POST, PUT or DELETE - 08mins

Project1: Restful API Authentication 01hrs 47mins

Create Database and table - 06mins

Creating Project forms and folders - 05mins

Database Connection - 12mins

JSON Web Token Handler(JWT) - 13mins

Auth Middleware Token Validation - 22mins

User Token Authorization check form - 12mins

Project2: Restful API - MySQL 25mins

Create Database and table - 06mins

Adding Data to table - insert query - 03mins

MySQL Select query - 05mins

MySQL Update query - 03mins

MySQL Delete query - 01mins

Get Project2 Source Code - 02mins

Create Database Connection - 01mins

Restful API – Web API Services 34mins

Create Items Class PHP File - 04mins

Create Method form - 04mins

Creating Record Using Restful API - 04mins

Reading Method form - 02mins

Reading Record Using Restful API - 02mins

Update Method form - 02mins

Update Record Using Restful API - 05mins

Delete Method form - 01mins

Delete Method Using Restful API - 01mins

Coding Exercise - 50secs

Solution for Coding Exercise - 01mins

SEO friendly Request URLs of REST API - 02mins

MYSQL introduction 44mins

Overview of Databases - 10mins

MySQL Installation - 15mins

MySQL Workbench Installation - 09mins

Connecting to MySQL using Console - 09mins

MySQL basic 56mins

Overview of Challenges - 03mins

SQL Statement Basic - 15mins

SELECT Statement - 09mins

SELECT DISTINCT - 04mins

Column AS Statement - 11mins

COUNT function - 11mins

MySQL Filtering Data 01hrs 04mins

SELECT WHERE Clause – One - 04mins

SELECT WHERE Clause – Two - 10mins

ORDER BY - 07mins

LIMIT - 08mins

BETWEEN - 11mins

IN Operator - 10mins

LIKE and ILIKE - 11mins

MySQL Functions 46mins

Overview of GROUP BY - 05mins

Aggregation function SUM() - 08mins

Aggregation MIN() and MAX() - 05mins

GROUP BY - One - 09mins

GROUP BY – Two - 11mins

HAVING Clause - 05mins

MySQL Joins 01hrs 04mins

Overview Assessment - 01mins

Overview of JOINS - 03mins

Introduction to JOINS - 04mins

AS Statement table - 03mins

INNER JOIN - 18mins

FULL Outer Join - 11mins

LEFT Outer JOIN - 07mins

RIGHT JOIN - 07mins

Union - 06mins

MySQL Advanced Commands 01hrs 13mins

Basic of Advanced SQL Commands - 03mins

Timestamps - 12mins

EXTRACT from timestamp - 09mins

Mathematical Functions - 11mins

String Functions - 22mins

SUBQUERY - 13mins

MySQL Structure Creation 35mins

Basic of Database and Tables - 06mins

DataTypes - 10mins

Primarykey and Foreignkey - 05mins

Create Table in SQL Script - 13mins

MySQL Data Queries 22mins

Insert - 10mins

Update - 07mins

Delete - 04mins

MySQL structure queries 14mins

Alter Table - 09mins

Drop Table - 05mins

MySQL constraints 17mins

NOT NULL Constraint - 07mins

UNIQUE Constraint - 09mins

MySQL backup and restore 24mins

Overview of Databases and Tables - 04mins

Backup database using phpMyAdmin - 12mins

Restoring a Database - 07mins

The course includes HD video tutorials and builds your programming knowledge while making real-world websites and web apps.

Throughout this comprehensive course, we cover a massive amount of tools and technologies, including:
CSS Styles
Front-End Web Development
Client-side style code
Internal CSS
External CSS
Box Model
Forms
Cards
Responsive
Layout design
Colors
Fonts
Form beautification
and more..

Restful API Coding
Real-world projects
Source-Code
POSTMAN app
GET
POST
PUT
DELETE
Secure REST APIs
JSON Web Tokens and Oauth
Login Form
Registeration Form
Authorization
Code Development
Web Design
CRUD functions
and more..

MySQL
Installation
Database
Tables
SQL functions
SQL statements
SQL operators
SQL joins
SQL advanced
Timestamp
Filtering data
Analyzing data
Grouping data
Constraints
Reports
Backup and Restore
and more..

Sekhar Metla

Sekhar Metla is a software engineer with 20 years of professional experience. He is the author of several online-selling courses with more than 30,000+ students in many countries. He has a Master of Science in Computer Applications as Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.