Build dynamic sites using PHP and MySQL programming

Workshop Code: hsts-w26

---

What Is Included in this Live Workshop

Workshop Overview

This PHP MySQL training workshop provides you with hands-on practice using PHP with MySQL scripting language for web developers. Web developers will learn the fundamentals of PHP, its data types, control structure, operators and arrays.

• Programming best practices and strategies for development in PHP/MySQL
• Techniques to develop in the PHP language and syntax
• Design and plan relational databases for implementing and managing production
• Interaction with MySQL, SQL and other relational databases
• Learn how PHP sessions and cookies are used to develop web applications
• Understand steps for re-using code utilizing ‘functions’ and ‘includes’
• Acquire an understanding of PHP’s operability for building secure, efficient databases to include best practices on the use of references, global variables and range of projects.

Workshop Prerequisites

We recommended that students have a working understanding of coding in HTML, web form layout, SQL and relational database programming. Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications, files, as well as navigate to other folders.

Job Roles For This Workshop

Web Developers
PHP Developers

Projects Using this Workshop

Designing Applications
Creating Dynamic Web pages

Related Training and Courses

Responsive Website Design Using Advanced HTML5 and CSS3
JavaScript and jQuery Introduction
Object Oriented Programming with UML Workshop
Advance JavaScript, jQuery Using JSON and Ajax
Advance Website Design Using HTML and CSS
jQuery Programming for Beginners
Learn the Fundamentals of UNIX and Linux
Intro to Dreamweaver with Website Development Training
Adobe Muse Training Course
Introduction to the WordPress CMS
Introduction to the Joomla CMS
Mastering Drupal in Six Hours
Responsive Site Design with Bootstrap
Cross-platform Native App Development Using HTML5, CSS3 and JavaScript

---

Self-paced training

This course is available in a self-paced video format starting at $60. Click here to learn more and register. For complete self-paced web design training, visit our Web design and development bundle page.

---

Overall Info About our Workshops

Highlights

• 6 hour hands-on training led by experienced instructors
• Digital workshop contents

Enrollment Fee

Online live starts from $390

Workshop Session Dates

Our workshops are offered all year around. Upon registration we enroll you to the earliest available class but you can reschedule it free of charge. Location

• Online or in our DC office at 3165 Mt Pleasant St NW
  

Time

• Saturdays 9AM-4:30PM (1 hour Lunch)
• Weekdays 6:30PM-9:30 PM

---

Workshop Outline

Topics Covered in this Course.

1. Introduction to PHP

Basic Syntax
Sending Data to the Web Browser
Writing Comments
What Are Variables?
Introducing Strings
Concatenating Strings
Introducing Numbers
Introducing Constants
Single vs. Double Quotation Marks
Basic Debugging Steps
Review and Pursue

2. Programming with PHP

Creating an HTML Form
Handling an HTML Form
Conditionals and Operators
Validating Form Data
Introducing Arrays
For and While Loops
Review and Pursue

3. Creating Dynamic Web Sites

Including Multiple Files
Handling HTML Forms, Revisited
Making Sticky Forms
Creating Your Own Functions
Review and Pursue

4. Introduction to MySQL

Naming Database Elements
Choosing Your Column Types
Choosing Other Column Properties
Accessing MySQL
Review and Pursue

5. Introduction to SQL

Creating Databases and Tables
Inserting Records
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Using Functions
Review and Pursue

6. Database Design

Normalization
Creating Indexes
Using Different Table Types
Languages and MySQL
Time Zones and MySQL
Foreign Key Constraints
Review and Pursue

7. Using PHP with MySQL

Modifying the Template
Connecting to MySQL
Executing Simple Queries
Retrieving Query Results
Ensuring Secure SQL
Counting Returned Records
Updating Records with PHP
Review and Pursue

8. Common Programming Techniques

Sending Values to a Script
Using Hidden Form Inputs
Editing Existing Records
Paginating Query Results
Making Sortable Displays
Review and Pursue

---