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

Skill Arts

• Introduction 44:37

  • 1: API: source code file 08:47
  • 2: API: Introduction 02:43
  • 3: API: How to ask a Great Questions 01:21
  • 4: Care for a Feedback 01:00
  • 5: API: Introduction CSS 06:01
  • 6: API: Choosing Code Editor 03:28
  • 7: API: Installing Code Editor (Sublime Text) 03:48
  • 8: API: CSS Syntax 04:59
  • 9: API: Creating a first page with CSS Style 12:30

• CSS Basic 1:18:08

  • 10: API: Inline CSS 05:56
  • 11: API: Internal CSS 05:23
  • 12: API: External CSS 09:55
  • 13: Care for a feedback! 01:00
  • 14: API: CSS Classes 09:24
  • 15: API: CSS IDs 06:14
  • 16: API: Colors 08:00
  • 17: API: Backgrounds 03:34
  • 18: API: Floating 08:38
  • 19: API: Positioning 05:53
  • 20: API: Margins 07:03
  • 21: API: Padding 03:52
  • 22: API: Borders 03:16

• CSS Intermediate 1:37:54

  • 23: API: Styling Text 06:34
  • 24: API: Aligning Text 03:58
  • 25: API: Styling Links 10:02
  • 26: API: Font Family 07:05
  • 27: API: Font Styles 03:14
  • 28: API: Applying Google Fonts 07:05
  • 29: API: Box Model 08:49
  • 30: API: Icons 08:42
  • 31: API: Tables 15:53
  • 32: API: Navigation-Menu 11:11
  • 33: API: Dropdowns 15:21

• CSS Advanced 1:24:29

  • 34: API: Advanced Selectors 05:01
  • 35: API: Forms 16:33
  • 36: API: Website Layout 20:53
  • 37: API: Rounded Corners 08:00
  • 38: API: Color Keywords 05:45
  • 39: API: Animations 07:33
  • 40: API: Pseudo Classes 03:00
  • 41: API: Gradients 02:51
  • 42: API: Shadows 03:29
  • 43: API: Calculations 05:13
  • 44: API: Creating Responsive Page 06:11

• CSS Expert 44:18

  • 45: API: Button Styles 06:04
  • 46: API: Pagination 06:55
  • 47: API: Multiple Columns 05:43
  • 48: API: Image Reflection 02:40
  • 49: API: UI - UX Design 09:11
  • 50: API: Social Media Icons 07:55
  • 51: API: External CSS Style adding 05:50

• Restful API Introduction 39:37

  • 52: API: Section Introduction 02:05
  • 53: API: Installing XAMPP for PHP, MySQL and Apache 12:05
  • 54: API: Installing Code Editor(Visual Studio Code) 06:33
  • 55: API: Postman API platform installation 05:36
  • 56: API: Composer installation 04:06
  • 57: API: Creating PHP Project on XAMPP 03:27
  • 58: API: Hello World Program 05:45

• Restful API Basic 27:38

  • 59: API: What is PHP 08:00
  • 60: API: What is Restful API 05:23
  • 61: API: HTTP request GET, POST, PUT or DELETE 08:02
  • 62: API: REST API project structure 06:13

• Project1: Restful API Authentication 1:47:19

  • 63: API: Create Database and table 06:01
  • 64: API: Creating Project forms and folders 05:04
  • 65: API: Database Connection 12:57
  • 66: API: JSON Web Token Handler(JWT) 13:57
  • 67: API: Auth Middleware Token Validation 22:42
  • 68: API: Register form 20:16
  • 69: API: Login form 14:11
  • 70: API: User Token Authorization check form 12:11

• Project2: Restful API - MySQL 25:00

  • 71: API: Create Database and table 06:10
  • 72: API: Adding Data to table - insert query 03:10
  • 73: API: MySQL Select query 05:35
  • 74: API: MySQL Update query 03:52
  • 75: API: MySQL Delete query 01:55
  • 76: API: Get Project2 Source Code 02:25
  • 77: API: Create Database Connection 01:53

• Restful API – Web API Services 33:57

  • 78: API: Create Items Class PHP File 04:26
  • 79: API: Create Method form 04:18
  • 80: API: Creating Record Using Restful API 04:24
  • 81: API: Reading Method form 02:10
  • 82: API: Reading Record Using Restful API 02:46
  • 83: API: Update Method form 02:44
  • 84: API: Update Record Using Restful API 05:04
  • 85: API: Delete Method form 01:37
  • 86: API: Delete Method Using Restful API 01:52
  • 87: API: Coding Exercise 00:50
  • 88: API: Solution for Coding Exercise 01:32
  • 89: API: SEO friendly Request URLs of REST API 02:14

• MYSQL introduction 44:16

  • 90: API: Overview of Databases 10:23
  • 91: API: MySQL Installation 15:49
  • 92: API: MySQL Workbench Installation 09:04
  • 93: API: Connecting to MySQL using Console 09:00

• MySQL basic 56:07

  • 94: API: Overview of Challenges 03:42
  • 95: API: SQL Statement Basic 15:30
  • 96: API: SELECT Statement 09:19
  • 97: API: SELECT DISTINCT 04:50
  • 98: API: Column AS Statement 11:43
  • 99: API: COUNT function 11:03

• MySQL filtering data 1:00:04

  • 100: API: SELECT WHERE Clause – Two 10:40
  • 101: API: ORDER BY 07:41
  • 102: API: LIMIT 08:34
  • 103: API: BETWEEN 11:18
  • 104: API: IN Operator 10:40
  • 105: API: LIKE and ILIKE 11:11

• MySQL functions 46:00

  • 106: API: Overview of GROUP BY 05:39
  • 107: API: Aggregation function SUM() 08:51
  • 108: API: Aggregation MIN() and MAX() 05:29
  • 109: API: GROUP BY - One 09:12
  • 110: API: GROUP BY – Two 11:45
  • 111: API: HAVING Clause 05:04

• MySQL joins 1:04:40

  • 112: API: Overview Assessment 01:59
  • 113: API: Overview of JOINS 03:35
  • 114: API: Introduction to JOINS 04:01
  • 115: API: AS Statement table 03:04
  • 116: API: INNER JOIN 18:29
  • 117: API: FULL Outer Join 11:10
  • 118: API: LEFT Outer JOIN 07:53
  • 119: API: RIGHT JOIN 07:45
  • 120: API: Union 06:44

• MySQL advanced commands 1:13:16

  • 121: API: Basic of Advanced SQL Commands 03:37
  • 122: API: Timestamps 12:22
  • 123: API: EXTRACT from timestamp 09:58
  • 124: API: Mathematical Functions 11:39
  • 125: API: String Functions 22:15
  • 126: API: SUBQUERY 13:25

• MySQL structure creation 35:22

  • 127: API: Basic of Database and Tables 06:09
  • 128: API: DataTypes 10:29
  • 129: API: Primarykey and Foreignkey 05:32
  • 130: API: Create Table in SQL Script 13:12

• MySQL data queries 22:02

  • 131: API: Insert 10:46
  • 132: API: Update 07:08
  • 133: API: Delete 04:08

• MySQL structure queries 14:50

  • 134: API: Alter Table 09:30
  • 135: API: Drop Table 05:20

• MySQL constraints 17:08

  • 136: API: NOT NULL Constraint 07:54
  • 137: API: UNIQUE Constraint 09:14

• MySQL backup and restore 24:19

  • 138: API: Overview of Databases and Tables 04:50
  • 139: API: Backup database using phpMyAdmin 12:27
  • 140: API: Restoring a Database 07:02

• Claim Your Free Certificate 01:00

  • 141: Claim Your Free Certificate 01:00

Create Restful APIs using PHP, POSTMAN and MySQL: Secure API Syllabus

Introduction:

• Understand the basics and significance of Restful APIs, PHP, POSTMAN, and MySQL in web development.

CSS Modules:

• CSS Basic:
  • Learn the fundamentals of CSS for styling web pages for API interfaces.
• CSS Intermediate:
  • Build on basic knowledge to create more complex styles for API front-ends.
• CSS Advanced:
  • Master advanced CSS techniques for sophisticated API designs.
• CSS Expert:
  • Achieve expert-level proficiency in CSS for professional-quality API web designs.

Restful API Modules:

• Restful API Introduction:
  • Gain an introduction to Restful APIs and their importance in modern web applications.
• Restful API Basic:
  • Learn the basic concepts and techniques for creating APIs using PHP.
• Project 1: Restful API Authentication:
  • Implement authentication mechanisms for secure APIs using PHP and POSTMAN.
• Project 2: Restful API - MySQL:
  • Integrate MySQL with Restful APIs for dynamic data management.
• Restful API – Web API Services:
  • Develop robust web API services using PHP and MySQL.

MySQL Modules:

• MySQL Introduction:
  • Understand the basics of MySQL database management for APIs.
• MySQL Basic:
  • Learn basic commands and operations for MySQL databases used in APIs.
• MySQL Filtering Data:
  • Master techniques for filtering data in MySQL for API responses.
• MySQL Functions:
  • Utilize MySQL functions to perform complex data manipulations for APIs.
• MySQL Joins:
  • Learn to combine data from multiple tables using joins for comprehensive API responses.
• MySQL Advanced Commands:
  • Gain proficiency in advanced MySQL commands for intricate data operations in APIs.
• MySQL Structure Creation:
  • Understand how to create and manage database structures for APIs.
• MySQL Data Queries:
  • Develop skills in querying data effectively for API functionalities.
• MySQL Structure Queries:
  • Learn to write queries that interact with the database structure for APIs.
• MySQL Constraints:
  • Implement constraints to ensure data integrity in APIs.
• MySQL Backup and Restore:
  • Master techniques for backing up and restoring MySQL databases used in APIs.

There are currently no Q&As for this course. Be the first to ask a question.