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.


    • 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

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

    • U301 – Linux System Administration (Server)

    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.

    • PC Workstation for use during training
    • Student Manual

    • U3065 – Apache Web Server Administration

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    © Euler. All rights reserved.
    Contact Us to Register