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

COURSE DURATION

Total Course Duration: 81 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
CLICK HERE