Create Restful Apis Using Php, Postman And Mysql: Secure Api

Build dynamic database-backed Restful web APIs.. Use CSS, PHP, MySQL to build web services JWT and CRUD applications.

What 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
Requirements
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
Description
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, Secure Restful APIs PHP Coding and MySQL Training course is designed for you with the complete steps to require learn Complete Developer topics. Mr. Sekhar Metla [MCP - Microsoft Certified Professional] will explain to you even complex topics to simplify and teach you even beginners can easily understand with real-time examples.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.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 StylesFront-End Web DevelopmentClient-side style codeInternal CSSExternal CSSBox ModelFormsCardsResponsiveLayout designColorsFontsForm beautificationand more..Restful APIs CodingReal-world projectsSource-CodePOSTMAN appGETPOSTPUTDELETESecure REST APIsJSON Web Tokens and OauthLogin FormRegistration FormAuthorizationCode DevelopmentWeb DesignCRUD functionsand more..MySQLInstallationDatabaseTablesSQL functionsSQL statementsSQL operatorsSQL joinsSQL advancedTimestampFiltering dataAnalyzing dataGrouping dataConstraintsReportsBackup and Restoreand more..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 LecturesCode Challenges and Coding ExercisesBeautiful Real-World dynamic ProjectsABOUT YOUR INSTRUCTORSekhar 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.What are you waiting join now to start learning how to make your own APIs Developer Career TODAY :)

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 How to ask a great questions

Lecture 3 Introduction CSS

Lecture 4 Choosing Code Editor

Lecture 5 Installing Code Editor (Sublime Text)

Lecture 6 CSS Syntax

Lecture 7 Creating a first page with CSS Style

Section 2: CSS Basic

Lecture 8 Inline CSS

Lecture 9 Internal CSS

Lecture 10 External CSS

Lecture 11 CSS Classes

Lecture 12 CSS IDs

Lecture 13 Colors

Lecture 14 Backgrounds

Lecture 15 Floating

Lecture 16 Positioning

Lecture 17 Margins

Lecture 18 Padding

Lecture 19 Borders

Section 3: CSS Intermediate

Lecture 20 Styling Text

Lecture 21 Aligning Text

Lecture 22 Styling Links

Lecture 23 Font Family

Lecture 24 Font Styles

Lecture 25 Applying Google Fonts

Lecture 26 Box Model

Lecture 27 Icons

Lecture 28 Tables

Lecture 29 Navigation-Menu

Lecture 30 Dropdowns

Section 4: CSS Advanced

Lecture 31 Advanced Selectors

Lecture 32 Forms

Lecture 33 Website Layout

Lecture 34 Rounded Corners

Lecture 35 Color Keywords

Lecture 36 Animations

Lecture 37 Pseudo Classes

Lecture 38 Gradients

Lecture 39 Shadows

Lecture 40 Calculations

Lecture 41 Creating Responsive Page

Section 5: CSS Expert

Lecture 42 Button Styles

Lecture 43 Pagination

Lecture 44 Multiple Columns

Lecture 45 Image Reflection

Lecture 46 UI - UX Design

Lecture 47 Social Media Icons

Lecture 48 External CSS Style adding

Section 6: Restful API Introduction

Lecture 49 Section Introduction

Lecture 50 Installing XAMPP for PHP, MySQL and Apache

Lecture 51 Installing Code Editor(Visual Studio Code)

Lecture 52 Postman API platform installation

Lecture 53 Composer installation

Lecture 54 Creating PHP Project on XAMPP

Lecture 55 Hello World Program

Section 7: Restful API Basic

Lecture 56 What is PHP

Lecture 57 What is Restful API

Lecture 58 HTTP request GET, POST, PUT or DELETE

Lecture 59 REST API project structure

Section 8: Project1: Restful API Authentication

Lecture 60 Create Database and table

Lecture 61 Creating Project forms and folders

Lecture 62 Database Connection

Lecture 63 JSON Web Token Handler(JWT)

Lecture 64 Auth Middleware Token Validation

Lecture 65 Register form

Lecture 66 Login form

Lecture 67 User Token Authorization check form

Section 9: Project2: Restful API - MySQL

Lecture 68 Create Database and table

Lecture 69 Adding Data to table - insert query

Lecture 70 MySQL Select query

Lecture 71 MySQL Update query

Lecture 72 MySQL Delete query

Lecture 73 Get Project2 Source Code

Lecture 74 Create Database Connection

Section 10: Restful API – Web API Services

Lecture 75 Create Items Class PHP File

Lecture 76 Create Method form

Lecture 77 Creating Record Using Restful API

Lecture 78 Reading Method form

Lecture 79 Reading Record Using Restful API

Lecture 80 Update Method form

Lecture 81 Update Record Using Restful API

Lecture 82 Delete Method form

Lecture 83 Delete Method Using Restful API

Lecture 84 Coding Exercise

Lecture 85 Solution for Coding Exercise

Lecture 86 SEO friendly Request URLs of REST API

Section 11: MYSQL introduction

Lecture 87 Overview of Databases

Lecture 88 MySQL Installation

Lecture 89 MySQL Workbench Installation

Lecture 90 Connecting to MySQL using Console

Section 12: MySQL basic

Lecture 91 Overview of Challenges

Lecture 92 SQL Statement Basic

Lecture 93 SELECT Statement

Lecture 94 SELECT DISTINCT

Lecture 95 Column AS Statement

Lecture 96 COUNT function

Section 13: MySQL filtering data

Lecture 97 SELECT WHERE Clause – One

Lecture 98 SELECT WHERE Clause – Two

Lecture 99 ORDER BY

Lecture 100 LIMIT

Lecture 101 BETWEEN

Lecture 102 IN Operator

Lecture 103 LIKE and ILIKE

Section 14: MySQL functions

Lecture 104 Overview of GROUP BY

Lecture 105 Aggregation function SUM()

Lecture 106 Aggregation MIN() and MAX()

Lecture 107 GROUP BY - One

Lecture 108 GROUP BY – Two

Lecture 109 HAVING Clause

Section 15: MySQL joins

Lecture 110 Overview Assessment

Lecture 111 Overview of JOINS

Lecture 112 Introduction to JOINS

Lecture 113 AS Statement table

Lecture 114 INNER JOIN

Lecture 115 FULL Outer Join

Lecture 116 LEFT Outer JOIN

Lecture 117 RIGHT JOIN

Lecture 118 Union

Section 16: MySQL advanced commands

Lecture 119 Advanced SQL Commands

Lecture 120 Timestamps

Lecture 121 EXTRACT from timestamp

Lecture 122 Mathematical Functions

Lecture 123 String Functions

Lecture 124 SUBQUERY

Section 17: MySQL structure creation

Lecture 125 Database and Tables

Lecture 126 Data Types

Lecture 127 Primary key and Foreign key

Lecture 128 Create Table in SQL Script

Section 18: MySQL data queries

Lecture 129 Insert

Lecture 130 Update

Lecture 131 Delete

Section 19: MySQL structure queries

Lecture 132 Alter Table

Lecture 133 Drop Table

Section 20: MySQL constraints

Lecture 134 NOT NULL Constraint

Lecture 135 UNIQUE Constraint

Section 21: MySQL backup and restore

Lecture 136 Overview of Databases and Tables

Lecture 137 Backup database using phpMyAdmin

Lecture 138 Restoring a Database

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