Sector-specific

Back-end development using PHP and MySQL

Programme 55 mins

Introduction

This training course Back-end development using PHP and MySQL provides a broad overview of two key technologies in the field of web development. PHP is one of the most widely used programming languages for creating dynamic websites and web applications, whilst MySQL is one of the relational database management systems the most popular and widely adopted.

The importance of these two technologies lies in their ability to work together synergistically and efficiently, enabling developers to build scalable, secure and highly functional applications.

Understanding development backend Knowledge of PHP and MySQL is essential for any web developer looking to build interactive and scalable web applications.

Objectives

  • Understanding the basic principles of PHP and its integration with MySQL.

  • Mastering the creation and validation of PHP forms.

  • Explore the main ones frameworks for backend development.

  • To familiarise yourself with Laravel and its features for web development.

  • Understanding the importance and functioning of the relational databases.

  • Learn how to install and configure PHPMyAdmin using XAMPP.

  • Practise SQL queries, including pre-arranged appointments and sanitisation techniques.

Table of Contents

VIDEO LESSON 1. INTRODUCTION TO PHP
VIDEO LESSON 2. FORMS IN PHP
VIDEO LESSON 3. MAJOR FRAMEWORKS IN DIFFERENT PROGRAMMING LANGUAGES
VIDEO LESSON 4. INTRODUCTION TO DEVELOPMENT WITH LARAVEL
VIDEO LESSON 5. THE IMPORTANCE OF STORING DATA IN A DATABASE
VIDEO LESSON 6. RELATIONAL DATABASE MANAGEMENT SYSTEMS (SQL)
VIDEO LESSON 7. INSTALLING AND CONFIGURING PHPMYADMIN WITH XAMPP
VIDEO LESSON 8. CREATING AN SQL DATABASE IN PHPMYADMIN
VIDEO LESSON 9. PLATFORMS FOR PRACTISING SQL
VIDEO LESSON 10. CREATING, MODIFYING AND DELETING DATABASES AND TABLES IN SQL
VIDEO LESSON 11. SQL QUERIES: SELECT, FILTERS AND GROUPINGS
VIDEO LESSON 12. SQL QUERIES: STORED QUERIES AND QUERY SANITISATION
VIDEO LESSON 13. EDITING DATA IN SQL: INSERT, DELETE AND UPDATE
VIDEO LESSON 14. BACKUPS, IMPORTS AND EXPORTS IN SQL
VIDEO LESSON 15. SQL QUERIES USING PHP
VIDEO LESSON 16. STORED QUERIES IN SQL

Your questions answered

Why choose Educa.Pro?

Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.

Can the courses be taken at your own pace?

Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.

What levels of security and compliance does the platform offer?

Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.

What support and guidance does Educa.Pro offer?

The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.

Scroll to Top