Ultimate PHP & MySQL Web Development Course & OOP Coding
Overview
Master PHP & MySQL by learning all the web development features for creating websites.
The Ultimate PHP & MySQL Web Development Course & OOP Coding course covers the A-Z of PHP programming, equipping learners with in-demand industry skills needed to develop websites and applications. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for those who are new to the field.
This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.
Why study this course
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Ultimate PHP & MySQL Web Development Course & OOP Coding is fully available to anyone, and no previous qualifications are needed to enrol. All Thames College needs to know is that you are eager to learn and are over 16.
Course Curriculum
| Section 01: Introduction & Setup | |||
| Introduction | 00:02:00 | ||
| Setup On Windows | 00:15:00 | ||
| Setup On Mac | 00:11:00 | ||
| Setup On Linux | 00:12:00 | ||
| Online Code Editor | 00:03:00 | ||
| Section 02: Basics | |||
| Basic File Syntax | 00:05:00 | ||
| Printing (echo) | 00:06:00 | ||
| Comments | 00:05:00 | ||
| Variables | 00:06:00 | ||
| Variable Data Types | 00:07:00 | ||
| Variable Naming | 00:03:00 | ||
| Constants | 00:02:00 | ||
| Arrays | 00:05:00 | ||
| Associative Arrays | 00:06:00 | ||
| Multidimensional Arrays | 00:04:00 | ||
| Section 03: Control Structures | |||
| if Statement | 00:06:00 | ||
| if…else Statement | 00:02:00 | ||
| if…elseif…else Statement | 00:05:00 | ||
| Switch Statement | 00:06:00 | ||
| while Loop | 00:06:00 | ||
| do…While Loop | 00:03:00 | ||
| for Loop | 00:03:00 | ||
| foreach Loop | 00:05:00 | ||
| Break Statement | 00:02:00 | ||
| Continue Statement | 00:02:00 | ||
| Section 04: Functions | |||
| Basic Function | 00:03:00 | ||
| Passing Function Arguments | 00:03:00 | ||
| Passing Function Arguments By Reference | 00:04:00 | ||
| Default Argument Value | 00:02:00 | ||
| Function Returning Values | 00:05:00 | ||
| Dynamic Function Calls | 00:03:00 | ||
| Variable Scope | 00:04:00 | ||
| Section 05: Forms | |||
| Simple HTML Form | 00:07:00 | ||
| GET vs POST | 00:05:00 | ||
| $_SERVER [“PHP_SELF”] | 00:07:00 | ||
| Validating Form Data With PHP | 00:07:00 | ||
| Required Fields | 00:05:00 | ||
| Display Error Messages | 00:05:00 | ||
| Validate Name | 00:03:00 | ||
| Validate Email | 00:03:00 | ||
| Validate URL | 00:07:00 | ||
| Keep The Values In The Form | 00:04:00 | ||
| Section 06: File Handling | |||
| Read File (readfile()) | 00:02:00 | ||
| Open, Read & Close A File (fopen(), fread(), fclose()) | 00:04:00 | ||
| Read Single Line (fgets()) | 00:03:00 | ||
| Check End-Of-File (feof()) | 00:02:00 | ||
| Read Single Character (fgetc()) | 00:02:00 | ||
| Write To File (fwrite()) | 00:03:00 | ||
| Configure php.ini File For File Uploading | 00:02:00 | ||
| Front End HTML Upload Form | 00:04:00 | ||
| PHP Upload Script | 00:15:00 | ||
| Check If File Exists | 00:03:00 | ||
| Limit File Size | 00:05:00 | ||
| Limit File Type | 00:04:00 | ||
| Section 07: MySQL | |||
| MySQL vs MySQLi vs PDO | 00:05:00 | ||
| Creating A Database & Table (phpMyAdmin) | 00:06:00 | ||
| Connecting To A Database | 00:06:00 | ||
| Get Data Using SELECT Query | 00:10:00 | ||
| WHERE Property For Filtering | 00:03:00 | ||
| LIKE Property For Pattern Search | 00:02:00 | ||
| Sorting Results Using ORDER BY Property | 00:01:00 | ||
| Using JOINS | 00:08:00 | ||
| Insert Data Using INSERT Query | 00:04:00 | ||
| Get ID Of The Last Inserted Row | 00:02:00 | ||
| Insert Multiple Rows | 00:05:00 | ||
| Update Data Using UPDATE Query | 00:03:00 | ||
| Delete Data Using DELETE Query | 00:02:00 | ||
| Delete All Rows In A Table Using TRUNCATE Query | 00:02:00 | ||
| Delete Table Using DROP Query | 00:02:00 | ||
| Limit Data Selections Using LIMIT, ROWNUM | 00:04:00 | ||
| Create Table Using CREATE Query | 00:03:00 | ||
| Clone/Duplicate Table | 00:03:00 | ||
| Alter Table | 00:05:00 | ||
| Create Database | 00:02:00 | ||
| Drop Database | 00:02:00 | ||
| SQL Injection & Prepared Statements | 00:09:00 | ||
| Section 08: XML | |||
| What Is XML? | 00:02:00 | ||
| What Is SimpleXML? | 00:02:00 | ||
| Parse XML String | 00:08:00 | ||
| Parse XML File | 00:02:00 | ||
| Get Node Values | 00:02:00 | ||
| Get Node Values of Specific Elements | 00:03:00 | ||
| Get Node Values – Loop | 00:03:00 | ||
| Get Attribute Values | 00:02:00 | ||
| What Is The XML Expat Parser? | 00:02:00 | ||
| Initializing The XML Expat Parser | 00:10:00 | ||
| Load and Output XML Using DOM Parser | 00:02:00 | ||
| Looping Through XML Using DOM Parser | 00:03:00 | ||
| Section 09: AJAX | |||
| What Is AJAX? | 00:02:00 | ||
| Load Simple Data Using AJAX Front End | 00:08:00 | ||
| Load Simple Data Using AJAX Back End | 00:05:00 | ||
| Load Data From A Database Using AJAX | 00:08:00 | ||
| Section 10: Emails | |||
| Send A Plain Text Email | 00:04:00 | ||
| Send A HTML Email | 00:06:00 | ||
| Email Attachments | 00:17:00 | ||
| PHPMailer Setup | 00:03:00 | ||
| Send Email Using PHPMailer | 00:04:00 | ||
| Send HTML Email Using PHPMailer | 00:04:00 | ||
| Email Attachments Using PHPMailer | 00:02:00 | ||
| Section 11: Object Oriented Programming | |||
| What Is Object Oriented Programming (OOP)? | 00:03:00 | ||
| Basic Class With Variables | 00:04:00 | ||
| Functions | 00:05:00 | ||
| Constructor | 00:04:00 | ||
| Destructor | 00:02:00 | ||
| Inheritance | 00:06:00 | ||
| Multi Class Inheritance | 00:03:00 | ||
| Function Overriding | 00:03:00 | ||
| Public vs Private vs Protected | 00:05:00 | ||
| Interfaces | 00:04:00 | ||
| Constants | 00:03:00 | ||
| Abstract Class | 00:06:00 | ||
| Static Keyword | 00:03:00 | ||
| Final Keyword | 00:02:00 | ||
| Initiating Parent Constructor | 00:02:00 | ||
| Section 12: Error Handling | |||
| die() Function | 00:02:00 | ||
| Custom Error Handler | 00:04:00 | ||
| Triggering An Exception | 00:03:00 | ||
| Exception Handling | 00:05:00 | ||
| Create Database & Table | 00:04:00 | ||
| User Class & Database Connection | 00:15:00 | ||
| Register User Form | 00:09:00 | ||
| Inserting User Data Into Database | 00:10:00 | ||
| Registration Form Field Validation | 00:12:00 | ||
| Securing User Password | 00:03:00 | ||
| Check If Username or Email Already Exists | 00:11:00 | ||
| Retain Data After Failed Registration | 00:03:00 | ||
| Section 13: Advanced | |||
| Validate an Integer Within a Range | 00:04:00 | ||
| Validate IPv6 Address | 00:03:00 | ||
| Validate URL – Must Contain QueryString | 00:03:00 | ||
| Remove Characters With ASCII Value > 127 | 00:04:00 | ||
| Including & Requiring External PHP Files | 00:05:00 | ||
| Section 14 : Resource | |||
| Resource | 00:00:00 | ||
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Access
Level
Number of Units
Number of Quizzes
Duration