PHP and MySQL Web Development (C1613) - Blended learning

Blended learning

Who is the training for?

Anyone wishing to learn how to create dynamic websites using MySQL database and PHP and to extending their knowledge of PHP by using it with MySQL.

Duration

30,00 hours(s)

Language(s) of service

EN

Next session

Prerequisites

Successful completion of the module "Concepts of creating dynamic web pages using PHP" (C1612E) or proof of equivalent certified knowledge.

Goals

  • Understand the purpose and operations of relational databases.
  • Create databases and tables using a management system for the MySQL database.
  • Become familiar with management tools for creating and managing databases and tables.
  • Learn how to use databases in web development.
  • Apply data structures for optimal use with MySQL.
  • Insert, modifying and deleting data in MySQL.
  • Use data queries when creating web pages.
  • Apply PHP and MySQL in order to create a simple website that uses a database.

Contents

  • Installing the software locally. Netbeans. The first project.
  • Tables. Primary key. Foreign keys. Indexes.
  • phpMyAdmin. MySQL field types.
  • SQL - Structured Query Language. SELECT. Conditions, JOIN.
  • Inserting data into a table. Updating. Deleting.
  • PHP and MySQL. Connecting the database.
  • Addind and modifying data with PHP.
  • SELECT and mysqli_query.
  • Simple Login system.
  • The final project description. Debuging.

Organization contact details

LLLC

These courses might interest you