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

Why Study This Diploma in Creating Restful API - CPD Certified?

• A study by PwC UK found that API adoption grew by 200% in the UK between 2020 and 2023.
• According to Reed, job postings for "API Specialist" or "API Developer" have increased by 35% YoY in the UK (as of April 2024).
• A report by APImetrics states that globally, there were over 380 million public APIs available in 2023, with an estimated growth of 25% by 2025.

Learning Outcomes:

• Learn how to create and manage APIs using PHP and MySQL.
• Master CSS from basic to expert levels to enhance the front-end design of your API interfaces.
• Learn to implement authentication and security features in your APIs.
• Develop real-world applications that demonstrate your mastery of PHP, POSTMAN, and MySQL for API development.
• Learn to interact with MySQL databases, performing queries and managing data for your APIs.

CPDQE Accreditation

This Diploma in Creating Restful API is CPDQE accredited. CPD is a globally recognised parameter for continuous professional development acknowledged by thousands of professional bodies, employers and academic institutions in the UK and around the world.

Dual Certificates

After completing this Diploma in Creating Restful API Course, you will receive a course completion certificate from Reed. Also, you will receive a CPDQE-accredited signed certificate from SkillArts.

CPDQE Certificate on API training

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Introduction 43:37

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

• CSS Basic 1:17:08

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

• CSS Intermediate 1:37:54

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

• CSS Advanced 1:24:29

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

• CSS Expert 44:18

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

• Restful API Introduction 39:37

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

• Restful API Basic 27:38

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

• Project1: Restful API Authentication 1:47:19

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

• Project2: Restful API - MySQL 25:00

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

• Restful API – Web API Services 33:57

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

• MYSQL introduction 44:16

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

• MySQL basic 56:07

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

• MySQL filtering data 1:00:04

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

• MySQL functions 46:00

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

• MySQL joins 1:04:40

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

• MySQL advanced commands 1:13:16

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

• MySQL structure creation 35:22

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

• MySQL data queries 22:02

  • 129: API: Insert 10:46
  • 130: API: Update 07:08
  • 131: API: Delete 04:08

• MySQL structure queries 14:50

  • 132: API: Alter Table 09:30
  • 133: API: Drop Table 05:20

• MySQL constraints 17:08

  • 134: API: NOT NULL Constraint 07:54
  • 135: API: UNIQUE Constraint 09:14

• MySQL backup and restore 24:19

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

Diploma in Creating Restful API Course 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.

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