Application Development on Open Source Environment

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

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