Sl No.

Modules/ Topics

Duration (Hrs)

1.

Linux

• Linux Ideas and History

• Running Commands and Getting Help

• Browsing the File system

• User, Group and Permissions

• Standard I/O and Pipes

• Text Processing Tools

• Vim text editor

• Investing and managing processes

• Configuring the bash Shell

• Finding and Processing Files

20

2.

MySQL

• Installing MySQL
• Configuration of MySQL
• Introduction of Relational Database
• Database Design
• Creating Databases
• Tables, Indexes
• Insert, Delete and Update Data
• Querying MySQL
• Advanced Queries [Joins/Order By/Group By]
• Sub-queries
• Understanding MySQL Table Types
• Managing User privileges
• Administering Database
• Backup and Recovery
• Use PhpMyAdmin
• MySQL Workbench

30

PHP

• Introduction to web development with PHP
• Code of PHP application
• Use PHP within a MySQL database
• Use the MVC pattern
• Test and debug a PHP application
• Work with Form data
• Code control statement
• Work with strings and numbers
• Work with dates
• Create and use array
• Work with cookies and sessions
• Create and use functions
• Create and use objects
• Regular expressions, handle exceptions and validate date
• Professional PHP for working with MySQL
• Send E-mail and access other web sites
• Work with files, uploads & images
• Introduction of CMS

Apache

• Installation
• Adding Common Modules
• Logging
• Virtual Hosts
• Aliases, Redirecting and Rewriting
• Security
• SSL
• Dynamic Content
• Error Handling
• Proxies
• Performance
• Directory Listings