Web Programming using PHP/MySQL Part 2

Program Overview

This advanced short course in Web Programming using PHP/MySQL Part 2 builds on the basics of PHP and introduces MySQL, a relational database management system. Participants will learn to integrate MySQL into web applications, create and manage databases, and perform CRUD operations. By the end of the course, they will be able to build dynamic web applications with login systems, e-commerce features, and other functionalities.

Program Outline

Outline:

This advanced short course builds on the teachings of "Web Development using PHP Part 1" and introduces MySQL, a relational database management system developed by Oracle and based on the industry standard structured query language (SQL). It demonstrates how to integrate MySQL into a web application with a PHP back end. Combining PHP and MySQL allows developers to build dynamic web applications with login systems, e-commerce features, and other functionalities. Participants will learn to create, read, update, and delete (CRUD) data using web forms, utilizing these skills for various applications. By the end of the course, participants will be able to:

• Build a single point of entry website
• Use MySQL workbench software to create and manage databases
• Connect to a MySQL database from a website using PHP scripts
• Create, retrieve, update, and delete data in databases
• Query databases to retrieve specific data
• Create a log in system for a website
• Validate new users using email confirmation
• Restrict access to website content based on user credentials
• Write basic object-oriented PHP and MySQL queries

Teaching:

• Delivered by an industry professional with extensive experience in web development.
• Taught in small groups, offering personalized attention and support.
• Utilizes a practical approach with hands-on exercises and real-world examples.
• A City, University of London certificate is awarded upon successful completion.

Careers:

Participants will be equipped with the skills and knowledge to pursue careers in web development, including:

• PHP Developer
• MySQL Developer
• Full-Stack Developer
• Web Application Developer
• E-commerce Developer
• Freelance Web Developer

Other:

• The course takes place over ten weekly evenings, with flexible schedules available.
• City Short Courses follow the academic year, with sessions offered in Autumn (October), Spring (January), and Summer (April).
• Participants are expected to have successfully completed "Web Programming with PHP/MySQL Part 1" or possess equivalent PHP/MySQL skills.
This short course is an excellent opportunity for individuals who want to enhance their web development skills and gain valuable knowledge of MySQL and database integration.