|
|
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. |
|
PHP Mysql Topics Covered |
|
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
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,500 |
70 |
|
|
|
|
2
1.1
1.2
1.3
1.4
1.5 |
C++
Class.
Object.
Inheritance.
Functions.
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 Topics Covered |
|
XML & XSLT |
|
Selient 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). |
|
XML & XSLT Topics Covered |
|
JAVASCRIPT & JSON |
|
Salient Features |
|
~
~
~
~
~
~
|
avaScript 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 Topics Covered |
|
Pre-Requisite
HTML
C & C++ (Basics)
Php & MySQL
|
|
|
Course Duration |
Fees (Indian RS.) |
Fees (US $) |
150 sessions of 1 hr. each |
22,500 |
650 |
|
|
|
|