Skip to content
Restful API Web Services with PHP, POSTMAN and MySQL: Bootcamp cover image
Play overlay
Preview this course

Restful API Web Services with PHP, POSTMAN and MySQL: Bootcamp
Empower UK Employment Training

100% Pass Rate | Assignment Included in Course Price | Free Certificate | Lifetime Course Access

Summary

Price
£19 inc VAT
Study method
Online, On Demand
Duration
18 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Empower UK Diploma Certificate - Free
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students
4 students purchased this course

Add to basket or enquire

Buy with Apple Pay Buy with Google Pay

Overview

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

Certificates

Empower UK Diploma Certificate

Digital certificate - Included

You must submit the assignment to order the Free Empower UK Diploma Certificate.
* Assessment Fee: £5

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

23
sections
144
lectures
17h 59m
total

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

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

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

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

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

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

Course media

Description

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.

Questions and answers

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

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Web development, PHP, MySQL, Web design, Coding, IT
Related searches: Design courses, Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.