WEB Programming
using HTML-CSS-PHP-MYSQL

Pre-requisite: None

DURATION: 5 days training
                     9am -5pm
                     40 hours


Equipment: Desktop
                      XAMPP software
                      Fast Internet

Inclusion (face-to-face training): Lunch Meal
                                                            Certificate of completion
                                                            Training handout
                                                            Free flowing coffee

Inclusion (Online Training): Certificate of completion
                                                   Training handout (soft copy)


                                                     




Day 1

1. Introduction to World Wide Web
• Planning and Designing Website
• Structure of a Website
• Audience Targeting
• Domain Name Registration
• Designing Effective Web Layout and Navigation
• The Language for creating web pages

2. HTML
• Introduction to HTML
• Using HTML Editors
• Structure of HTML Pages
• Adding and Formatting Text
• Creating Horizontal Line
• Commenting Your HTML Code
• HTML Headings
• Creating Tables
• Adding images
• Adding Hyperlinks
• Creating lists
• Creating sections in HTML5


3. CSS Styling
• Introduction to CSS
• Adding CSS
• Changing Colors with CSS
• Working with Fonts
• Text Formatting
• Page Background Color and
Background Image
• Using float, Ordered and Unordered
Lists
• The CSS box model, Margins, Padding
and Borders
• Using tag, Classes
• Selection in CSS
• Using classes to style a page
• Inheritance and Using ids to structure
your site
• Selector weight values and specificity 

Day 2

4. JavaScript – Making Web Site
Interactive
• Using JavaScript into a Web page
• Displaying dates and times with
JavaScript
• Embedding JavaScript code in HTML
• Creating an image gallery with
JavaScript


5. Bootstrap – Making Web Site
Responsive
• Introduction to Bootstrap
• Installing Bootstrap
• Typography in Bootstrap
• CSS Components in Bootstrap
• Bootstrap navigation
• Creating a template and theme


6. SEO – Search Engine Optimization
• Introduction to SEO
• Writing SEO-Friendly pages
• Adding SEO Info to Links and Images
• Adding more features on your Website
• Embedding Google Map
• Embedding a YouTube Video
• Adding social media plugins
• Creating Web Form
• Publishing your site
• Finding Web Hosting space
• Publishing Website Using FTP-Client



Day 3

7. Javascript
• Variable Naming Rules and JavaScript
Data Types
• Expressions and Operators
• Flow Control
• Objects and Arrays
• Defining Functions and Methods
• Constructors and Inheritance
• Pattern Matching with Regular
Expressions
• JavaScript in Browsers
• The Document Object Model (DOM)
• How to Get Input and Output
• Managing Web Page Styles using
JavaScript and CSS
• Handling Web Page Events
• How to Script Tables
• How to Script Forms
• Introduction to Ajax

8. Introduction
• Why use PHP and MySQL?
• The PHP programming environment
• Overview of SQL

9. Setting up a Test Bed
• Decisions about a testing environment
• WAMP/MAMP
• Installing Apache, PHP and MySQL on
your computer
• Testing on a remote Server
• Deciding on

Development tools
• Using PHPMyAdmin


Day 4

10. Overview of PHP
• Setting up a PHP page
• The phpinfo() function
• Learning basic syntax
• Echoing HTML output to the browser
• The importance of comments
• Using single and double quotes
Variables in PHP
• Using loose typed variables
• Assigning variables
• Overview of numeric, string and other
types
• Assigning a variable to itself

Logical operators
• Arithmetic operators
• Logical operators
• Comparisons
• Operator precedence

11. Numbers in PHP
• Making calculations
• Using built-in numeric functions
• Incrementing and decrementing
Strings in PHP
• Concatenating strings
• Trimming strings
• Removing slashes and other harmful
characters
• String functions

Control structures in PHP
• The If statement
• FOR loops
• While loops
• The Switch
Transferring information between PHP pages
• GET and POST
• Different form field types
• Self-referencing forms
• Form handlers

Day 5

12. Database fundamentals
• Structuring a database
• Using tables
• Table relationships
• Common data types

Creating a database
• Using PHPmyAdmin
• Adding a table
• Populating a table with types and data
• Browsing a table

Getting PHP to connect to MySQL
• Using the mysql_connect() function
• Using the mysql_select_db() function
• Testing a connection
• Writing a sample error trap

Querying MySQL using PHP
• Writing SQL queries
• Using Select, Insert,

Update and Delete
• Querying MySQL and returning results
• Interpreting the returned array

Building a Web Application
• Creating pages to:
• Add entries
• Modify entries
• List entries
• Filter entries