Expand your web development skills with our PHP and MySQL course, which focuses on back-end processing and database functionality.
PHP & MySQL Server-Side Web Programming
DLC030*Pay monthly option available via Snap Finance on payment page in checkout
Course overview
Explore various facets of PHP programming, including its integration and interaction with MySQL databases. Ideal for those with a solid of experience with HTML and CSS, this course will teach you how to improve web page design by incorporating back-end processing and database functionality.
Learn how to create dynamic and interactive web pages that respond to user inputs and update content based on real-time data. With PHP and MySQL, you'll gain the skills needed to develop web applications that offer a richer, more engaging user experience.
• 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
Awarding body
The certification is issued through Open Awards. Open Awards are an Awarding Body Organisation approved by Ofqual. Set up in 1981, Open Awards (previously the North West region of the National Open College Network – OCNNW) have been in business for over 30 years and are a not for profit organisation and a registered charity.
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.
FAQs
You must have previous experience of HTML and CSS programming, as well as being comfortable using text editors or word processing software. A basic knowledge of file zipping software is also advisable.
You may start at any time and have up to a full year to complete your studies. This course is truly flexible and adaptable around your lifestyle and other commitments.
- Online learning platform
- Personal tutor support
- Assignment marking and feedback
- Dedicated learner services
- FREE XO Student Discounts membership
- FREE CV critique service
- FREE employability guide to help you impress future employers
You will send your work to your personal course tutor for them to mark and return to you. On successful completion of the course, you will be awarded your PHP & MySQL Server-Side Web Programming certificate.
It's not a problem. We offer a course replacement service, so if you get into trouble and your course pack is lost or damaged, our Learner Services Team can provide you with a new set of materials for a one-time additional fee.
That's not a problem. We want to make sure you're 100% confident about enrolling on the course and starting your study. So, just give our team of education specialists a call on 03300 563 100 and they'll do their best to help.
Related courses
Webmaster - HTML and CSS for Beginners
Single Course
DLC008Webmaster - Responsive Web Design
Single Course
DLC003Webmaster - Javascript
Single Course
DLC002