Diploma In Web Designing, Multimedia, Engineering,E-commerce & Internet Global Marketing:INTERNET ADVERTISING & GLOBAL MARKETING

There are 600 millions documents on every possible subject and more than 1.5 million documents are uploaded everyday. The importance of "Variables" in the design of home pages to get maximum hits and hence achieve maximum marketing power.

We, at COMPUFIELD, teach you :

~
How to make your Web Site attractive and powerful, so that you can attract business globally on the Internet.
The importance of "Variable" in the design of home pages to get maximum hits and hence achieve maximum Marketing power.
How to use the different search engines available, and explain the working and retrieval functions of these search engines.
How to register your Web pages (URL'S) with various search engines like Yahoo, Altavista, Infoseek, Webcrawler, Hotbot, Excite, America Online, 123 India, khoj etc. (200 Search Engines possible).
How to register your Web Site to various BBS, Usenet groups, Enzines, Exchange banner scheme. Additional Global Marketing tricks available on Web. Mass E-Mailing.

C

C is a general purpose Programming Language. C has proven to be a pleasant, powerful, and versatile language for a wide variety of Programs. Many of the modern languages like C++, Visual C++, Java, JavaScript, etc. is based on C Language. Therefore, not Knowing this Language is considered as a handicap. 90% of UNIX Operating System is written in C Language.

C Topics Covered

Syntax
~
~
~ Compilers
Errors
Commenting your code

C Basics
~
~
~
~
~
~
~
~
~
~
~
~
~ History of C
Characteristics of C
Character set
Identifier
Underline ( Underscore '_' )
Keywords
We need Data and A Program
Constants
Operators
Some Terminology
Data Types Printing Out and Inputting Variables
Escape Sequence
Exercise

Control Constructs
~
~
~
~
~
~
~
~
~ if statement
else statement
else if statement
Nesting of if Block
For statement
While statement
Infinite loops
Programming Examples
Exercise

Remaining Control Constructs
~
~
~
~
~
~
~ goto statement
break statement
continue statement
switch statement
do-while statement
Programming Example
Exercise

Arrays
~
~
~
~
~
~
~
~
~
~ Declaring Arrays
Initializing Array
Printing Arrays
Taking Input for Arrays
Character Arrays
Array Dimensions
Initializing 2D Array
Array Sizes [size of operator]
Programming Examples
Exercise

Strings
~
~
~
~
~
~ What are strings
Reading a single character
Reading a line of text [string]
String handling functions
Programming examples
Exercise

Functions
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ Defining a function
Calling a function
Default return type and type void
Argument (Parameter)
Categories of functions
Function Prototype
Recursion
Scope and lifetime of a variable
Storage Classes
Automatic variable(internal or local variable)
External Variabel( Global Variable)
Static Variable
Register variable
Scope rule of a function
Passing an array to a function
Programming Examples
Exercise

Strings
~
~
~
~
~
~ What are strings
Reading a single character
Reading a line of text [string]
String handling functions
Programming examples
Exercise

PHASE - III

Structures and Unions

~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ Structures
Defining a structurs
Accessing structure members
Operations on structures
Structure Initialization
typedef
Arrays of structure
Arrays as structure members (fields)
Sending an entire structure as parameter to a function
Unions
Defining a Union
Initializing Unions
Arrays of Union variables
Unions inside structures
Final Remark on unions
Programming Examples
Exercise

Pointers
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ What is a pointer
Where is a pointer stored
'&'- The "Address Of" operator
what a pointer points to
Accessing Variables value using Pointers
Pointer Arithmetic
Equivalence between Pointer and Arrays
Pointer to an Array
Modifying Variables using pointers
Call by reference
Arrays of pointers
Arrays of char pointers
Pointers to functions
Pointers to structures
Passing pointer to structure to function
Structure within structure
Pointers to pointers
Programming Examples
Exercise

C Preprocessors
~
~
~
~ Preprocessor Directives
File Inclusion
Macro Substitution
Exercise

C Standard Libraries and Header Files
~
~
~
~
~
~ Header Files
Is the use of header file absolutely necessary?
Standard Library
Character conversion :
Time Functions :
Exercise


C++

C++ is a object oriented Programming language which includes concepts like polymorphism, data-hiding, operator overloading, encapsulation and inheritance, which are not observed in C. User defined objects (instances) can be reused with and without modifications to generate new application. This reduces coding to greater extent. Even for file accessing, we use file objects.


C++ Topics Covered

Introduction
~
~
~
~
~
~ History of C++
What is Object Oriented Programming
Application Of C++
A Simple C++ Program
Cascading of I/O Operators
Structure of a C++ Program

Tokens And Control Structure
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ Tokens
Data Types
Type Compatibility
Arithmetic Operators
Relational Operators
Logical Operators
Assignment Operators
Increment Operators
Conditinal Operators
Bitwise Operators
Special Operators
Operators in C++
Order of Precedence
Expressions
Operator Overloading
Control Structure
Simple if Statement
if - else Statement
switch Statement
do Statement
break Statement
for Statement
Additinaol features of for loop
Nested for

Arrays
~
~
~ Introduction
One dimensional Arrays
Two dimensional Arrays

Strings
~
~
~
~ Reading String From The Terminal
Reading Multiword String From The Terminal
String Hanling Functions
Table of Strings

Functions
~
~
~
~
~
~
~
~ The main() function
Simple C++ functions
Functions Prototying
Return Value and Their Types
Function Overloading
Friend And Virtual Functions
Programming Examples
Exercise

Classes
~
~
~
~
~
~
~
~
~
~
~
~ Revision of C Structures
Limitations of C Structures
Class
Creating Objects
Accessing Class Member
Defining Member FunctionsClasss And structures
Private Member Functions
Static Data Members
Static Member Functions
Array of Objects
Objects As Function Arguments
Friend Functions

Constructors And Destructors
~
~
~
~
~
~ Introduction
Default Constructor
Argumented constructor
Copy Constructor
Multiple Constructor
Destructors

Operator overloading
~
~
~
~
~ Definition
Overloading Unary Operator using Member function
Overloading Unary Operator using Friend function
Overloading Binary Operator using Member functio
Overloading Binary Operator using Friend function

Inheritance
~
~
~
~
~
~ Introduction
Base Class
Derived Class
Types of Inheritance
Virtual Base Class
Abstract Class

Virtual Functions And Polymorphism
~
~
~
~
~ Introduction To Pointers
Pointer To Object
this Pointer
Pointer to derived Classes
Virtual Functions

File Operations in C++
~
~
~
~
~
~
~
~ C++ Streams
Opening And Closing a File
Detecting End of File
File Pointers And Their Applications
Sequential Input And Output Operations
write() And read() Functions
More About open() : File Modes
Reading And Writing A Class Object

PHP+MySQL

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 Topics Covered

Part I: 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

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

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
Destructors
Exceptions


Working on a E-Commerce ( Shopping Cart ) Live Project

Click to view the live project the students would be working with during this course

Synopsis:

The data is stored in Products Table, Supplier Table, Category Table. Each product has a single supplier and single category.
Each supplier supplies multiple products under multiple categories

1) Login Page
The user will be authenticated before they enter the website for the correct username/password.
There are 2 types of users Admin / User, the admin would have administrative rights, where as a user will only be able to view the products

2) Search Page
After login, the user will be directed to a search page, where they can search for a product by selecting the supplier / category name.

In advance search, string searches can be done.

3) Product Result list
This page will return the result of the search criteria.
A single page will display the records dynamically from the database, 5 records at a time. Using the Next / Previous button users can navigate through the list of products

4) Details
Once the user clicks on the product name in the result list page, they are directed to the details page, where user can get the detail information with a image of the product

If the user is an admin, they would be given an option to add / update / delete If the user is not a admin, the following permissions will be disabled.

5) Add / Update / Delete
Displaying data from multiple tables using forms & Adding / Updating / Deleting data

6) Security
Extensive use of Sessions / Cookies for security purposes

7) E-Commerce Module
Once the above project is completed, it's taken to a next level where the e-commerce module is generated. Multiple Products can be added to the shopping cart, a dynamic bill is generated and user is forwarded to a payment gateway to complete the transaction.


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.

Mysql 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

Oracle - SQL

Oracle is a Relational Database Management System(RDBMS). Oracle is the latest technology, today's system Designers and Developers can build 21st century enabled applications. Oracle has also demonstrated a continuous ability to build products that help us exceed the demands of the information enabling age we live in.

Salient Featurs

~ Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.
~ Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
~ Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
~ Oracle provides open connectivity to & from other vendor's software.
~ Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

Application

~
~
~
~
~
~ Education Industry
Software Development Industry
Data warehouse and maintenance
Domestic Air Services
Production Industry
Banking Industry

ORACLE - SQL Topics Covered

~Writing Basic SQL Select Statement.
Restricting and Sorting Data.
Displaying Data from Multiple Tables.
Aggregating Data Using Group Functions.
Sub queries.
Producing Readable Output with iSQL*Plus.
Manipulating Data.
Creating and Managing Tables.
Including Constraints.
Creating Views.
Other Database Objects.
Controlling User Access.
SQL Workshop.
Using Set Operators.
Date time Functions
Enhancements to Group by Clause.
Advanced Sub queries.
Hierarchical Retrieval.
Extensions to DML and DDL Statements.

MICROSOFT SQL SERVER

SQL Server is the Database Management System(RDBMS) that allows to store huge Databases and manage the same easily. It is an enterprise database management and analysis system. ;

Salient Features

~

~

~

~


~



XML Support : Simplify the integration of your back-end systems and data transfer across firewalls using XML.
High Availability : Maximize the availability of your business applications with log shipping, online backups.
Automated Tuning : Automatic tuning and maintenance features enable administrators to focus on other critical tasks.
Improved Developer Productivity : User-defined functions, cascading referential integrity, and the integrated Transact-SQL debugger allow you to reuse code to simplify the development process.
Security : Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.
Data Transformation Services : Automate routines that extract, transform, and load data from heterogeneous sources.

Application

~
~
~
~
~
~
~ Multinational Companies with huge database to be maintained
Banking Industry
Production Industry
Data warehousing companies
Educational / Training Industry
Air-transportation Service Industry
Any business or service industry that stores database

Sql Server 2005 Topics Covered

Module 1:
~
~
~
~
~
~
~
~ Understanding Query Flow
Syntactical Flow of the Query Statement
Logical Flow of the Query Statement
From Clause Data Sources
Possible Data Sources
Named Ranges
[Table Name]
Four-Part Table Names

Module 2:
~
~
~
~
~
~
~
~
~
~
~ Where Conditions
Using the Between Search Condition
Using the In Search Condition
Using the Like Search Condition
Multiple Where Conditions
Select....Where
Ordering the Result Set
Specifying the Order by Using Column Names
Specifying the Order by Using Expressions
Order by and Collation
Select Distinct

Module 3:
~
~
~
~
~ Operators
Scalar Functions
User Information Functions
Data-Time Functions
String Functions

Module 4:
~
~
~
~
~
~
~
~
~ Inner Joins
Creating Inner Joins within SQL Code
Number of Rows Returned
Multiple Table Joins
Outer Joins
Outer Joins and Optional Full Outer Joins
Placing the Conditions within Outer Joins
Self-Joins
Multiple-Condition Joins

Module 5:
~
~ Using Unions
Intersection Union

Module 6:
~
~
~
~
~
~
~
~
~ Simple Subqueries
Using Scalar Subqueries
Using Subqueries as Lists
Using Subqueries as Tables
Simple Aggregations
Basic Aggregations
Grouping within a Result Set
Simple Groupings
Aggravating Queries

Module 7:
~
~
~
~
~
~ Why Use Views?
Working with Views
Creating Views with DDL Code
Order By and Views
View Restrictions
Executing Views

Module 8:
~
~
~
~
~
~
~
~
~
~ Inserting Data
Inserting One Row of Values
Inserting the Result Set from a Stored Procedure
Updating Data
Updating a Single Table
Deleting Data
Creating Tables
Creating Primary Keys
Primary Keys
Creating Foreign Keys

Module 9:
~
~
~
~
~
~ DDL Triggers
Creating and Altering DDL Triggers
EventData()
Enabling and Disabling DDL Triggers
Implementing Trigger

Module 10:
~
~
~
~
~
~ XML Data Type
Querying XML Data
Merging XQuery with Select
Reading XML into SQL Server
Creating XML with SQL Server 2005