a
  COMPUTER
INSTITUTE

PHP and MySQL, Online Training Course



This training course is for Web Designer and Developers who plan to create dynamic web sites using PHP and MySQL. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce..

Why should you Learn PHP and MySQL ?

PHP & MySQL  Knowledge is  a plus for securing a high-paying job.
Employer will be convinced that your knowledge is beyond the basic Web design technologies. PHP and MySQL is for seasoned Web Designers and Developers who wish to create dynamic and interactive web sites with the ecommerce capabilities.

Benefits of the PHP & MySQL for Professionals

  •  Demonstrates a working knowledge of Dynamic Web Site Design and Publishing 
  •  Confirms commitment to profession 
  •  Offers a career differentiator, with enhanced credibility and marketability 
  •  Takes you beyond basic user's knowledge to the IT Pros who know how to create web sites 
What are the Prerequisites?

Individuals should have a basic knowledge of programming logic, in addition be able to use an editor to create and save web pages as part of this course. Knowledge of HTML is also required.

Exam Requirements: The knowledge learned in this course can be applied to pass any Web-related Exam.

Course Tutorials Include:

Course Topics: 15

Estimated Time Needed: 43 hour(s)

Audience: This course is for anyone who would like to create dynamic Web sites using PHP and MySQL.

Course Description: This online course teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.

 

Course Tutorials Include:

Time: 2 hour(s)

PHP and MySQL: 1 Installing Required Software

Description

After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.

Objectives

  • To install and configure MySQL
  • To install and configure Apache with PHP
  • To create MySQL users and grant privileges
  • To test PHP and MySQL installations
  • To configure PHP

Time: 3 hour(s)

PHP and MySQL: 2 PHP Basics

Description

After taking this section, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.

Objectives

  • Identify basic PHP syntax
  • Create basic PHP scripts
  • Send data to the Web browser
  • Apply variables, strings, and constants to a PHP a script

Time: 4 hour(s)

PHP and MySQL: 3 Programming with PHP

Description

After taking this section, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.

Objectives

  • Handle HTML forms using PHP scripts
  • Validate form data
  • Manage arrays using various types of loops
  • Work with magic quotes

Time: 3 hour(s)

PHP and MySQL: 4 Creating Dynamic Web Sites

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that are responsive to users and can alter content based on differing situations.

Objectives

  • Create PHP scripts using multiple files
  • Display and handle HTML forms within a single PHP script
  • Create and call functions
  • Create functions that take arguments and return values
  • Set and alter variable scope
  • Send email from a PHP script

Time: 4 hour(s)

PHP and MySQL: 5 SQL and MySQL

Description

After taking this section, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

Objectives

  • Choose column types and other column properties
  • Create databases and tables
  • Insert records, select, update and delete data
  • Use conditionals and functions

Time: 3 hour(s)

PHP and MySQL: 6 Advanced SQL and MySQL

Description

After taking this section, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.

Objectives

  • Normalize a database into First, Second and Third Normal Forms
  • Create and populate a database in MySQL
  • Search a database using joins, groupings, and FULLTEXT searches
  • Change the search engine type of a table
  • Create indexes to improve the ability to search a database

Time: 2 hour(s)

PHP and MySQL: 7 Error Handling and Debugging

Description

This section provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.

Objectives

  • Identify error types
  • View, log, and debug errors
  • Adjust PHP's error reporting
  • Create custom error handlers

Time: 2 hour(s)

PHP and MySQL: 8 Using PHP with MySQL

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information.

Objectives

  • Describe how arguments and PHP functions relate to the database
  • Differentiate between simple and complex functions depending on execution results
  • Understand the importance of associative and indexed arrays.
  • Modify specific scripts to allow for secure data transmission
  • Update database records using PHP scripts

Time: 2 hour(s)

PHP and MySQL: 9 Developing Web Applications

Description

This section provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.

Objectives

  • Adjust behavior for server settings
  • Pass variables and values to a script
  • Edit existing records
  • Paginate query results
  • Make sortable displays
  • Use HTTP headers

Time: 3 hour(s)

PHP and MySQL:10 Cookies and Sessions

Description

This section provides the learner with information about using cookies and sessions with PHP to overcome the statelessness of the Web.

Objectives

  • Use cookies
  • Use sessions
  • Improve session security
  • Manage the relationship between cookies and sessions

Time: 3 hour(s)

PHP and MySQL:11 Web Application Security

Description

In this section, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.

Objectives

  • Prevent forms from being submitted multiple times
  • Validate form data
  • Define patterns and both match and replace them
  • Manage database encryption and decryption techniques

Time: 4 hour(s)

PHP and MySQL:12 Extended Topics

Description

This section covers extended PHP topics that are worth considering in your development work, but not related to every Web application.

Objectives

  • Upload a file in PHP
  • Develop JavaScript using PHP
  • Utilize output buffering
  • Identify Improved MySQL Extension functions
  • Describe the purpose of PEAR

Time: 2 hour(s)

PHP and MySQL:13 Content Management Example

Description

After taking this section, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.

Objectives

  • Create the advanced PHP scripts needed for a content management site
  • Update and add information with a database
  • Download files through PHP scripts and database interactions
  • Manage files through PHP scripts and database interactions

Time: 3 hour(s)

PHP and MySQL:14 User Registration Example

Description

This section provides an overview of the user registration system.

Objectives

  • Handle user registration
  • Activate accounts
  • Create login and logout scripts
  • Apply password management

Time: 3 hour(s)

PHP and MySQL:15 E-Commerce Example

Description

After taking this section, the learner will have the information and sample needed to create an e-commerce site using PHP and MySQL, including creating the database, creating the public and administrative pages, and managing the shopping cart.

Objectives

  • Create a database for an e-commerce site
  • Create the administrative pages for an e-commerce site
  • Create pages for a customer to browse the inventory and place orders from an e-commerce site

Create and manage an online shopping cart for your e-commerce site

 

Copyright Computer Institute
Last Updated: Monday, May 29, 2017
A+ Certification, Network+ Certification, Security+ Certification, Cisco Certification, CCNA Certification, CCNP Certification, Oracle OCA DBA Developer Certifications, Unix, Linux, CISSP, PHP MYSQL, VMware, MCSA, MCSE, Microsft Certification, MCITP, Microsoft Certified Solutions Associate, Microsoft Certified Solutions Expert, Project Management Certification, HTML5, JavaScript, Java Programming, Java Certification, CompTIA training, Online Training, Online Courses, E-commerce, Distance Learning, Hands-on Training, Testing Center,Computer Classes, Training in Alabama AL, Training in Montana MT, Training in Alaska AK, Training in Nebraska NE, Training in Arizona AZ, Training in Nevada NV, Training in Arkansas AR, Training in New Hampshire NH, Training in California CA, Training in New Jersey NJ, Training in Colorado CO, Training in New Mexico NM, Training in Connecticut CT, Training in New York NY, Training in District of Columbia DC, Training in Delaware DE, Training in North Carolina NC, Training in Florida FL, Training in North Dakota ND, Training in Georgia GA, Training in Ohio OH, Training in Hawaii HI, Training in Oklahoma OK, Training in Idaho ID, Training in Oregon OR, Training in Illinois IL, Training in Pennsylvania PA, Training in Indiana IN, Training in Rhode Island RI, Training in Iowa IA, Training in South Carolina SC, Training in Kansas KS, Training in South Dakota SD, Training in Kentucky KY, Training in Tennessee TN, Computer Training, IT Training