Project Description

Web Application Development With PHP & MySQL

COURSE PLAN

PHP 5 Introduction

Course Overview

In this course, students work with common PHP script elements, use script elements to create forms, address the stateless nature of HTTP by setting cookies and session variables in scripts, and write the data entered in a form to a database.

Prerequisites

  • Programming – Level 1
  • SQL Querying – Level 1 Fundamentals of Querying
  • HTML 4.01: Web Authoring (Second Edition) – Level 1
  • HTML 4.01: Web Authoring (Second Edition) – Level 2
  • Understand PHP
  • Use the Basic Syntax of PHP
  • Use HTML and PHP
  • Add Comments
  • Use Variables and Constants
  • Work with Control Structure Statements
  • Work with Arrays
  • Use Functions
  • Implement Object-Oriented Programming
  • Include Content from Files
  • Create Forms
  • Validate a Form
  • Email Data
  • Set Cookies and Session Variables
  • Write Scripts Using Hidden Form Fields
  • Interact with Databases
  • Modify Database Records Using PHP
  • Access Files and Directories

Fundamentals of Databases Using MySQL

Course Overview

In this course, students will work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems.

  • Identify the Database Development Life Cycle
  • Explore the MySQL RDBMS
  • Analyze Database Requirements
  • Identify Key Fields
  • Create Entity Relationship Diagrams
  • Normalize Tables
  • Denormalize Tables
  • Discuss Structured Query Language (SQL)
  • Create Tables Using the Data Definition Language (DDL) Commands
  • Modify Data Using Data Manipulation Language (DML) Commands
  • Use SQL Compound Statements
  • Create Triggers
  • Create Indexes
  • Create Views
  • Create Transactions
  • Perform Database Administration
  • Perform Backup and Recovery

MVC Framework (CodeIgniter)

Course Overview

In this course, students will work with Codeigniter by identifying the fundamental concepts of MVC architecture patterns.

Introduction of MVC framework

Introduction of CodeIgniter

Codeigniter basic functions

nding plain e-mails with CodeIgniter Email

Sending HTML e-mails with CodeIgniter Email

Sending attachments with CodeIgniter Email

different data to multiple views

Writing files to the filesystem

Creating and downloading ZIP files

Uploading files with CodeIgniter

Creating and using validation callbacks

Using the language class

Introduction

Configuring CodeIgniter for databases

Connecting to multiple databases

Active Record – CRUD (create, retrive, update, dalete)

Escaping user input

Preventing cross-site request forgery

Uploading images with CodeIgniter

Generating thumbnails –

resizing

Rotating images

Cropping images

Generating PDF

COURSE DURATION

Total Course Duration: 90 Hours
Per Class Duration: 3 Hours

RELATED COURSES

AUTHORIZATION

COURSE RESOURCE PERSON

MOHAMMAD SHIHAB UDDIN
SENIOR TECHNICAL TRAINER (PROGRAMMING)

View Profile

MD TAWHIDUL ALAM
SENIOR TECHNICAL TRAINER
(WEB PROGRAMMING)

View Profile

MD. SHARIFUL ISLAM
SENIOR TECHNICAL TRAINER
(WEB PROGRAMMING)

View Profile
UPCOMMING BATCH
register now
CLICK HERE