Training Calendar

Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

psmb

Total Visitors

50%United States United States
27.5%China China
15%Canada Canada
5%Malaysia Malaysia
2.5%United Kingdom United Kingdom

Last Week: 3
This Month: 3
Last Month: 26
Total: 50067

Web Application Development Using PHP and Oracle

 

Course Overview

Learn how to leverage the PHP language and the Oracle database to generate dynamic and interactive web applications. This course is a four-day course which presents a wide array of useful tools for PHP-Oracle developer. These tools are all native to PHP and include quick data retrieval, easy forms and reports, and dynamic code. It covers the fundamentals of PHP programming, introduction to Oracle database, some advanced features of the Oracle such as Store Proc, Tidal Job, Cron Job, and creation of database driven applications using PHP and Oracle. Exercises are used to demonstrate the many features of PHP with Oracle, including the installation and use of Zend Server, Oracle Express Edition, Oracle SQL Developer, and Adobe Dreamweaver CS5.5.

 

 

Pre-requisites

Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites

 

PHP & Oracle – Schedule

Day 1

09.00am – 10.00am

Installation of Needed Software

  • PHP
  • Apache server
  • Oracle server
  • Oracle Client DLL
  • Oracle Client Tool
  • Configure Oracle server and Oracle client Tool
10.00am – 10.30am

Breakfast

10.30am – 12.45pm

PHP Fundamentals

  • Language fundamentals
    • PHP Basics
    • PHP Data types
    • Storing & retrieving information in variables
    • Basic operations with variables
    • Variable rules
  • Decision making in PHP
    • Comparison operators
    • The if construct
    • The while construct
    • The for construct

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

  • Arrays and PHP
    • Working with arrays
    • Sorting arrays
    • Other array related functions
    • Multi-dimensional arrays
  • Re-using PHP code
    • Functions
      • Declaring functions
      • Passing data by reference
    • Including code in scripts
    • Variable scope in PHP
  • PHP and the WWW server
    • Working with web forms
    • PHP POST & GET form elements
    • Embedding forms with PHP code
    • Validating form data
    • Preventing spoofed submissions
    • Guidelines for secure PHP
    • Understanding magic quotes
    • Setting default values in forms
    • Processing uploaded files
    • Retrieving & sorting uploaded files

Day 2

09.00am – 10.00am

PHP in Web

  • Managing web sessions
    • Using PHP session handling
    • PHP cookie handling
  • Handling date & time in PHP
    • Displaying dates & times
    • Parsing a date or time
    • Generating relative times
  • Working with files in PHP
    • Reading & writing files with PHP
    • File permissions
    • Handling errors

 

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

  • Sending email using PHP
    • PHP Email settings
    • Sending text messages using PHP
    • Sending HTML formatted email messages using PHP
  • Debugging PHP Code
    • PHP Error handling
    • PHP debugging tools
    • Suppressing errors

 

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

How to Use Oracle Client Tools

  • Create user (Normal & Admin)
  • Create Schema
  • Assign user to schema
  • How to create schema and table via tool

Oracle Table: Column and Data Type

  • Create tables
  • Create column
  • Column naming convention and restriction
  • Column data type: Number and Characters
  • Modify/Alter column: name and data type
  • Microsoft Visio: Design data model
  • Microsoft Visio: Generate script

                                                                        Day 3

09.00am – 10.00am

How to Program In Oracle: SQL & PL/SQL

  • Manipulating data in SQL
    • SQL: The SELECT statement
    • SQL: Overall SELECT syntax
    • SQL: Selecting values to display
    • SQL: Restricting selections using the WHERE clause
    • SQL: Using ORDER BY to sort query results
    • SQL: Using LIMIT to limit result sets
    • SQL: INSERT statement
    • SQL: UPDATE Statement
    • SQL: DELETE Statement
    • SQL: TRUNCATE TABLE statements

 

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

  • SQL: create trigger, constraint, dependencies
  • PL/SQL: create function, store proc, view
  • Indexing

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Accessing Oracle Databases Using PHP

  • Download and Install ADODB
  • Create Data Source Name (DSN)
  • Setting connection to the database via PHP
  • Executing SQL statements
  • Executing prepared statements
  • Multiple statement execution
  • Retrieving information about queries (metadata)
  • Transactions and queries
  • Retrieving data from a database
  • Single-step queries

                                                                        Day 4

09.00am – 10.00am

Bootcamp: User Registration

  • How to connect to Oracle via PHP component
  • Create signup page
  • Insert: SQL Query from PHP
  • Update: SQL Query from PHP
  • Delete: SQL Query from PHP
  • Select: SQL Query from PHP
  • Dataset, DataReader, DataSource

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

PHP and Oracle Store Proc

  • Insert via Store Proc
  • Update via Store Proc
  • Delete via Store Proc
  • Select via Store Proc
  • View

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

PHP Backend Application with Oracle Database

  • Tidal Job
  • Cron Job
  • Calling PHP class using shell script

Oracle DBA

  • Table security
  • User account setting, expires, block, unblock
  • Tuning