Enquire About This Course
     
Name
     
Contact
     
Email
     
Enquiry
     

Upcoming Workshop
   
  Advance Excel 2 Days Workshop In Mumbai
   
  Schedule For May - June 2010
   
  Classroom Video -
1st May '2010
   
 
   
   

Microsoft Office
   
 
 
 
 
  MS-Excel-Macros
 
 
 
  MS-Project Management
 
 
Creative Courses
   
 
 
 
 
 
 
   
Network Courses
   
 
 
 
   
 
Web Designing
 
 
 
 
 
 
   
 
Programming Courses
   
  C Programming
  C++Programming
  Java
  PHP & MySQL
  LAMP
  SQL Server 2005
  Oracle 9i SQL & PL-SQL
  Advance Excel+VB(Part)
  DOT NET Technologies
  Crystal Report 11
  LAMP
Linux, Apache, PHP & MySQL

2 Days Workshop In Mumbai For
MS Project Management- Click Here



To study this course in classroom - CLICK HERE

Linux
Duration : 1 day

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. 

Sailent 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.

Basics of Linux
 
Module 1 : 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 & Directories

Searching for Files(Locate and Find)
Shells(Working effectively in command line)
File System Basics & File Management

Pipes, Streams & Redirects
Process Management
Finally the vi editor

Apache
Duration : 1 day

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. 


Sailent 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.

Basics of Apache
 
Module 1 : Apache httpd - an overview
What is "Apache" and what does it do?
Other web servers
Versions of Apache

 
Module 2 : 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
 
Module 3 : Further httpd Configuration
Available Modules and turning them on and off
Assosciating file extensions with modules
 
Module 4 : Apache httpd - virtual hosts
Virtual Hosts
Setting up so the browser can see multiple hosts
Configuring virtual hosts

 
Module 5 : 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


Introduction to PHP & MySQL 
Duration : 4 days

PHP is a powerful cross platform server side scripting language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create dynamic images, create e-commerce websites, manage security for online transactions, read & write files on the server, talk to remote servers - the possibilities are endless. MySQL is a small, compact database server ideal for stand-alone and enterprise applications.  The PHP-MySQL combination is also cross-platform. 

 
Sailent 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 developersto write dynamically generated database driven pages quickly.

 
Application

Open source has brought a lot more than Unux 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.

 
Working with PHP (Getting Started with PHP-Variables )
 
Module 1: Assigning Simple Variables Within a Script
Delimiting strings
Assigning arrays within a script
Assigning two-dimensional arrays in a script
 
Module 2: Accessing Variables Passed from the Browser
HTML forms variables
Passing arrays
Cookies
Sessions
 
Module 3: Using Built-in Variables
PHP variables
Apache variables
Other Web server variables
 
Module 4: Testing Variables
isset0
empty0
is_null0
is_int0
is_double0
is_string0
is_array0
is_bool0
is_object0
is_resource0
is_scalar0
gettype0
 
Module 5: Changing Variable Types
Variable Variables
 
Module 6: Control Structures (The if Statement)
Determining true or false in PHP
Comparison operators
Logical operators
Complex if statement
if…else statements
if…elseif statements
 
Module 7: switch…case (Loops)
While…
do…while
for
foreach
continue and break
 
Module 8: PHP’s Built-in Functions (Function Basics)
Arguments
Return values
 
Module 9: 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 function
URL functions
Error functions
Output buffering
Information function
 
Module 10: Writing Organized and Readable Code (Indenting)
Code blocks
Function calls
SQL statements
 
Includes
Include0 and Require0
Include_once0 and Require_once0
Module 11: User-Defined Functions
Function basics
Returning values
Using a variable number of arguments
Variable scope
 
Module 12: Object-Oriented Programming
Classes, Continued
Object cloning
Destructors
Variable scope
 
Working with PHP
 
Module 1: Creating a shopping Cart
Where usres can shop for Products and data stored in the backen
 
Module 2: Admin Module / Security
Giving Access to Users / Clients / Admin
Creating the entire admin module using sessions and cookies
 
Module 3: Minimum Pre-requisite to learn PHP
Basics of 'C' Programming Language
OOPS & C++ (Class, object, Inheritance)
Any database (Access / SQL / Oracle)
 

Working with MySQL
 
Database Design with MySQL
  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
  •    

     
    Home
    About Us
    Enquiry Form
    Web Develoment
    Site Map
      .
    Microsoft Office
    Creative Courses
    Web Designing
    Programming Courses
    Network Courses
       
    Contact us related to our Corporate IT Courses
    Mobile Number
    Facebook
    +91-9820134058 (Mr. Khairaz [MD])
    OFFICE : Chinoy Mansion, First Floor, Block # 2, Opposite Church, Warden Road,
    Mumbai (Bombay)-400 036
    ,India
    : 091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772
         
         
       
    [
    ][
    ][ Enquiry Form
    ][
    ][ Site Map
    ][
    Credentials ]