| |
| 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,000 |
60 |
|
| |
2
1.1
1.2
1.3
1.4
1.5 |
C++
Class.
Object.
Inheritance.
Functions.
Properties.
|
| |
|
|
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 10 sessions of 1 hr. each |
2,000 |
60 |
|
| |
| |
+91-22-23676218 / 23671772