Name: Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API
Price: 25 GBP

GET THIS COURSE AND 2500+ OTHERS FOR ONLY £49 FIND OUT MORE

Home
Curriculum

Overview:

Welcome to the “Create RESTful APIs using PHP, POSTMAN, and MySQL: Secure API” course! This comprehensive program is designed to equip participants with the essential skills and knowledge required to develop secure and efficient RESTful APIs using PHP, MySQL, and POSTMAN. In today’s digital landscape, RESTful APIs play a vital role in enabling communication between different systems and facilitating the exchange of data over the web. However, ensuring the security and integrity of these APIs is paramount to protect sensitive information and maintain the trust of users.

Interactive video lectures by industry experts
Instant e-certificate and hard copy dispatch by next working day
Fully online, interactive course with Professional voice-over
Developed by qualified first aid professionals
Self paced learning and laptop, tablet, smartphone friendly
24/7 Learning Assistance
Discounts on bulk purchases

Main Course Features:

Comprehensive introduction to RESTful APIs and their significance in modern web development.
Hands-on tutorials on building RESTful APIs using PHP and MySQL.
Practical exercises and demonstrations using POSTMAN for API testing and validation.
In-depth exploration of authentication and authorization mechanisms to secure APIs.
Best practices for designing RESTful API endpoints and handling HTTP requests and responses.
Strategies for implementing data validation, error handling, and exception management in APIs.
Guidance on deploying and maintaining secure APIs in production environments.
Real-world examples and case studies to illustrate the concepts and principles taught in the course.

Who Should Take This Course:

Web developers aspiring to enhance their skills in building RESTful APIs.
PHP developers interested in learning about API development using modern tools and frameworks.
Database administrators seeking to integrate MySQL databases with PHP-based APIs.
IT professionals and software engineers involved in web application development projects.

Learning Outcomes:

Gain a solid understanding of RESTful API architecture and design principles.
Develop secure and efficient RESTful APIs using PHP, MySQL, and POSTMAN.
Implement authentication and authorization mechanisms to protect APIs from unauthorized access.
Master the use of POSTMAN for API testing, debugging, and documentation.
Apply best practices for securing sensitive data and preventing common security vulnerabilities in APIs.
Design API endpoints that adhere to RESTful principles and promote scalability and maintainability.
Deploy and manage secure APIs in production environments with confidence.
Demonstrate proficiency in building RESTful APIs that meet industry standards and security requirements.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Course Curriculum

Module 01: CSS Introduction
	Introduction	00:03:00
	How to ask a great questions	00:01:00
	Introduction CSS	00:06:00
	Choosing Code Editor	00:03:00
	Installing Code Editor (Sublime Text)	00:04:00
	CSS Syntax	00:05:00
	Creating a first page with CSS Style	00:13:00
Module 02: CSS Basic
	Inline CSS	00:06:00
	Internal CSS	00:05:00
	External CSS	00:10:00
	CSS Classes	00:09:00
	CSS IDs	00:06:00
	Colors	00:08:00
	Backgrounds	00:04:00
	Floating	00:09:00
	Positioning	00:06:00
	Margins	00:07:00
	Padding	00:04:00
	Borders	00:03:00
Module 03: CSS Intermediate
	Styling Text	00:07:00
	Aligning Text	00:04:00
	Styling Links	00:10:00
	Font Family	00:07:00
	Font Styles	00:03:00
	Applying Google Fonts	00:07:00
	Box Model	00:09:00
	Icons	00:09:00
	Tables	00:16:00
	Navigation-Menu	00:11:00
	Dropdowns	00:15:00
Module 04: CSS Advanced
	Advanced Selectors	00:05:00
	Forms	00:17:00
	Website Layout	00:21:00
	Rounded Corners	00:08:00
	Color Keywords	00:06:00
	Animations	00:08:00
	Pseudo Classes	00:03:00
	Gradients	00:03:00
	Shadows	00:03:00
	Calculations	00:05:00
	Creating Responsive Page	00:06:00
Module 05: CSS Expert
	Button Styles	00:06:00
	Pagination	00:07:00
	Multiple Columns	00:06:00
	Image Reflection	00:03:00
	UI – UX Design	00:09:00
	Social Media Icons	00:08:00
	External CSS Style adding	00:06:00
Module 06: Restful API Introduction
	Section Introduction	00:02:00
	Installing XAMPP for PHP, MySQL and Apache	00:12:00
	Installing Code Editor(Visual Studio Code)	00:07:00
	Postman API platform installation	00:06:00
	Composer installation	00:04:00
	Creating PHP Project on XAMPP	00:03:00
	Hello World Program	00:06:00
Module 07: Restful API Basic
	What is PHP	00:08:00
	What is Restful API	00:05:00
	HTTP request GET, POST, PUT or DELETE	00:08:00
	REST API project structure	00:06:00
Module 08: Project 1: Restful API Authentication
	Create Database and table	00:06:00
	Creating Project forms and folders	00:05:00
	Database Connection	00:13:00
	JSON Web Token Handler(JWT)	00:14:00
	Auth Middleware Token Validation	00:23:00
	Register form	00:20:00
	Login form	00:14:00
	User Token Authorization check form	00:12:00
Module 09: Project 2: Restful API - MySQL
	Create Database and table	00:06:00
	Adding Data to table – insert query	00:03:00
	MySQL Select query	00:06:00
	MySQL Update query	00:04:00
	MySQL Delete query	00:02:00
	Get Project2 Source Code	00:02:00
	Create Database Connection	00:02:00
Module 10: Restful API – Web API Services
	Create Items Class PHP File	00:04:00
	Create Method form	00:04:00
	Creating Record Using Restful API	00:04:00
	Reading Method form	00:02:00
	Reading Record Using Restful API	00:03:00
	Update Method form	00:03:00
	Update Record Using Restful API	00:05:00
	Delete Method form	00:02:00
	Delete Method Using Restful API	00:02:00
	Coding Exercise	00:01:00
	Solution for Coding Exercise	00:02:00
	SEO friendly Request URLs of REST API	00:02:00
Module 11: MYSQL Introduction
	Overview of Databases	00:10:00
	MySQL Installation	00:16:00
	MySQL Workbench Installation	00:09:00
	Connecting to MySQL using Console	00:09:00
Module 12: MySQL Basics
	Overview of Challenges	00:04:00
	SQL Statement Basic	00:16:00
	SELECT Statement	00:09:00
	SELECT DISTINCT	00:05:00
	Column AS Statement	00:12:00
	COUNT function	00:11:00
Module 13: MySQL Filtering Data
	SELECT WHERE Clause – One	00:05:00
	SELECT WHERE Clause – Two	00:11:00
	ORDER BY	00:08:00
	LIMIT	00:09:00
	BETWEEN	00:11:00
	IN Operator	00:11:00
	LIKE and ILIKE	00:11:00
Module 14: MySQL Functions
	Overview of GROUP BY	00:06:00
	Aggregation function SUM()	00:09:00
	Aggregation MIN() and MAX()	00:05:00
	GROUP BY – One	00:09:00
	GROUP BY – Two	00:12:00
	HAVING Clause	00:05:00
Module 15: MySQL Joins
	Overview Assessment	00:02:00
	Overview of JOINS	00:04:00
	Introduction to JOINS	00:04:00
	AS Statement table	00:03:00
	INNER JOIN	00:18:00
	FULL Outer Join	00:11:00
	LEFT Outer JOIN	00:08:00
	RIGHT JOIN	00:08:00
	Union	00:07:00
Module 16: MySQL Advanced Commands
	Advanced SQL Commands	00:04:00
	Timestamps	00:12:00
	EXTRACT from timestamp	00:10:00
	Mathematical Functions	00:12:00
	String Functions	00:22:00
	SUBQUERY	00:13:00
Module 17: MySQL Structure Creation
	Database and Tables	00:06:00
	Data Types	00:10:00
	Primary key and Foreign key	00:06:00
	Create Table in SQL Script	00:13:00
Module 18: MySQL Data Queries
	Insert	00:11:00
	Update	00:07:00
	Delete	00:04:00
Module 19: MySQL Structure Queries
	Alter Table	00:10:00
	Drop Table	00:05:00
Module 20: MySQL Constraints
	NOT NULL Constraint	00:08:00
	UNIQUE Constraint	00:09:00
Module 21: MySQL Backup and Restore
	Overview of Databases and Tables	00:05:00
	Backup database using phpMyAdmin	00:12:00
	Restoring a Database	00:07:00