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 HTML5
Overview of CSS and CSS3 frameworks
How to manage Teamwork
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).

Prerequisites

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

Lesson 01: Web Technology Introduction

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

Lesson 02: HTML

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 Attributes – The value attribute specifies the initial value for an input field
iFrames – Syntax of iFrame and its Usages

Lesson 03: CSS

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

Lesson 04: HTML 5

introduction
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.

Lesson 05: CSS3

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

Lesson 06:SAS

Preprocessing
Variables
Nesting
Partials
Import
Mixins
Inheritance
Operators

Lesson 07: Github

Create a GitHub Account
Join the Class Repository
Explore the GitHub Repository
Use GitHub Flow
Create a Branch
Find Your Coordinates
Work on GitHub
Create a Pull Request
Collaborate on GitHub
Edit Files on GitHub
Merge Your Pull Request

 

 

Lesson 08: Bootstrap

How to download & using bootstrap
Grid system
Drop Down Menu
Carousel
Thumbnails
Navigational tabs, pills, and lists
Accordion
Modals
Button groups

Lesson 09: Javascript

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

Lesson 10: JS HTML DOM

DOM Methods
DOM Document
DOM Elements
DOM HTML
DOM CSS
DOM Events
DOM Navigation

Lesson 11: Basic PHP

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

Lesson 12: MYSQL DataBase

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

Lesson 13: PHP From Handing

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

Lesson 14: Advanced PHP

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

Lesson 14: Jaquery

Introduction
jQuery Syntax
jQuery Selectors
jQuery Events
jQuery Hide/Show
jQuery Fade
jQuery Slide
jQuery Animate

Lesson 15: Jaquery HTML

jQuery Get
jQuery Set
jQuery Add
jQuery Remove
jQuery CSS Classes
jQuery css()
Drag & Drops
Sortable
Resize
Accordion
Datepicker
Instant Search

Lesson 16: About Domain Hosting-Cpanel

Introduction Cpanel
How to purchase Domain & Hosting
Upload Your website
Backup Your website
Email create
Redirect URL
Much More