Web Design & Development – OptimalIT Training

Web Design & Development

PHP and MySQL™ are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world’s most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications. This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.

Course Objective

Learning HTML
Overview of CSS and CSS frameworks
Familiarity with PHP languages and syntax
Integration of PHP with HTML
Processing form data
Inserting form data into MySQL
Fetching data from MySQL
Sending Emails using PHP using inbuilt methods
Uploading images/files on the server
Securing contents using Cookies and Sessions
Who Should Attend
This course is designed for individuals who have been developing web pages with a GUI and want to progress to developing using three tier architecture (Client, Middle, and Database).

All MySQL and PHP training attendees must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.

Course Duration

90 Hours, 30 Classes, 3 Hours per class

Course Content

How Internet Works

How Website Works

What is Domain, Hosting, Server, DNS

What is cPanel and Domain Control Panel

How Multiple Programming Codes work to Run a project

Introduction – Code Editors and other Basics Concepts of Web Technology

Editors – HTML can be edited by using a professional HTML editor.

Elements – Concept of Tags, Code Writing Concepts

Attributes – Common Attributes of HTML Tags and their Use

Basic – About HTML Basic structure

Headings and Comments – Use of Heading and Comments

Paragraphs – Paragraph, Div and their Implementation

Formatting – Font Formatting, Different Tags to Format Fonts

Links – Implementation of Links, and Description of Link Attributes

Head – Head Elements, and the Contents of Head

Images – Image Tags and its Attributes

Tables – Detailed Table Attributes and Uses of Table

Lists – Unordered, Ordered, Description Lists and other List Tags

Blocks – Div, Span, Layout and their Usages in Modern HTML

Forms – Implementation of Forms and all type of Inputs

HTML Forms Element – This chapter describes all HTML form elements.

HTML Input types – This chapter describes the input types of the element.

HTML Input Attributes – The value attribute specifies the initial value for an input field

iFrames – Syntax of iFrame and its Usages

Syntax – How to write CSS Codes

ID & Class – Implementation of CSS using ID and Class

Style Sheet – Integration of Style sheets inside HTML

Backgrounds – Creating background with CSS

Text and Fonts – Text and Font formatting with the help of CSS

Links – Styling hyperlinks

Lists – Creating List and List contents with CSS

Tables – Creating table designs with CSS

Box Model – Margin, Border, Padding, and Content Management

Border – Border creation with CSS

Outline – Outline, border, contents

Margin – Explanation of the use of Margin using CSS

Padding – Possible Padding Values, padding Sides and Properties

Grouping – Grouping and Nesting

Dimension – Dimension Concepts in CSS

Positioning – Static, Fixed, Relative and Absolute Positioning & Overlapping

Navigation Bar – Navigation Bar, Link and Menu Creation


HTML5 Support – You can teach old browsers to handle HTML5

HTML5 All Elements – About HTML5 All Element

HTML5 Migration – HTML5 Migration

HTML5 Forms – All HTML form element.

HTML Video -HTML5, there was no standard for showing videos on a web page.

HTML YouTube -The easiest way to play videos in HTML, is to use YouTube.

CSS3 Animation

CSS3 Borders

CSS3 Backgrounds

CSS3 Fonts

CSS3 Multiple Columns

CSS3 Text Effects

CSS3 Transition Effects

CSS3 user Interface

CSS3 2D Transform

CSS3 3D Transform

How to download & using bootstrap

Grid system

Drop Down Menu



Navigational tabs, pills, and lists



Button groups

JS Introduction

JS Syntax

JS Statements

JS Comments

JS Variables

JS Data Types

JS Operators

JS Functions

JS Objects

JS Events

JS Dates

JS Arrays

JS Switch

JS Loop For

JS Breaks

JS Window

Alert Box

Confirm Box

Prompt Box

DOM Methods

DOM Document

DOM Elements



DOM Events

DOM Navigation

Syntax, Print / Echo – Basic concepts on PHP

Variables, Data Types, Constants – Data Types and Variables in PHP

Operators – Operators in PHP Programming

If…Else…Else-If – Different conditional statements in PHP

Switch – PHP Switch Case

While Loops – Implementation of While loop

For Loops – Practical implementation of for loop

Functions – Doing tasks using PHP functions

Arrays – Array and multi-dimensional data handling

Date – Use of Date functions and their Elements

Important Common PHP Functions – Trim,Round, Min, Max, Get Browser

Database Management Tools – PhpMyAdmin/MySQLyog Concepts

MySQL Intro – How, when and where to use MySQL

MySQL Connect – How to get connected to MySQL

CREATE DB/Table – How to Create Database

INSERT INTO – How to insert data in Database at Data-tables

SELECT – How to select and grab Data from Database

WHERE – How to select Data from Database using Conditions

ORDER BY – How to bring Data from Database in Order

UPDATE – How to Update Data in a Database

DELETE – How to Delete Data/Table in a Database

BASIC JOIN – How to use JOIN and the Importance of it in Database

KEYS – Use and Importance of Primary and Unique Key in Database

MySQL Functions – Some Important MySQL Functions

Form Handling – on-Page and off-Page form handling Technique

Form Validation – Detailed guideline to use Form in PHP

Form Required Field Check – Verifying data that will be accepted by Form

Include – PHP Include Concepts

Require – PHP Require Concepts

Dynamic Contents – Dynamic implementation of Forms and Tables

File Handling and Upload – File Handling and Upload using PHP

Cookies – How to use Cookies in PHP

Sessions – Use of Session, Guideline about Login-Registration System

Error, Exception – Error and Exception Handling using PHP

E-Mail – PHP Email System, SMTP Email System

Readymade Functions – Get IP, Password Generator, Excel Generator


jQuery Syntax

jQuery Selectors

jQuery Events

jQuery Hide/Show

jQuery Fade

jQuery Slide

jQuery Animate

jQuery Get

jQuery Set

jQuery Add

jQuery Remove

jQuery CSS Classes

jQuery css()

Drag & Drops





Instant Search

Introduction Cpanel

How to purchase Domain & Hosting

Upload Your website

Backup Your website

Email create

Redirect URL

Much More