Web Database Programming with PHP & Oracle 10g

Price £590.00             Duration : 12 Weeks Part-Time

Starting Dates:          

Saturday

19 Feb 2005

Theory 6.30 – 9.30 pm, Practical 3.30-6.30 pm

Saturday

12 Mar 2005

Theory 3.30 – 6.30 pm, Practical 6.30-9.30 pm

Mon, Wed

14 Mar 2005

Theory & Practical 6.30 – 9.30 pm

Saturday

04 Jun 2005

Theory 3.30 – 6.30 pm, Practical 6.30-9.30 pm

Wed, Mon

23 Mar 2005

Theory & Practical 6.30 – 9.30 pm

The Internet and associated Web technologies have revolutionized the way the businesses market their products and brought fundamental changes to their traditional methods of customer relationship. The commercial scale of this revolution is staggering. The global e-commerce market for providing goods and services to businesses and consumers is set to top almost US$7 trillion by 2004. This represents 8.5% of all global sales, according to the independent company, Forrester Research.

As a result of this there is an acute but consistently growing market for professionals who are capable of designing, implementing and or maintaining e-commerce enabled web sites.

Realising this potential, we have put together the most comprehensive hands-on e-commerce course covering various essential web technologies and tools for individuals who would like to develop a career in e-commerce at professional level.

On successful completion of this course & project you will be able to

· Plan, design and implement a complete e-commerce solution
· Organize efficient hosting and maintenance of e-commerce sites
· Be aware of variety of tools and technologies used for e-commerce
· Create shopping carts, order processing and sales statistics systems
· Use one scripting languages for validations
· Create and maintain web stores and associated database systems

Course Contents

Introduction to e-Commerce & Web Technology
e-Commerce case studies, Current state of the affair
m-Commerce and the future
Web tools for efficient e-commerce practices
History of Internet and World Wide Web Architecture
Intranets in Enterprise Environment
Hyper Text Transfer Protocol (HTTP) and Server/Browser Connectivity
Microsoft’s .net vision and tools

Hand-coded HTML - Hypertext Markup Language
Creating an HTML Document
Adding Local and Remote hypertext links
Applying Images, Sounds, Colors and Special backgrounds
Creating Tables, Nested Tables and Changing Text Colors
Creating forms, Dynamic and Interactive forms
Using frames to enhance the site
Cascading Style Sheets (CSS)
CSS (External, Embedded and Inline styles)
Using Image Maps for creating Navigation

Hand-coded XHTML – Extensible Hypertext Markup Language
What is XHTML?
How does XHTML differ from HTML?
Tags every XHTML Web page must have
How do I publish a Web page on the Internet?
How do I validate my page using the W3C validation services?

CSS (External, Embedded and Inline styles)
Tables – Data Tables vs. Tables used for formatting
Create a form with XHTML form elements, attributes

Dreamweaver MX
Site Planning
Creating Sites
Designing Templates
Attaching Style sheets with the templates
Deriving content Pages from the templates
Content Formating
Paragraphs and layout
Working with Images
Working with Links, URLs and Navigation
Working with Tables, Frames and Editing HTML
Creating and Using Layers and animation

Fireworks MX
Introduction to Graphics with special consideration for Internet
Introduction to vector and Bitmaps Images
Editing Images, Backgrounds, Web formats for Graphics files
Making Icons and Buttons, Menu bars and Banners

Flash MX
Introduction to Flash
Objects in single & multiple layers
Using time line and Animations by frame
Using non Flash graphics
Creating Motion tweening objects
Creating Shape tweening objects
Creating Banners and Cartoons
Adding Sound

Java and Visual Basic Scripting
Understanding the basic concepts of VB Scripting and Java Scripting
Basic Command Syntax
Control structures
Writing functions
Event driven programs
Creating Interactive Forms, Frames, Documents and Windows

The MySQL DBMS & SQL
Installing mySQL
Using mySQL from the Command Line
Introduction to Tables and Recordsets
Creating & Droping Databases and Tables
Data Types
Exploring an Existing Database
Changing Tables & Fields
Entering & Updating Records
The Select Statement
Joins

Database Administration
Database Administration: Introduction
Database Security
Performance Issues

Database Design
Introduction to Database design
Normalization
Online Analytical Processing
Other Design Issues

Using Oracle 10g with PHP
Connecting a PHP script to Oracle 10g
Using iSQL
Using Recordsets
Request and Response Objects
Sending and recieving Data from a HTML Form
Displaying Data

e-Commerce Store
Designing an E-commerce Store
Database Design for e-Commerce Store
Customers Page
Administration Page

Using Oracle 10g Database for e-Commerce
Inserting and Retrieving Data
Updating and Deleting Data
Database search
Normal Search
Soundex Search
Paging through record Sets
Presenting Data to Users
Grouping Record Sets in Pages
Displaying Number of Results Found

Shopping Basket
Session Objects
Creating a Shopping Basket
Updating or Deleting Basket Items
Calculating Cost of Delivery
Continue Shopping
Completing the shopping
Understanding of e-Commerce Transactions
Payment by Credit Card online
Secure Socket Layer (SSL)

e-Commerce Store Administration Page
Creating a Site Administration Page
Users and Passwords
Password Authentication
Accessing data stored in the database
Managing with customers orders
Updating products in the database

Case Studies
A Secure Login System
A Sales Tracking System
A Catalog
A Database Driven Website
A Shopping Cart

NB: This syllabus may be changed time to time without notice