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)


 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


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


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

©2019 All Rights Reserved | Centrino Soft Ltd.