Courses›Backend Development
Backend Development

PHP & MySQL Backend Development

Build secure PHP/MySQL applications with PDO, authentication, CRUD, uploads and deployment practices.

IntermediateLevel 23Lessons 23.9hLearning time 0Learners

Course overview

About this course

A practical backend course focused on PHP 8+, MySQL/MariaDB and PDO. Learners build server-rendered applications, process forms, validate input, model relational data, implement authentication and roles, handle files, use transactions, improve security and deploy a capstone application.

Learning outcomes

What you will be able to work on

Implement secure login, sessions and role-aware access.
Build create, read, update and delete application workflows.
Handle uploaded files with validation, safe naming and storage controls.
Design relational data and query it with SQL.
Connect PHP to databases safely using PDO and prepared statements.
Prepare and deploy PHP/MySQL applications safely.

Skills you build

Practical capabilities mapped to this course

9 mapped skills
Authentication & SessionsBackend Development · Target level 4/5
CRUD Application DevelopmentBackend Development · Target level 4/5
File UploadsBackend Development · Target level 4/5
MySQL DatabasesBackend Development · Target level 4/5
PDO & Prepared StatementsBackend Development · Target level 4/5
PHP DeploymentBackend Development · Target level 4/5
PHP Forms & ValidationBackend Development · Target level 4/5
PHP FundamentalsBackend Development · Target level 4/5
Web Application SecurityBackend Development · Target level 4/5

Before you start

Requirements & preparation

  • A laptop or suitable computer
  • Basic computer literacy
  • A modern web browser
  • Time to practise outside live sessions

Curriculum

Modules and lessons

8 modules · 23 lessons
01
Module 1: PHP FoundationsUnderstand server-side execution and core PHP syntax. · 3 lessons
+

How PHP Applications Work45 min · Preview

Open

Variables, Arrays & Control Flow50 min

Locked

Functions & Reusable Includes55 min

Locked
02
Module 2: HTTP & FormsHandle browser input safely and predictably. · 3 lessons
+

GET, POST & Request Data50 min · Preview

Open

Validation & Output Escaping60 min

Locked

Sessions, Flash Messages & CSRF65 min

Locked
03
Module 3: MySQL & Relational DesignDesign and query structured application data. · 3 lessons
+

Relational Database Basics55 min

Locked

SQL CRUD60 min

Locked

Joins & Aggregation60 min

Locked
04
Module 4: PDO & Data AccessConnect PHP to MySQL securely. · 3 lessons
+

PDO Connection & Configuration55 min

Locked

Prepared Statements65 min

Locked

Transactions65 min

Locked
05
Module 5: Authentication & RolesProtect accounts and authorise application actions. · 3 lessons
+

Password Hashing & Login70 min

Locked

Roles & Authorization60 min

Locked

Login Security60 min

Locked
06
Module 6: CRUD Application ArchitectureBuild maintainable admin and user workflows. · 3 lessons
+

CRUD Pages with PDO75 min

Locked

File Uploads70 min

Locked

Pagination & Search65 min

Locked
07
Module 7: Security & Production QualityReduce common application risks before deployment. · 3 lessons
+

Web Security Essentials65 min

Locked

Errors, Logging & Audit Trails55 min

Locked

Deployment Checklist50 min

Locked
08
Module 8: CapstoneBuild a complete secure PHP/MySQL application. · 2 lessons
+

Capstone Architecture50 min

Locked

PHP/MySQL Capstone130 min

Locked

Practical evidence

Projects & assessments

Practical Project

Secure PHP/MySQL Management Application

Build a complete role-based PHP/MySQL application for a realistic use case. It must include authentication, PDO prepared statements, relational CRUD, validation, CSRF protection, …

Module Check

Module 1: PHP Foundations — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 2: HTTP & Forms — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 3: MySQL & Relational Design — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 4: PDO & Data Access — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 5: Authentication & Roles — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 6: CRUD Application Architecture — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 7: Security & Production Quality — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Module Check

Module 8: Capstone — Knowledge Check

Pass mark: 60.00% · Time: 10 minutes

Final Exam

PHP & MySQL Backend Development — Comprehensive Final Assessment

Pass mark: 70.00% · Time: 30 minutes

Verified learner feedback

What completed learners say

No public verified reviews yet. Reviews unlock only after a learner completes this course.

Certificate pathway

Complete the required work and meet the course pass mark.

Eligible learners can receive a Flycoded Academy certificate after completing published course requirements and reaching the certificate pass mark of 70%.

How certificates work →

Course FAQ

Questions before enrolment

Is this course suitable for beginners?

The course level is listed as Intermediate. Review the requirements above and contact Flycoded if you are unsure whether it matches your current experience.

Will I have practical work?

Flycoded Academy is structured around practice. This course currently lists 1 practical project(s) and 9 assessment(s), in addition to its lessons.

How do I access live classes?

Scheduled live classes appear through the Academy timetable and may use Google Meet or Zoom depending on the program.

Can I replay a class?

When an instructor publishes a recording for this course, enrolled learners can watch it securely from the Recorded Classes library inside the Student portal.

How do I get a certificate?

Complete the required lessons and practical work, meet the assessment rules and reach the course certificate pass mark.