LAMP Administration

     This course covers the installation and troubleshooting of a "Linux, Apache, MySQL, PHP" (LAMP) installation. The student is taken through the steps required to install and configure MySQL, Apache, and PHP. Basic SQL syntax is covered to aid the student in modifying the user database and modifying access rights. Intermediate SQL syntax is covered to help the student troubleshoot the Database. PHP syntax is covered so the student understands and can troubleshoot test web page issues.

Topics Covered

  • LAMP Overview
  • MySQL Overview
    • Files and directory structure
  • MySQL Installation
    • Installing and compiling
    • Starting MySQL
    • Testing your installation
  • Basic MySQL Administration
    • Administrators account
    • User Accounts and Passwords
    • Invoking mysqld
    • MySQL administrative commands
  • Basic SQL and Administrative Skills
    • MySQL SQL syntax
    • Routine maintenance
    • Managing users
  • Intermediate SQL
    • Aggregate Functions
    • Joins
    • Functions
    • Triggers
    • Transactions
  • An Apache Primer
    • Apache from source code
    • Standard system layout
    • The Apache configuration file
    • Tuning options
    • Authentication
    • Integration with PHP
  • PHP Basics
    • Download and Installation
    • The php.ini file
    • PHP line syntax
    • Control structures
    • Functions
  • OOP PHP Basics
  • Accessing MySQL with PHP
  • Troubleshooting

Audience:

     This class is targeted to individuals who are installing, administering, and troubleshooting LAMP systems.

Prerequisites:

Benefits:

     Upon completion of this course the student will be able to install and configure Apache, MySQL, and PHP. They will be able to administer each of these applications and troubleshoot issues associated with each component. Being exposed to SQL and PHP language constructs, the student will be able to diagnose problems and identify the nature of their cause.

Furnished Materials:

  • Student Manual

Recommended Follow-On Course

Length:

  • 5 Days

Price:

  • $2,475

Training Dates:

Sign Up