PHP and MySQL Programming PHPB

  • 0 upcoming dates
  • $2,995 per seat

About this class

PHP and MySQL (or its fork, MariaDB) are two of today's most popular, open-source tools for server-side web programming. In this five-day, instructor-led course which covers PHP7, you?ll learn how to use them together. You?ll create a database-driven website that implements the MVC pattern. You will learn how to build out your PHP and MySQL skills to the professional level, using today?s best practices. Learn how to use the latest versions of PHP, MySQL, the Apache web server and the NetBeans IDE to build your first PHP applications. You?ll learn to create applications that conform to the MVC pattern, so they?ll be easier to maintain as they grow. The course covers the skills you?ll use every day in professional applications, like how to work with form data, dates, arrays, sessions, cookies, functions, objects, regular expressions and exceptions. Use MySQL to design and create a database and learn how to access and maintain the data in a database. Learn important web programming skills like how to secure web pages, prevent SQL injection attacks, guard against XSS attacks, send email, upload files, process images and access content from other websites.

What you'll be able to do

  • Introduction to Web Development with PHP and My
  • Master PHP Programming
  • Master My SQL Programming
  • Master the Advanced Skills for Building Websites

Course outline

  1. Module 1Introduction to Web Development with PHP and My

    • SQL
    • Introduction to w eb development with PHP
    • How to code a PHP application
    • Introduction to relational databases and MySQL
    • How to use PHP with a MySQL database
    • How to use the MVC pattern to organize your code
    • How to test and debug a PHP application

  2. Module 2Master PHP Programming

    • How to work with form data
    • How to code control statements
    • How to work with strings and numbers
    • How to work with dates
    • How to create and use arrays
    • How to work with cookies and sessions
    • How to create and use functions
    • How to create and use objects
    • How to use regular expressions, handle exceptions and validate data

  3. Module 3Master My SQL Programming

    • How to design a database
    • How to use SQL to create a database
    • How to use SQL to work with a database
    • Professional PHP for working with MySQL
    • A database-driven website

  4. Module 4Master the Advanced Skills for Building Websites

    • How create secure websites
    • How to send email
    • How to work with files, uploads, and images
    • An eCommerce website
    • PHP and MySQL Programming
    • Course PHPB 5 Days I

Download the full outline (PDF)

Before you attend

Knowledge of HTML and some programming experience is required. This course does not formally teach HTML or Web page design. Students should attend course ISI-1372, An Introduction to HTML5 and CSS3 for Web Designers & Developers or have equivalent skills and knowledge.

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More software development classes

See all