| |
| 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 |
| |
| Salient Features |
| |
| 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 |
| |
| PHP is a powerful cross platform server side script language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create images, read & write files, talk to remote servers - the possibilities are endless. |
| |
| Salient Features |
| |
| PHP is an HTML-embedded 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 pages quickly |
| |
| Application |
| |
| Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. PHP and MySQL are the world's best combination for creating data-driven sites. |
| |
PHP Mysql Topice Coverd  |
| |
| 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 |
|
Minimum Pre-requisites
1)
Basics of 'C' Programming Language.
2)
OOPS & C++ (Class, object, Inheritance)
3)
Any database (Access/SQL/Oracle) |
| |
| C & C++ (Basics) |
| |
1
1.1
1.2
1.3
1.4
1.5
1.6 |
C
Datatypes.
Operator.
Condition construct.
Looping construct.
Functions.
Array.
|
| |
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 10 sessions of 1 hr. each |
2,000 |
60 |
|
| |
2
1.1
1.2
1.3
1.4
1.5 |
C++
Class.
Object.
Inheritance.
Functions.
Properties.
|
| |
|
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 10 sessions of 1 hr. each |
2,000 |
60 |
|
| |
| |
+91-22-23676218 / 23671772