fbpx

Web Development With PHP & MySQL

Web Development With PHP & MySQL2021-03-18T11:04:15+00:00

Project Description

Course Details

Web Application Development With PHP & MySQL

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

Instructor Profile

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

Lesson 1: Getting Acquainted with PHP

  • Understand PHP
  • Use the Basic Syntax of PHP
  • Use HTML and PHP
  • Add Comments

Lesson 2: Working with Common PHP Script Elements

  • Use Variables and Constants
  • Work with Control Structure Statements
  • Work with Arrays
  • Use Functions
  • Implement Object-Oriented Programming
  • Include Content from Files

Lesson 3: Working with Forms

  • Create Forms
  • Validate a Form
  • Email Data

Lesson 4: Addressing the Stateless Nature of HTTP

  • Set Cookies and Session Variables
  • Write Scripts Using Hidden Form Fields

Lesson 5: Accessing and Manipulating Data with PHP

  • 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.

Lesson 1: Familiarizing Yourself with the Fundamentals of Databases

  • Identify the Database Development Life Cycle
  • Explore the MySQL RDBMS

Lesson 2: Creating a Preliminary Database Design

  • Analyze Database Requirements
  • Identify Key Fields
  • Create Entity Relationship Diagrams

Lesson 3: Applying Normalization Techniques

  • Normalize Tables
  • Denormalize Tables

Lesson 4: Using the SQL Commands to Work with Tables

  • Discuss Structured Query Language (SQL)
  • Create Tables Using the Data Definition Language (DDL) Commands
  • Modify Data Using Data Manipulation Language (DML) Commands

Lesson 5: Working with Databases

  • Use SQL Compound Statements
  • Create Triggers

Lesson 6: Managing Databases

  • Create Indexes
  • Create Views
  • Create Transactions

Lesson 7: Administering a Database

  • Perform Database Administration
  • Perform Backup and Recovery

Course Resource Person

Mohammad Shihab Uddin
Mohammad Shihab UddinTechnical Trainer
Shariful Islam
Shariful IslamSr. Technical Trainer