WEB APPLICATION DEVELOPMENT (PHP/MySQL)

Aim of the course

On completion of this short course delegates will be able to develop highly interactive database driven web applications.

COURSE OUTLINE

Module 1: XHTML/CSS

Upon completion of this XHTML and CSS module, delegates will be able to write XHTML-compliant web pages, use XHTML for containing data and CSS for styling and page layout.

Extensible HyperText Markup Language (XHTML)                            

• Overview of HTML, XHTML and HTML5
• The Basics of XHTML
• Images
• Tables
• Forms

Cascading Style Sheets (CSS)

• Overview of CSS2 and CSS3
• CSS Box Model
• CSS Display and Positioning
• CSS Floating
• CSS Pseudo-class
• CSS Media Types

Module 2: JavaScript

Upon completion of this JavaScript module, delegates will be able to add interactivity to static websites.

• Introduction
• Variables and data types
• Operators
• Conditional statements
• Functions
• Loops
• The Document Object Model (objects, properties, methods, events)
• DHTML

Module 3: Relational Database Design (MySQL)

SQL is a standard language for accessing databases. On completion of this module delegates will understand the Relational Database Design model as well as various SQL statements used to manipulate the structure of database tables and date stored therein.

• Introduction
• Relational Database Design Theory
• The MySQL Server
• Structure manipulation statements
• Data manipulation statements
• Data encryption
• Database backup and restore

Module 4: Hypertext Pre-processor (PHP)

PHP is a powerful server-side scripting language for developing dynamic and interactive web applications. On completion of this module delegates will be able to develop dynamic and highly interactive web applications using the MySQL/PHP development model.

• Introduction
• Understanding how dynamic pages are served
• Web server, application server, PHP Engine, RDMS
• PHP syntax construct
• Maintaining state across pages
• Super Global Arrays (GET, POST, REQUEST, SESSION, etc.)
• The Session Object and Session Variables
• PHP functions
• PHP file management
• PHP e-mail
• Database manipulation using PHP functions

Who should attend?

• Individuals considering a career in Web Application Development
• Individuals who already work in the field, but feel they need to brush-up on their skills;
• Individuals that have taught themselves how to design Web Sites and now need help to progress to the next level;

Job opportunities

• Junior to senior web application developers