Web Development (Mysql/PHP)

Web Development (Mysql/PHP)

This Web Development Specialist course is an intensive hands-on course is designed to provide web developers with an in-depth understanding of the web development process and life cycle.

MODULE 1 – Introduction to Web Technology

Learning the Basics of Web Technology

• Idea about – Web Designing, Web Development, Software Development, Outsourcing, Freelancing.
• Basic Ideas on – Domain, Hosting, IP, Server, NameServer, Programming Language, Designing Language, Structured Query Language, Framework, CMS, IDE, cPanel, Domain Control Panel, FTP Client, Local Server.
• Discuss on what we will be Learning in the Web Technology course and how
• Code Concepts, Program Concepts

Learning to Use the Tools of Web Programming

• How to use IDEs (NotePad++, NetBeans, PHPStorm, PHPEdit)
• How to use Local Server Application (XAMPP, WAMP, LAMP, MAMP)
• How to operate cPanel and Domain Control Panel
• How to use FTP Clients (CoreFTP, FileZilla)

MODULE 2 – HTML and HTML5

 Practicing the Basics of HTML and HTML Pages

• Comments, Starting HTML Page, Head, Style, Script, Body
• Meta Tag, Meta Attributes, Keywords, Description, Author, Page Refresh
• Paragraph, Heading, Division, Section, Article
• Header, Footer, Main, Aside
• Span, Cite, Address, Abbreviation, Details, Summary
• Bold, Underline, Italic, Small, Strong, Subscript, Superscript
• Delete, Mark, Code, Block Quote, Quotation

Practicing Advanced HTML and Basic HTML5

• Font, Font Size, Font Color, Font Face
• HTML Entities – Registered Trademark, Copyright, Euro, Space, Cent, Pound
• Symbol – Summation, Elements Of, Not Elements Of, Empty, Differential Sign
• URL Anchor, Mail Anchor, Call Anchor, Target
• Navigation Tag, Purpose of Navigation Tag
• Image, Image Source, Alternate Attribute, Height and Width, Title
• Description List, Define Terms, Define Details, Ordered List, Unordered List, List Item

Practicing More HTML5 and Designing Pages

• iFrame, iFrame Target, Sandbox Attribute, Load iFrame on Click
•  Audio, Video, Source, Media Type, Preload, Stream YouTube Video using iFrame
• Base URL, Bidirectional Override, Preformatted Text, Data List,
• Level, Result, Access Key, Editable Attribute, Downloadable Product
• Table, Table Row, Table Data, Table Head, Table Body, Table Foot, Style Attribute, Border
• HTML Form, Input Types, Get and Post Method, Button Tag, Button Attributes
• Designing Website Layout using HTML

Exam on HTML and HTML5

• Online Quiz
• Mentoring Session
• Professional Lab Test

MODULE 3 – CSS and CSS3

Practicing Basic CSS Codes

•  How to and Where to CSS code, Comments in CSS, Converting Style Attribute to CSS
• ID Selector, Class Selector, Child Class, Grouping Selector, Multi Stylesheet, Link Stylesheet
• Background Image, Background Repeat, Background Position, Background Color
• Padding, Margin, List, Font, Link, and Table using CSS
• CSS Combinators – Child Selector, Descendent Selector, Adjacent Selector; Target Selector
• Dimension, Media Screen, Responsive Design
• Cursor, Custom Font (from External and Internal Source)

Designing with Advanced CSS and Basic CSS3

• Border in CSS, Box Shadow, Opacity, Horizontal Alignment, Background Image Handling
• White Space, Float, Clear Tag, Columns, Visibility, Animation, Animation Moves
• Table in CSS, Position in CSS
• An example Dropdown Menu using CSS
• Outline, Menu Example 1 and 2, CSS for Print Screen
• Transform, Border-box
• Designing Button using CSS

Designing more Advanced with CSS3

• Designing Search Box and Text Fields using CSS3
• Border Image, Background Image, Background Color
• Gradient, Text Shadow, Word Break
• Rotate, Rotate X, Rotate Y, Content Position, Counter
• Transform, Animation, Button in CSS3, Columns, Filter
• Designing Layout using CSS
• Understanding the Concept of Template and Theme

Exam on CSS and CSS3

• Online Quiz
• Mentoring Session
• Professional Lab Test

MODULE 4 – JavaScript

 Basic JavaScript

• Writing JavaScript Code, Comments, Simple Variable, Variable Types
• JS Operators, Simple Function, Parameter, Arguments
• If Else Statement, Handling Multiple Condition, Conditional Operators
• Get Element By ID, Get Element By Tag Name, Get Element By Class
• Switch Case, For Loop, EVAL Function

Advanced JavaScript

• ParseInt, ParseFloat, ParseString, This Element
• Class and Object, Advanced Class and Object
• Handling String, Handling Number
• Handling Math, Handling Math
• Handling Array

Examples on JavaScript

• Example – Form Validation, Advanced Form Validation
• Example – JSON Format, Auto Select, Confirm Function,
• Example – Image Slider, Popup Page
• Example – Printing Option Creation, Random URL, Blur
• Example – Creating Dynamic Dropdown Menu

Exam on JavaScript

• Online Quiz
• Mentoring Session
• Professional Lab Test

MODULE 5 – jQuery

jQuery Basics, the JavaScript Library

• Basis Rules and Guidelines on jQuery; Show, Hide, Toggle Function;
• Change CSS using jQuery, Menu with Mouse-over and Mouse-out
• Focus and Blur on Text Field
• Fade-in, Fade-out, Fade-Toggle
• Slide-up, Slide-down, Menu using Toggle
• Get and Set Text/HTML using jQuery;

jQuery Basics, the JavaScript Library

• Example – Add and Remove Element Dynamically
• Get Dimension using jQuery, Animation using jQuery
• Load File using jQuery, AJAX Page Load using jQuery, No Conflict Function
• Make Popup using jQuery, Print Selected Division using jQuery
• Calendar Date Picker, Crosscheck Password using jQuery

Exam on JavaScript

MODULE 7 – Photoshop for Web/App Developers

Basics of Photoshop

• Marquee, Lasso, Slice, Crop, Move Tools and their Practical Use
• Brush, Pencil, Patch, Stamp, History Tools and their Use
• Eraser, Blur, Sharpen, Smudge, Dodge, Sponge, Burn Tool and their Use
• Gradient, Paint Bucket, Different Shape Tools and their Use
• Selection and Pen Tool
• Eyedropper, Hand and Zoom Tool
• Color, Swatches, Style Window and their Use
• History Window and its Use
• Different Type of Brush and their Use
• Image, Canvas, Pixel, Rotation, Trim, Revert etc Actions
• Extract, Filter Gallery, Liquefy, Pattern Maker and their Use
• Different type of Layer and their Use

MODULE 8 – SQL/MySQL

Understanding Database and Database Management Tools

• What is Database; Traditional and Modern way of storing Data;
• What are the basic Tools for Database Management, Understanding SQLYog
• Understanding the Interface and Features of PhpMyAdmin; Data Export and Import;
• Handling Database and Table Structure (Create, Alter, Delete) using PhpMyAdmin
• Insert, Update, Delete data using PhpMyAdmin; Using Functions from PhpMyAdmin
• Working with SQLYog; Working on Remote Database Server;

Managing Database and Table Structures in SQL/MySQL

• MySQL Intro – How, when and where to use MySQL
• MySQL Connect – How to get connected to MySQL
• CREATE Database – How to Create Database
• DROP Database – How to Drop a Database
• KEYS– Use and Importance of Primary and Unique Key in Database
• NULL & NOT NULL – Importance & Contradiction of NULL & NOT NULL
• AUTO-INCREMENT – How to Auto-Increment in Database
• DEFAULT – MySQL Default and its use
• DATE – Date, Time and Timestamps in MySQL Database
• CREATE Table – How to Create Table using MySQL Query and SQLYog
• ALTER Table – How to Alter Table using MySQL Query and SQLYog
• DROP Table – How to Drop Table using MySQL Query  and SQLYog

Advanced Queries using SQL/MySQL

• INSERT INTO – How to insert data in a Data-Tables
• SELECT – How to select and grab Data from Data-Table (In Different Ways)
• WHERE – How to select Data from Database using Conditions
• ORDER BY – How to bring Data from Database in Order
• GROUP BY – Grouping Database outputs from MySQL
• UPDATE – How to Update Data in a Data-Table
• DELETE – How to Delete Data of a Data-Table
• BASIC JOIN – How to use JOIN and the Importance of it in Database
• LEFT JOIN – Use of Left Join and its Practices
• RIGHT JOIN – Use of Right Join and its Practices
• FULL JOIN – Use of Full Join and its Practices
• OUTER JOIN – Use of Outer Join and its Practices

Working with Advanced MySQL

• MySQL Functions – Understanding the Importance of Functions
• Group By, Having, Count Function
• Average, Minimum, Maximum, Sum, Length
• Round, Format, Now Function
• First, Last, Mid Function
• UCase, LCase Function
• Understanding Primary Key, Foreign Key, Reference, and Constrain
• Implementing Relation, and Creating Relational Database
• Creating Database of an E-Commerce Website
• Upload Database on Real Server (cPanel/PhpMyAdmin)

Exam on SQL/MySQL

• Online Quiz
• Mentoring Session
• Professional Lab Test

MODULE 9 – PHP (Basics and Advanced)

Learning Basics of 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
• Syntax, Print / Echo – Basic concepts on PHP
• For Loops and Foreach Loop – Practical implementation of Loop
• Date – Use of Date functions and their Elements

Learning Advanced Topics in PHP

• Arrays – Array and multi-dimensional data handling
•  String – Working with Strings using PHP
• Error, Exception – Error and Exception Handling using PHP
• Custom Functions – Use of Custom Function Development and its Practical uses
• Library Functions – Trim, Round, Min, Max etc.
• Handling HTML Form using PHP – Detailed guideline to use Form in PHP
• Form Field Validation – Verifying data (Email, URL etc.) that will be accepted by Form
• File Handling and Upload – Handling File and Uploading File using PHP
• Form Security – Safety of Submitted Data using HTML Form / Know about SQL Injection
• User Agent – Identify website’s Visitor Type, whether it is Bot or User

Learning Cookie, Session, Encryption, Class and Object

• Cookies – How to use Cookies in PHP
• Sessions – Use of Session, Guideline about Login-Registration System
• Reading File – Reading File Data in Read/Write Mode by Character or by String
• Encryption – Data Encryption, Hash, Salt Mechanism
• Knowing details about Class and Object
• Understanding Constructor and Destructor
• Child Class and Inheritance
• Encapsulation – Private, Public and Protected Data Type
• Static Variable, Static Function
• Magic Method – Call, Set and Autoload Function; Concept of NameSpace

Handling Database using PDO; Learning to Parse XML

• Connect to Database using PHP MySQLi Class
• Select Data using PHP MySQLi Class
• Insert Data in Database using PHP MySQLi Class; Get Last Insert ID;
• Update Data in Database using PHP MySQLi Class
• Delete Data from Database using PHP MySQLi Class
• Create Database and Table using PHP MySQLi Class
• Connect to Database using PDO Class; Understanding Prepared Statement;
• Select Data from Database; Select Data from Database with Placeholder;
• Insert Data into Database; Insert Data from Database using Placeholder;
• Update Data into Database using PDO Class;
• Delete Data from Database using PDO Class;
• Handling Error in PDO;
• Create Table and Database using PDO Class;
• Parse XML; Show data from XML Data source;

Sending real-time Mail & SMS; Generate PDF & Excel; AJAX Pagination

• Send Mail using PHP with the help of Apache/SendMail Module; Send SMTP Mai
• Send SMS using PHP with the help of SMS Gateway, Learn to use cURL
• Generate PDF using DOM PDF Library; Generate Excel using PHPExcel Library
• Create Paginated Table using AJAX

Integrate Payment Gateway; Safe File Download; Dynamic Search; Graph

• Integrate real-time Payment Gateway in your Project
• Download File without creating any Download Link / Safe File downloading Facility using PHP
• Use jQuery AJAX, PHP and MySQL to create Dynamic Search; Example of Dropdown
• Generate Graph (Bar Diagram) using jQuery, PHP and MySQL

Exam on PHP 7.0

• Online Quiz
• Mentoring Session
• Professional Lab Test