Restful API Web Services with PHP, POSTMAN and MySQL: Bootcamp

Restful API Web Services with PHP, POSTMAN and MySQL: Bootcamp

Dive deep into the world of web development with our comprehensive Bootcamp on Restful API Web Services with PHP, POSTMAN, and MySQL. This course is meticulously designed to guide you through the basics to advanced techniques in building and managing APIs, alongside robust database management with MySQL. Enhance your skills with practical projects and learn how to integrate CSS for front-end development.

Learning Outcomes:

• Understand the fundamental concepts of APIs and their importance in modern web services.
• Gain proficiency in CSS from basic to expert levels for effective front-end styling.
• Master the principles of Restful API development and its applications.
• Implement Restful API authentication with MySQL in a project.
• Master MySQL management, including data filtering, functions, joins, and advanced commands.
• Develop the ability to create, query, and manage MySQL database structures effectively.
• Explore web API services and their implementation in real-world scenarios.
• Practice data backup and restoration techniques in MySQL to ensure data integrity and availability.

Key Employment Opportunities:

• API Developer: Yearly £18,000 to £30,000 approx
• Senior PHP Developer: Yearly £36,000 to £60,000 approx
• SQL Developer: Yearly £35,000 to £70,000 approx

More Benefits:

• Assignment on the Mastering API course
• Free Digital Reed Certificate on Mastering API course
• Compatible with iPhone & Android Devices
• Moneyback Guarantee

Empower UK Diploma Certificate

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: 13 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: 522 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: Update Record Using Restful API 05:04
  • 83: 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:04:40

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

• MySQL functions 46:00

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

• MySQL joins 1:04:40

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

• MySQL advanced commands 1:13:16

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

• MySQL structure creation 35:22

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

• MySQL data queries 22:02

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

• MySQL structure queries 14:50

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

• MySQL constraints 17:08

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

• MySQL backup and restore 24:19

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

• Mastering API - Course Assignment 12:00

  • 140: Mastering API - Course Assignment 01:00
  • 141: Course Assignment Worksheet 10:00
  • 142: Empower UK Submit Your Assignment 01:00

• Bonus - Workplace Management Toolkit 23:18

  • 143: The Workplace Management Toolkit Promo Preview 00:18
  • 144: Workplace Management Toolkit 23:00

Key Lesson Snippets:

• Introduction to APIs: Learn the basics of APIs, focusing on their role and significance in web services.
• CSS Basic to Expert: Progress through various levels of CSS to master styling and layout techniques for web development.
• Restful API Introduction and Basics: Understand the core concepts and frameworks of Restful API development.
• Project1: Restful API Authentication: Implement an API with secure authentication mechanisms using PHP.
• Project2: Restful API - MySQL: Learn to connect APIs with MySQL databases to manipulate and manage data effectively.
• Restful API – Web API Services: Explore advanced API functionalities and their applications in creating comprehensive web services.
• MySQL Introduction to Advanced Commands: Cover all aspects of MySQL, from basic introductions to complex queries and advanced database management.
• MySQL Structure Creation and Queries: Dive into the architectural aspects of MySQL, learning how to design, create, and query database structures.
• MySQL Constraints, Backup, and Restore: Understand the importance of database integrity through constraints and learn the procedures for backing up and restoring MySQL databases.

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