Dynamic Web Design with PHP and MySQL Video Tutorial Course

CareerVision Training
Distancia

£ 70 - (Rs 5,971)
VAT incl.

Important information

  • Training
  • Beginner
  • Distance learning
  • Duration:
    Flexible
  • When:
    Flexible
  • Delivery of study materials
Description

COURSE INCLUDES
• Format: DVD-ROM
• Duration: 12.7 Hours (125 lessons)
• Instructor: Steve Perry
• Platform: Windows PC or Mac


COURSE INTRODUCTION

Take your skills to the next level. This Dynamic Web Design with PHP and MySQL Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.

These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Dynamic Web Design with PHP and MySQL Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.

Important information

Requirements: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.

Venues

Where and when

Starts Location
Flexible
Distance Learning

What you'll learn on the course

HTML
PHP
MySQL
Web Design
Coding

Course programme

Introduction
What Is PHP?
What Is MySQL?
Simple PHP Program
The Example Web Site - King Real Estate

Interface
Setting Up Your Computer For PHP And MySQL   
Installing WAMP For Windows
Installing MAMP For Macintosh - Part 1
Installing MAMP For Macintosh - Part 2
Using A Hosting Service


PHP Basics
Using PHP Script Tags
Displaying HTML To Your Browser Window
HTML Forms
Using The SELECT Tag
Using The TEXTAREA Tag
Using The RADIOBUTTON Tag
Using The CHECKBOX Tag
Assigning Values To Variables
Appending Text
Debugging Techniques - Part 1
Assignment 1
Assignment 1 - Solution


PHP Programming Fundamentals
String Delimiters
Simple Math
HTML Tables
Using IF Statements
The ELSE Clause
Nested IFs
Code Formatting Rules
Comparison Operators
Using AND
Using OR
Using NOT
Field Validations
Using DIVs
Using DIVs And Forms
Debugging Techniques - Part 2
Assignment 2
Assignment 2 - Solution


Advanced PHP Constructs
The for Loop
The while Loop
Reading A File
Writing To A File
Displaying A Data From A File Into An HTML Table
Debugging Techniques - Part 3
Assignment 3
Assignment 3 - Solution

Functions, Arrays, And Strings
Simple Function
Functions That Receives Data
Functions That Returns A Value
Functions That Receives Data And Returns A Value
Variable Scope
Functions That Returns Multiple Values
Using Include Files
Array Basics
Sorting Arrays
Loading An Array From A File
Loading An Array From A Directory
Recursive Programming
Finding Text
Finding Text With Regular Expressions
Finding Simple Patterns Using Regular Expressions
Debugging Techniques - Part 4
Assignment 4
Assignment 4 - Solution

Introduction To MySQL
Introduction To SQL
The Example Database
Interactive MySQL
Creating Tables
Simple SELECT Statement
Comparison Operators
Logical Operators
Selecting Nulls
Sorting Results
Aggregate Functions
Pattern Matching
Inserting Rows
Updating Table Data
Deleting Rows
SQL Debugging Techniques - Part 5
Assignment 5
Assignment 5 - Solution

PHP With MySQL
Connecting To MySQL Within A PHP Program
Pass Data To A Select
Adding Rows To A Table
Deleting Rows From A Table
Updating Data In A Table
Populating A Select-Option List
Login Validation
Relative Referencing
Creating Tables With phpMyAdmin
Inserting Data With phpMyAdmin
Common Database Functions
Debugging Techniques - Part 6
Assignment 6
Assignment 6 - Solution - Part 1
Assignment 6 - Solution - Part 2

PHP With Advanced MySQL
Date Functions
Using Indexes
Grouping Data
Having Clause
Joining Tables - Part 1
Joining Tables - Part 2
Joining Tables - Part 3
Subqueries - Part 1
Subqueries - Part 2
Assignment 7
Assignment 7 - Solution

PHP With CSS, JavaScript And Ajax
Basic JavaScript Syntax
Validating A Form Field With JavaScript
Positioning A DIV With JavaScript
Parsing Multiple Values JavaScript With PHP
Using Simple Ajax
Using Ajax To Update A Form In Place
Using Ajax To Show SQL Results In Place
Using Ajax To Update The Database
Debugging Techniques - Part 8
Assignment 8
Assignment 8 - Solution - Part 1
Assignment 8 - Solution - Part 2
Assignment 8 - Solution - Part 3

Conclusion
Server-Side Solutions
Security Considerations
Sending Email With PHP (Simple Mail Program)
Next Steps
About The Author