Date : Tue, 01 Aug 2017 - Tue, 31 Oct 2017 Last Date of Registration : Mon, 31 Jul 2017
No. of Classes/ Sessions : 24 Total Hours : 48
Duration : 3 month Time : 6.00 pm - 8.00pm
Category : IT and Technology
Resource Person
Mohammed Abdullah Al Faisal

View Profile
Associate Resource Person

Training Details

Start Date: Tue, 01 Aug 2017
Last Date of Registration: Mon, 31 Jul 2017
Training Fee: 16000.00
Vanue: House # 2B, Road # 12, Mirpur Road, Dhanmodi, Dhaka- 1209, Bangladesh


Who Can Attend?

Web developers, web designers People who want to become web designers and developers Web design students Total beginners

Methodology

Computer based, Interactive Lecture, Power Point Presentation, Case Study, Group Work, handout etc.

Special Note

Certificate awarded by Australian Academy of Business Leadership

Mastering Website Development with PHP & MySQL
Objective of this Training

On completion of this PHP training course, students will be able to:

  • How to develop the application using Eclipse IDE
  • How to work with Eclipse IDE Perspectives
  • How to create & manage the PHP projects using Eclipse IDE
  • How to work effectively with Weakly types language like PHP
  • How to work with 1D, 2D Rectangular & Jagged Array
  • How to work with Associate Arrays
  • Understand objected-oriented programming with PHP
  • How to effectively us OO techniques
  • How to create and implement Abstract Classes & Interfaces
  • How to interact with databases
  • How to Handle the Errors in < PHP 5.0 Version
  • How to Handle the Exception Handling in >= PHP 5.0 Version
  • How to handle the IO Operation in PHP
  • How to working existing collection framework
  • How to create a new custom (User Defined) Collection
  • Gain solid working knowledge of PHP programming skills they need to successfully build interactive, data-driven sites
  • How to manage sessions
  • Use Exceptions to handle run time errors.
  • Develop & Consume Web Services
  • Understand the concept data type for representing information in MySQL
  • Manage the structural characteristics of your databases and the tables within your databases
  • Gain the solid working knowledge of various SQL statements & functions
  • Gain the knowledge on the SELECT statement to retrieve information from database tables
  • Make use MySQL expressions in SQL statements to query the database information
  • Use DML SQL Command to maintain the data of database tables
  • Develop and manage triggers
  • How to handle HTML forms
  • How to manage the Session in PHP
  • How to work with Graphics in PHP
  • How to manage the data in database using PDO
  • How to deal errors in PDO
  • How to manage Transaction in PDO
  • Templating in PHP
  • How to work with Smarty Template Engine
  • Gain the solid skills on the PEAR package
  • Develop practical PHP applications
  • Develop & Deploy secure PHP Web applications

Training Overview & Outline

Part 1: Overview, Development Environment Setup

  • Why Website Development
  • Overview of this course
  • Why PHP-MySQL?
  • IDE and Tools
  • Installing Dreamweaver CS3
  • Your First Basic HTML Page

Part 2: HTML and CSS

HTML Basics

  • What is HTML
  • HTML Tags (Head, Body and Title)
  • HTML Headings
  • HTML Paragraphs
  • HTML Links
  • HTML Images
  • HTML Line Breaks
  • HTML TABLE
  • HTML Lists
  • HTML Unordered Lists
  • HTML Ordered Lists
  • HTML Definition Lists
  • HTML Forms and Input
  • HTML Marquee Tag

CSS 2.0 Basics

  • CSS Introduction
  • CSS Syntax
  • CSS Id & Class
  • CSS How To
  • Styling Backgrounds
  • Styling Text
  • Styling Fonts
  • Styling Links
  • Styling Lists
  • Styling Tables
  • CSS Box Model
  • CSS Border
  • CSS Outline
  • CSS Margin and
  • CSS Padding

Template Design with HTML and CSS

  • How to start Template Design
  • Horizontal and Vertical Div Concept
  • Basic Layout Design
  • Box Coloring to understand the divs
  • Formatting and Styles

Part 3: Overview of PHP, Development Environment for PHP

Overview

  • Static vs. Dynamic Web Sites
  • Dynamic Content from Databases
  • Developing Dynamic Internet Applications
  • Client-Side Scripting vs. Server-Side Scripting
  • Overview of PHP Advantages and Capabilities
  • PHP vs. ASP

Development Environment

  • Softwares, IDE and Tools
  • XAMMP installation in windows
  • Installing and Configuring PHP
  • Testing the Environment

PHP Language Structure and Programming Basics

  • Basic PHP Syntax
  • PHP Tags
  • PHP Statements and Whitespace
  • Comments
  • Hello World!

Part 4: PHP Programming

  • Variables (Global, Local)
  • Data Types
  • Operators and Expressions
  • Constants
  • Control Statements (Loops, IF ELSE, While, Switch)
  • Working With Functions
  • PHP build in Functions
  • Working with Arrays
  • String Manipulation
  • Working with Objects
  • Working with Date Time
  • Include
  • Parameter Passing

Part 5: Advance PHP

  • Working with Forms
  • Creating a Simple Input Form
  • POST and GET Method
  • Accessing Form Input with User-Defined Arrays
  • Combining HTML and PHP Code on a Single Page
  • Using Hidden Fields to Save State Redirecting the User
  • Sending Mail on Form Submission
  • Creating the Form
  • Simple Login Form
  • Basic Registration Form
  • Form Validation (Normal)
  • Working with Files, Images
  • Single File Uploads, Multiple File Uploads
  • Cookies and Session

Part 6: MySQL Database Programming with PHP

  • MySQL Basics and Database Programming
  • Understanding Database Design Process
  • Importance of Good Database Design
  • Types of Table Relationships
  • Understanding Normalization
  • Following the Design Process
  • Learning Basic SQL Commands
  • Creating a Connection with the MySQL Server
  • Using the INSERT Command
  • Using the SELECT Command
  • Using WHERE in Your Queries
  • Selecting from Multiple Tables
  • Using the UPDATE Command to Modify Records
  • Using the REPLACE Command
  • Using the DELETE Command
  • Frequently Used String Functions in MySQL
  • Using Date and Time Functions in MySQL
  • Min, Max, Add, Subtract

Part 7: Real World Project Examples

  •  Insert, Update, Delete Form
  • Creating a Simple Discussion Forum
  • Creating an Online Address Book

Part 8: jQuery and others

jQuery Plugins

  • Dialog
  • Accordion
  • Sortable
  • Autocomplete
  • Datepicker
  • Progress bar
  • Tabs

jQuery Image Galleries (How to Use)

Ajax Form Validation Examples

Pagination Examples

Part 9: Working with CMS (WordPress)

  • About WordPress
  • Installing WordPress
  • WordPress Themes
  • Managing Post and Pages
  • Working with Menus
  • Working with Media Files
  • How to install plugins
  • WordPress Settings
  • The Appearance Tab
  • Host your WordPress Site

Part 10: cPanel Basics and Uploading your site to Live Server

  • What is cPanel
  • Installing Filezilla
  • Uploading your site to live server
  • Exporting your database from local site
  • Importing your database to live server
  • cPanel Functionality

Final Project

Every student must fully complete at least two projects from Real World Project Part (Part 7). We will give you one week time. After completing those, we will assign a final project to all the students. All students will make a website using PHP, MySQL, HTML and CSS ( with the help of teacher ). This project can vary from batch to batch. Here is a sample Final Project Example:

Final Project Name: Student Management System

Project Description: You need to design and create a website that will show you the list of students in the front page. You can see student’s list information category wise. You also need to create an admin panel for inserting student’s information. There will be two types of user: admin and user. Admin can change all users’ information and a specific user can change only his information.

What you need to do:

1. Database Design
2. Content Design
3. Simple UI Design
4. Login Panel
5. Admin Panel Functionality
6. Student Panel Functionality
7. View Students Information

eBooks

We will provide you 100+ web development eBooks and we will suggest you only 3 or 4 of those to follow.

Video Tutorials

We will provide you the following video tutorials to be a Master in Web Development. All of these are paid tutorials. If you directly buy these from their website, it will cost at least 500 dollar (appx 40, 000 taka). We will provide you these tutorials after finishing the course at free of cost.
1. HTML Essential Training 2012 (lynda)
2. CSS For Developers (lynda)
3. PHP with MySQL essential Training (lynda)
4. PHP Training Videos (DevelopPHP)
5. Photoshop for web Developers (lynda)
6. WordPress Essential Training (lynda)
7. WordPress Template Design (lynda)
8. Joomla Essential Training (lynda)
9. Javascript Essential Training (lynda- on request)

Registration