Diploma in Web 2.0 Technology (Rich Internet Application)

Diploma by Compufield Computer Institute Mumbai View Contact

Starting from: INR 22,500 Per Course (Taxes As Applicable) Request Info

Learn: PHP Programming | AJAX | MySQL | XML | XSLT | Java Script | JSON

Category: Web Technologies | Database | XML

Medium of instruction:

English

Topics Covered:

• PHP

• AJAX

• MYSQL

• XML & XSLT

• JavaScript & JSON

 

 

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.

 

 

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.

 

Syllabus

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.

 

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

 

C & C++ (Basics)

1 C

1.1 Datatypes.

1.2 Operator.

1.3 Condition construct.

1.4 Looping construct.

1.5 Functions.

1.6 Array.

 

2 C++

1.1 Class.

1.2 Object.

1.3 Inheritance.

1.4 Functions.

1.5 Properties.

 

 

AJAX

Ajax (also known as AJAX), shorthand for "Asynchronous JavaScript and XML," is a web development technique for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with the server behind the scenes, so that the entire web page does not have to be reloaded each time the user requests a change. This is intended to increase the web page's interactivity, speed, and usability.

 

 

XML & XSLT

XML (Extensible Markup Language) a flexible text format for creating structured computer documents. It is a general-purpose specification for creating custom markup languages. XML's purpose is to aid information systems in sharing structured data, especially via the Internet to encode documents, and to serialize data. XML provides a basic syntax that can be used to share information between different kinds of computers, different applications, and different organizations without needing to pass through many layers of conversion. All major browsers like Google Chrome, opera, Firefox have support for XML and XSLT.

 

 

JavaScript & JSON

JavaScript is a popular scripting language that is widely supported in web browsers and other web tools

 

A scripting programming language most commonly used to add interactive features to webpages.JavaScript can make web pages more animated and dynamic in terms of graphics and navigation. One of the most common graphic JavaScript effects is called a mouseover, and Javascript navigation is commonly created using drop-down menus. JavaScript is used in millions of Web pages to add functionality, validate forms, detect browsers, and much more

 

Asynchronous JavaScript and XML (AJAX)

Salient Features

• XHTML (or HTML) and CSS, for marking up and styling information.

• The DOM accessed with a client-side scripting language, especially ECMAScript implementations such as JavaScript and JScript, to dynamically display and interact with the information presented.

• The XMLHttpRequest object is used to exchange data asynchronously with the web server. In some Ajax frameworks and in certain situations, an IFrame object is used instead of the XMLHttpRequest object to exchange data with the web server, and in other implementations, dynamically added <script> tags may be used.

• XML is sometimes used as the format for transferring data between the server and client, although any format will work, including preformatted HTML, plain text, JSON and even EBML. These files may be created dynamically by some form of server-side scripting.

 

Application

• tandards-based presentation using XHTML and CSS;

• dynamic display and interaction using the Document Object Model;

• data interchange and manipulation using XML and XSLT;

• asynchronous data retrieval using XMLHttpRequest;

• and JavaScript binding everything together.

• and JavaScript binding everything together.

 

AJAX Syllabus

Introduction

• Welcome

• System Requirements

 

Getting to know Ajax

• Downloading Data Behind the Scenes

• Modifying Web Pages on the Fly

• Searching in Real Time with Live Searches

• Getting the Answer With Autocomplete

• Dragging and Dropping HTML Elements With Ajax

 

Writing Ajax

• Working With JavaScript in Browsers

• Creating an XMLHttpRequest Object in JavaScript

• Checking the XMLHttpRequest Object's readyState

• property

• Checking the XMLHttpRequest Object's status property

• Getting Your Data With the XMLHttpRequest Object

• Problems creating an XMLHttpRequest Object

• Fetching Text Data From the Browser

• Decoding the Fetched Data

• Selecting Relative or Absolute URLs

• Getting XMLHttpRequest Objects in Other Ways

• Using Server-Side Scripting

• Storing Ajax Data in XML

• Passing Data to the Server with GET

• Passing Data to the Server with POST

 

Getting More Ajax Power

• Determining Which Browser the User Has

• Handling Head Requests for More Data

• Creating a Live Search Pt.1

• Creating a Live Search Pt.2

• Connecting to Google Suggest

• Calling a Different Domain Safely

• Using Two XMLHttpRequest objects

• Handling Multiple XMLHttpRequest Requests

• Returning JavaScript Objects From the Server

 

Creating Ajax Applications

• Downloading Images Using Ajax

• Creating a Shopping Cart

• Handling Mouse Events

• Enabling Dragging

• Handling Drops

• Communicating With the Shopping Cart on the Server

• Creating an Ajax-driven Drop-down Menu System

• Downloading Data with Drop-down Menu System

• Displaying a Menu with a Drop-down Menu System

 

Using XML With Ajax

• Understanding XML

• Loading XML into a Browser Object

• Navigating through XML Documents Using JavaScript

• Extracting data from text nodes

• Handling White Space in Mozilla and Firefox

• Accessing Attribute Values in XML Elements

• Accessing XML Elements by Name

• Validating XML You Get From the Server

• Validating XML With a DTD

 

Using CSS With Ajax in Web Pages

• Introducing CSS

• Setting Styles

• Using an External Style Sheet

• Working with Text Styles

• Setting Colors and Backgrounds

• Getting Newly-displayed Text Noticed

• Showing Ajax Results

• Hiding Ajax Results

• Positioning Elements

• Positioning Elements: Absolute Positioning

• Positioning Elements: Relative Positioning

• Stacking

 

Using PHP and Ajax

• Using PHP in Web Pages

• Understanding Basic PHP Syntax

• Working With Variables

• Working With Operators

• Working With Strings

• Working With Arrays

• Making Choices With the if Statement

• Using the switch Statemen

• Using for Loops in PHP

• Using while Loops in PHP

• Sending Data to the Server

• Extracting Data from Checkboxes

• Extracting Data from Radio Buttons

• Extracting Data from Listboxes

• Uploading Files

• Reading Uploaded Files

• Redirecting the Browser

 

Doing It Right: Ajax Best Practices

• Handling the Back Button

• Remember - Google Can't See Your Ajax Content

• Watching Out for Browser Caching

• Giving Visual Cues

• Wrap-up

 

 

XML & XSLT

 

Salient Features

• XML is designed to transport and store data.

• With XML You Invent Your Own Tags.

• XML Separates Data from HTML.

• XML Simplifies Platform Changes, Data Sharing and Data Transport.

• XML is Used to Create New Internet Languages like XHTML,WSDL, WAP and WML, RSS.

 

Application

XML's support for identity, storage and structure means it is possible to publish to the Web (as HTML) as well as to paper (as PDF) and to other formats (eg Braille, Audio, etc) from a single source document by using the appropriate stylesheets. XML is also very heavily used for enclosing or encapsulating information in order to pass it between different computing systems which would otherwise be unable to communicate. Weather services, e-commerce sites, blog newsfeeds, AJAX sites, and thousands of other data-exchange services use XML for data management and transmission, and the web browser for display and interaction

 

Application

• Transform XML schema to another schema.

• A food retailer may represent an order based on one schema while the manufacturer may represent it with another. With XSLT, a customer order taken by the retailer can be transformed into an order that matches the manufacturer's requirements.

• Transform XML documents into HTML.

• New Internet devices may not understand XML, but almost always will support HTML

• XSLT transformations

• Transform XML to HTML for devices such as handheld PCs, mobile phones, and TV set-top boxes

• Transform XML documents into PDF. Printers do not understand HTML, but almost always accept the Package Definition Format (PDF).

 

Syllabus of XML & XSLT

XML Basics

• What is XML?

• A History of XML and SGML

• How are people using XML?

• XML Support in Web Browsers

• IE 5 Support

• Netscape 6 Support

• Browser XML Chart

• Server-side XML

 

First XML Document

• XML Example

• The Tree Structure of XML

• XML Tools

• Technology we use

• Non-validating Parsers

• Validating Parsers

• Translating

• DOM & SAX

 

XML Syntax

• Differences between XML and HTML

• Differences between XML and HTML

• Common mistakes

• Quoting Attributes

• CAPITALIZATION

• Other Issues

• Required XML Elements

• XML Vocabulary

• XML Version 1 Resources

 

XML Elements and Attributes

• What is an Element?

• What is an Attribute?

• When should you use Elements and Attributes?

 

Using DTDs (Document Type Definitions) I

• What is a Document Type Definition?

• Declaring use of a DTD in your XML file

• Internal or External, or none?

• What is a Content Model?

 

Using DTDs (Document Type Definitions) II

• Elements

• Attributes

• Entities

• Examples

• DTD: The Specifics

• ANY and EMPTY

• Aside: XML Schema

 

XSLT Topices Covered (20 hours)

• XSLT Basics

• eXtensible Stylesheet Language

• The Transformation Process

• An XSLT Stylesheet

• Output Types

• Elements and Attributes

• XPath

• XPath in XSLT

• XPath Expression

• Location Paths

• Node Test

• Axis

• Predicate

• Accessing Nodes

• Abbreviated Syntax

• Accessing Nodes with Abbreviated Syntax

• XPath Functions

• XPath Operators

• Using XPath Functions and Operators

• Flow Control

• Looping in XSLT

• Looping with xsl:for-each

• Sorting with XSLT

• Looping and Sorting

• Conditions with XSLT

• Conditionals

• Templates, Parameters and Variables

• xsl:apply-templates

• Using xsl:apply-templates

• xsl:call-template

• Passing Parameters

• Using xsl:call-template

• Removing Content

• Template Modes

• Template Priority

• XSLT Variables

• Multiple Documents

• Including XSLTs

• Importing XSLTs

• Conflict Resolution

• The document() Function

• Reusing Templates

• Working with Keys

• Key Basics

• Creating a Simple Key

• Improving Performance with Keys

• Improving Performance with Keys

• Grouping

• Grouping Songs By Artist

• Advanced Techniques

• Working with Numbered Lists

• Outputting Processing Instructions

• Copying Nodes

• Tying It All Together: XSLT

• Tying it all Together

• Transforming the Business Letter

 

 

JAVASCRIPT & JSON

Salient Features

• JavaScript was designed to add interactivity to HTML pages.

• JavaScript is a scripting language.

• A scripting language is a lightweight programming language.

• JavaScript is usually embedded directly into HTML pages.

• JavaScript is an interpreted language (means that scripts execute without preliminary compilation).

• Everyone can use JavaScript without purchasing a license

 

Application

Javascript is used for validation of WEB FORM input values to make sure that they will be accepted before they are submitted to the server. JavaScript can put dynamic text into an HTML page . It can respond to user actions quickly, making an application feel more responsive. Furthermore, JavaScript code can detect user actions which HTML alone cannot, such as individual keystrokes. Applications such as GMail take advantage of this: much of the user-interface logic is written in JavaScript. The wider trend of AJAX programming also exploits this strength.JavaScript can be used to detect the visitor's browser.

JAVASCRIPT & JSON Syllabus

• Javascript Basic

• Javascript Variables

• Javascript Operators

• Javascript Comparisons

• Javascript IF..ELSE

• Javascript Switch

• Javascript PopUp Boxex

• Javascript Functions

• Javascript For Loop

• Javascript While Loop

• Javascript Break Loop

• Javascript For..In

• Javascript Events

• Javascript Try..Catch

 

JS Objects Javascript Objects intro

• Javascript String

• Javascript Comparisons

• Javascript Date

• Javascript Array

• Javascript Boolean

• Javascript Math

• Javascript RegExp

• Javascript HTML DOM

 

Javascript ADVANCED Javascript Browser

• Javascript Cookies

• Javascript Validation

• Javascript Animation

• Javascript Image Maps

• Javascript Timing

Classroom - Regular
When	Duration	Where	Remarks	Price
Not Specified	150 Sessions	All Venues	1 session is of 1hr.	INR 22,500 Per Course (Taxes As Applicable)

Mumbai, Warden Road (Head Office):- Chinoy Mansion, First Floor, Block #2 Opp. St.Stephen's Church Warden Road, Mumbai - 400036, Maharashtra, India


Mumbai, Bandra West (Branch):- 1st Floor. O'Priya Building, Near Mehboob Studio Peter Dias Road Bandra West, Mumbai - 400050, Maharashtra, India


Mumbai, Andheri West (Branch):- Wembley Society, Shop No 3 Shastri Nagar, Lane no2, Lokhandwala Andheri West, Mumbai - 400053, Maharashtra, India

Compufield Computer Institute

COMPUFIELD® Computer Institute was started in 1985 by Mr. M. E. Khairaz to impart training in Internet, Digital Art, Multimedia, Software and Network Engineering. Today we offer many different courses covering the latest and most widely used software worldwide.

• Creative courses, Designing and Digital Video courses

• Multimedia and Internet courses

• Programming courses

• Network Engineering, MCSE, CCNA, CCNP

• Office Automation & Financial Application

• Kids courses

 

Our Training

• Our courses are upgraded frequently to meet the ever changing standards of the Industry.

• Our Students design galleries substantiate our claim of providing our students a creative and informative learning environment directed at all round growth.

• Our faculty are highly experienced in the respective software and help the students in the best possible manner.

• We have state of the art Hardware and Software facilities.

• We offer Crash courses of 6-10 hours per day to students who wish to complete their learning in a short period.

• Professional Job Assignments and Tutorials have been devised to help students practically apply what they learn.

• After successful completion of the course, job assistance is provided by us.;

 

We offer a unique style of learning -

• One computer : One student : One Instructor

• Maximum Instructor to Student Ratio 1:4

• Sessions : Each session will be of 1 hour

• Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)

• Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.

• The timing can be fixed based on our mutual convenience,
  between 9.00 a.m. to 7.00 p.m.

• Course duration in working days = Total sessions divided by number of sessions (hours) per day.

• No extra charges/refund for more/less time taken to complete the course.

• Lodging, boarding and travelling not included in the fees.

• Management has full right to change courses, contents, tuition fees without prior notice.