PHP & MySQL Server-Side Web Programming

• Introduction
• PHP fundamentals (1)
• PHP fundamentals (2)
• Expressions & control flow in PHP
• PHP functions
• PHP classes & objects
• PHP arrays
• Lesson review & quiz
• Assignment 1 – blackjack card game

• Introduction
• Print and date & time functions
• File handling
• Built-In functions
• Getting data from browsers
• Validating form data
• Lesson review & quiz
• Assignment 2 – form validation program

• Introduction
• Working with images
• Cookies & sessions
• Error handling
• Exception handling
• Regular expressions revisited
• Debugging PHP
• Lesson review & quiz
• Assignment 3 – error handling project

• Introduction
• Database-driven websites
• Structured query language (1)
• Structured query language (2)
• Getting data from a database
• Displaying data from a database
• Updating data in a database
• Lesson review & quiz
• Assignment 4 – getting & updating data in your database

• Introduction
• Introduction to MySQL
• Updating a MySQL database (1)
• Updating a MySQL database (2)
• Database design considerations
• Transactions & backups
• Accessing MySQL using PHP
• Practical MySQL
• Lesson review & quiz
• Assignment 5 – library database project

• Introduction
• MySQL built-In functions (1)
• MySQL built-In functions (2)
• Creating views, functions, & procedures
• Creating triggers & events
• Advanced data techniques for large queries
• MySQL server settings
• Advanced MySQL performance techniques
• Lesson review & quiz
• Assignment 6 – time recording system

You will have up to a full year to complete this course, which is plenty of time to be able to study at your own pace and learn around your other commitments.

You will study this course via distance learning, which means you can learn at a time and place to suit you. You will study this course online and work will be submitted to your course tutor by email or post. You will receive a year’s full tutor support by email, so help is only a click away!

You will complete individual programming assignments, which are marked by your course tutor.

Providing the assignments have been completed to the required standards, students will receive a Level 3 Open Awards Quality Endorsed Unit Course Certificate with 8 Open Awards Credits.

The completion of this course alone does not lead to an Ofqual regulated qualification but may be used as evidence of knowledge and skills towards regulated qualifications in the future. To this end, the learning outcomes of the course have been benchmarked at Level 3 against level descriptors published by Ofqual, to indicate the depth of study and level of difficulty involved in successful completion by the learner.