
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.
|
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.
|
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 5: Changing Variable Types |
Variable Variables |
|
| |
|
| |
|
| |
Module 8: PHP’s Built-in Functions (Function Basics) |
Arguments
Return values |
|
| |
|
| |
|
| |
|
|
|
|
| Include_once0 and Require_once0 |
|
|
| Module 11: User-Defined Functions |
Function basics
Returning values
Using a variable number of arguments
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
|
|
| |
|
| |
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 |
| |
|
|
.
Microsoft Office
|
|
Creative Courses
|
|
Web Designing
|
|
|
|
|
|
|
|