learn@excellence.institute

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.

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

Contents Not Found