ISO 9001:2000 Certified Computer Institute
Why do Foreign/Indian Students prefer to study at COMPUFIELD?

LAMP
Linux, Apache, PHP & MySQL  

Linux
Linux is the operating system that's now used on the majority of web servers. Even if your organisation uses Microsoft Windows at the Desktop, you may find Linux behind the scenes.

Apache
Apache is the most used Web Server worldwide; it's available for free (Open Source) and bristling with facilities. On the course, we download, install and test apache. We configure Apache, including virtual host support, access security, MIME type handling, and add modules to support extra facilities. We also cover error handling and log file analysis.

PHP
PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML.

PHP's language syntax is similar to C's and Perl's. It generally runs on a web server like Apache which is configured to take PHP code as input and create web page content as output. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP is installed on more than 20 million websites and 1 million web servers.

MySQL
MySQL is one of the most popular open source database management system recognized for its speed and reliability. It is commonly used with web pages. More than 11 million Websites are built around MySQL.

Current MySQL customers such as eBay, Google, Twitter, Yahoo, Facebook, and YouTube, SlashDot, LiveJournal are perfect examples of how MySQL is used to organize and store multiple databases that can be quickly accessed by millions of people at once.




Linux Apache PHP MySQL

Enquire About This Course     Name :     *Country Name :     e.g.India, UK, .... Residence / Office Number : Country Code City Code Number     (Number-Coutry code & city code) e.g. +91-22-23676218       Mobile Number :       *Email :       *Course Of Interest :       Enquiry :     (*) Signed fields are mandatory.



LINUX

SALIENT FEATURES
Linux has gained considerable momentum as the operation system of choice for deploying the Database Servers for intranet and internet web portals. This course offers sufficient knowledge to build and host Database server on linux using MySQL as RDBMS and PHP as scripting language.

TOPICS COVERED:

Basics of Linux

• Introduction to Red Hat Linux
• Getting Started
• Login in Linux (GUI & Console)
• Directory Structure of Linux
• Listing Files & Directories (ls)
• Creating, Moving & Deleting Files and Directories
• Searching for Files (locate & find)
• Shells (Working effectively in the Command Line)
• File System Basics & File Management
• Pipes, Streams & Redirects
• Processes Management
• Finally the vi Editor

APACHE

SALIENT FEATURES
Apache web servers which, when used, provide a flexible, stable and configurable platform for organisations to deploy web based applications. You'll find the server in use on many large scale services - commercial, educational, voluntary sector, research and governmental.

TOPICS COVERED:

Apache httpd - an overview

• What is "Apache" and what does it do?
• Other web servers.
• Versions of Apache.

Apache httpd - Sourcing, Installation, Testing


• Downloading Apache.
  
• Selecting a user account under which to run Apache.
• Initial mandatory configuration.
• Testing your installation.
• Running apache as a daemon.

Further httpd Configuration


• Available Modules and turning them on and off.
• Assosciating file extensions with modules.

Apache httpd - virtual hosts


• Virtual Hosts
• Setting up so the browser can see multiple hosts
• Configuring virtual hosts

Apache httpd - log files and log tools


• Configuring the access and error logs.
• making logs available to the web site owner.
• Tools to analyse log files.
  

PHP

SALIENT FEATURES
PHP is an HTML-embedded server side scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of
unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated database
driven pages quickly.

APPLICATION
Open source has brought a lot more than Unix to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL
are the world's best combination for creating database-driven sites.

TOPICS COVERED

Working with PHP
Getting Started with PHP-Variables
Assigning Simple Variables Within a Script
	Delimiting strings Assigning arrays within a script Assigning two-dimensional arrays in a script
Accessing Variables Passed from the Browser
	HTML forms variables Passing arrays Cookies Sessions
Using Built-in Variables
	PHP variables Apache variables Other Web server variables
Testing Variables
	isset0 empty0 is_null0 is_int0 is_double0 is_string0 is_array0 is_bool0 is_object0 is_resource0 is_scalar0 gettype0
Changing Variable Types
	Variable Variables
Control Structures
The if Statement
	Determining true or false in PHP Comparison operators Logical operators Complex if statement if…else statements if…elseif statements
switch…case
Loops
	White… do…while for foreach continue and break
PHP’s Built-in Functions
Function Basics
	Arguments Return values
Function Documentation
Important PHP Functions
	String handling functions Regular expression functions Variable functions Type-conversion functions Array functions Object/class functions Print functions Date/time functions File-system functions Script Control functions Random number generator functions Session functions MySQL functions HTTP header functions Image functions Mail functions URL functions Error functions Output buffering Information functions
Writing Organized and Readable Code
Indenting
	Code blocks Function calls SQL statements
Includes
Include0 and Require0
Include_once0 and Require_once0
User-Defined Functions
	Function basics Returning values Using a variable number of arguments Variable scope
Object-Oriented Programming
	Classes, Continued Object cloning
Creating a Shopping Cart
	Creating a shopping Cart
	Where users can shop for Products and data stored in the backend
	Admin Module / Security
	Giving Accesstom Users / Clients / Admin Creating the entire admin module using seesions and cookies

MySQL


SALIENT FEATURES
It’s easy to use:
     MySQL software can be downloaded in less than 15 minutes.

It’s flexible:
     MySQL runs on more than 20 platforms, including Windows, Mac  OS X, and Linux, and its open source code allows you to customize it to fit your unique requirements.

It’s highly scalable:
     Whether you're looking to post a few things a month to your Web site or looking to add content daily, MySQL is fit to handle Web sites large and small and will easily grow as your business does.

It’s free: 
     A commercial license can be bought if you plan on redistributing it.

It’s secure:
    Security features ensure that only authorized users can access your databases.

It also provides 24/7 tech support and community support.

APPLICATION
Open source has brought a lot more than Unix to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL
are the world's best combination for creating database-driven sites.

TOPICS COVERED :

Database Design with My SQL
Why use a Relational Database?
Blasted Anomalies
	The update anomaly The delete anomaly The insert anomaly
Normalization
	First normal form Second normal form Third normal form
Types of Relationships
	The one-to-many relationship The one-to-one relationship The many-to-many relationship
Advanced Database Concepts
	Referential integrity Transactions Stored procedures
The Structured query Language for Creating and Altering Tables
Essential Definitions
	Null Values Indexes
The create database Statement The use database Statement The create table Statement
Column Types
	String column types Numeric column types Date and time types
Creating Indexes
Table Types
	MyISAM InnoDB Tables Berkeley DB Heap
The alter table Statement
	Changing a table name Adding columns Dropping columns Adding indexes Dropping indexes Changing column definitions
Using the show Command
	show databases show tables show columns show index show table status show create table
GUI Tools for Manipulating MySQL Tables and Data
	Using phpMyAdmin
The Structured Query Language for Inserting, Editing, and Selecting Data
	The insert Statement The update Statement The delete Statement The replace Statement
The Basic select Statement
	The Where clause order by limit group by and aggregate functions
Joining Tables
	The two-table join (equi-join) The multi-table join The outer join The self join Unions Correlated subqueries

LAMP
Linux, Apache, PHP & MySQL

Duration ( PHP & MySQL )	Fees (Indian RS.)	Fees (US $)
80 sessions of 1 hr. each	13,500/-	385





Minimum Pre-requisites
1)	Basics of 'C' Programming Language.
2)	OOPS & C++ (Class, object, Inheritance)
3)	Any database (Access/SQL/Oracle)




1.	C
	1.1	Datatypes.
	1.2	Operator.
	1.3	Condition construct.
	1.4	Looping construct.
	1.5	Functions.
	1.6	Array.

Course Duration ( C )	Fees (Indian RS.)	Fees (US $)
10 sessions of 1 hr. each	1,500/-	40




2.	C++
	2.1	Class.
	2.2	Object.
	2.3	Inheritance.
	2.4	Functions.
	2.5	Properties.

Course Duration (C ++)	Fees (Indian RS.)	Fees (US $)
10 sessions of 1 hr. each	1,500/-	40