|
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. |
|
JOOMLA |
|
Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone. |
|
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 Topice Coverd |
|
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 |
|
Joomla |
|
Salient Features |
|
~ |
Free source code |
~ |
Simple workflow system |
~ |
Caching mechanism to secure fast page creation with favorite pages |
~ |
Wastepaper basket |
~ |
Banner management |
~ |
Data manager for uploading and administering data |
~ |
Publication system for content |
~ |
Content summaries in RSS format |
~ |
Search-engine-friendly URLs |
~ |
Multilingual front end |
~ |
Macro language for data content (Mambots) |
~ |
Administration interface that is separated from the homepage |
~ |
Simple, expandable template, and component system |
~ |
Simple, but powerful template system (HTML, CSS, PHP) without a complicated |
~ |
template language |
~ |
Hierarchical user groups |
~ |
Simple visitor statistics |
~ |
WYSIWYG editor for content |
~ |
Simple polling |
~ |
System of evaluation for contents |
~ |
Free extensions at http://www.mamboforge.net |
~ |
After the split, a large and eager community of users and developers was quickly |
~ |
established |
|
Application |
|
~ |
Joomla is an award-winning content management system (CMS). |
~ |
A content management system is software that keeps track of every piece of content |
|
on your Web site, much like your local public library keeps track of books and stores |
|
them. |
~ |
Joomla is used all over the world to power Web sites of all shapes and sizes. |
~ |
Joomla is designed to be easy to install and set up even if you're not an advanced |
|
user. |
~ |
Joomla is the most popular open source CMS currently available as evidenced by a |
|
vibrant and growing community of friendly users and talented developers. |
~ |
Joomla is free, open, and available to anyone under the GPL license. |
|
Topics Covered |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
A Quick Glance into History
Joomla!—How was it Developed?
Structure of a CMS
Front End and Back End
Configuration Settings
Access Rights
Content
Templates
Extensions (Components)
Workflow
Joomla! as Real Estate
Joomla! Versions
Numbering System of Joomla! Versions
Roadmap
Joomla! Features
Examples of Joomla! Pages
Joomla.org
Porsche, Brazil
PC Praxis, Germany
BSI DANS, Norway
Team Lesotho, Lesotho
|
|
Installation |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Setting Up the Local Server Environment
Windows
XAMPP for Windows
Linux
SUSE (10.x) OpenSUSE
Debian/Ubuntu
Your Own Server at a Provider
On a Virtual Server in the Net
Installing Joomla!
Selecting a Directory for Installation
An Example
Local Installation of Joomla!
Directory
Unpacking
Joomla! Web Installer
|
|
A Tour of Your New Homepage |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Front End
Menus
Top Menu
Main Menu
Other Menu
Content
What is Content?
First Page/Front Page
The Latest Messages/The Most Often Read Messages
Advertising
Banner Area
Functions
Login Area
Polling
Who is Online?
Feeds
Back
Search Field
Decorative Elements
Prospects
Back End
|
|
Customizing Joomla! |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
|
A Different Look and Feel
Modifying the Menu Name
Changing the Template
Configuration of Joomla! Administration
Help Menu
Site Menu
Global Configuration
Site
Locale
Content
Database
Server
Metadata
Mail
Cache
Statistics
SEO (Search Engine Optimization)
Language Manager
Media Manager
Preview
Statistics
Template Manager
Site Templates
Install
Administrator Templates
Install
Module Positions
Trash Manager
User Manager
New
Menu Manager
Customize Existing Menu
New
Edit
Publish
Unpublish
Move
Copy
Trash
Create a New Menu
Content
Miscellaneous
Components
Links
Installers Menu
Messages Menu
Inbox
Configuration
Configuration
System Menu
Global Check-In
Top of the Page |
|
Managing Content |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Content by Section
Section
Category
Add/Edit Section Category
All Content Items
Static Content Manager
Content Parameters
Publishing
Images
Parameters
Meta Info
Link to Menu
Section Manager
Category Manager
Frontpage Manager
Archive Manager
|
|
Components, Modules, and Mambots |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Components Menu
Installing and Uninstalling Components
Installed Components
Banner
Manage Clients
Manage Banners
Contacts
Manage Contacts
Contacts Categories
Mass Mail
News Feeds
Manage Newsfeeds
Manage Categories
Polls
Syndicates
Weblinks
Weblink Items
Weblink Categories
Module Menu
Install/Uninstall
Site Modules
All Menus (mod_mainmenu)
Banner
Login Form
Syndicate
Statistics
Template Chooser
Archive
Sections
Related Items
Wrapper
Polls
Who's Online
Random Image
Newsflash
Latest News
Popular
Search
Administrator Modules
Logged
Components
Popular
Latest Items
Menu Stats
Unread Messages
Online Users
Quick Icons
System Message
Pathway
Toolbar
Full Menu
Copying a Module
Mambots Menu
Installing New Mambots
Site Mambots
Search Mambots
|
|
Forum, Comments, and Calendar |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Forum
What can Simpleboard do?
Installation of Simpleboard
Uninstallation
Simpleboard Administration
Simpleboard Configuration
Forum Administration
User Administration
Uploaded Files Browser
Uploaded Images Browser
Edit CSS File
Prune Forums
Prune Users
Support Websites
Load Sample Data
Update Database to Version 1.1.0 Stable
User Front End
Set Up a User Profile
Simpleboard Module
Installation
Comments
Installation
Administration
View Comments
Edit Settings
Edit Language
Front End
Calendar
Installation
Configuration
Events Config
Manage Event Categories
User Front End
Module
Event Mambotv |
|
Image Gallery and Document Management |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Gallery
zOOm Media Gallery
Installation
Administration
Gallery Manager
Media Manager
zOOm Thumb Coder
Settings
Optimize Tables
Update zOOm Media Gallery
Integration of the Gallery into your Website
User Front End
Lightbox
E-Cards
Comments and Ratings
Modules for the zOOm Media Gallery
Document Management/Download Area
Installation
Administration
Categories
Group
Files
Documents
Licenses
Themes
Configuration
Updates
Statistics
Integration into the Website
Modules
Mambots
|
|
E-Commerce and I18N |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
|
Online Store
Installation
Configuration
Work on Store Data
Add Tax Rates
Configuration
Product Categories
Joomla! Configuration
The Order Process
Order Administration in the Back End
Modules
Mambots
Joomla! Internationalization
Installation of a Different Language File
Translation of a Menu Entry
Multilingualism with MambelFish
Installation of MambelFish (Component and Module)
MambelFish Configuration
Translation with MambelFish
Mambot for MambelFish
Integrate your Own Components into MambelFish
|
|
Your Own Templates |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
Corporate Identity
HTML/XHTML, CSS, and XML
HTML/XHTML
CSS
In the Central HTML File
In a Separate CSS File
Within an HTML Tag
Combinations
XML
Create Your Own Templates
Concept
Fixed Size or Variable Size
Structure
HTML Conversion
File Structure of the Template
First Trial Run
Integration of the Joomla! Module
Creating a Template Package
Installation with the Joomla! Template Installer
Creating Templates with Dreamweaver Extension
Installation
Create New Template File
Template Structure
Insertion of the Joomla! Modules
Live Site
Templates and Tags
Barrier Free Joomla!
Criteria for Accessible Websites
Clarity
Browser Compatibility
Valid Source Code and Logically Structured Page Architecture
Contrasts
Graphics and Pictures
Font Sizes
Additional Criteria and Information
The Reality
Is Joomla! Barrier-Free?
Is it Possible to make Joomla! Barrier-Free?
The Technology
The People
Barrier-Free Sites with Joomla!
|
|
Your Own Program Extensions |
|
~
~
~
~
~
~
~
~
~
~
~ |
Sample joomlabook Component
The MySQL Table
The Front End
Integration into the Main Menu
Joomla! Administration
Create Installation Package
Modules
Source Code
Installation
View of the Website
Mambots
|
|
|
Minimum Pre-requisites
1)
Basics of 'C' Programming Language.
2)
OOPS & C++ (Class, object, Inheritance)
3)
Any database (Access/SQL/Oracle) |
|
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 |
|
|
|