I learnt how to create my own quizes, and manage a portal. The hands-on practice with instant trouble shooting with the training was very helpful. - Lee Teck Hong, Hwa Chong Singapore.
The training met my expectations. Each individual lesson was short, organized and easy to understand and do. I liked the interactive sessions the bost - Thomas Kong, Singapore
I liked the hands-on exercises, and was able to create a database driven application within the 3 days of the course - Judy Lim, ITE College East, Singapore
The greatest strength is the hands-on exercises & tips on using PHP & Mysql for real life projects - SIM University
I liked the clear instructions and guides to recommended sites - ABN AMRO N.V.
Everything is great about this workshop. I most liked the hands-on approach to PHP & MySQL database programming - Chung K Y, Temasek Polytechnic
View the Latest PHP & MySQL Training Schedule to reserve a seat.
Develop Web Applications with PHP & Oracle
Training Course Name : Learn to Develop Web Application with PHP & Oracle Database
Course Duration : 3 Days
Course Objective for PHP & Oracle Web Application Development:
Learn how to leverage the PHP language and the Oracle database to generate dynamic & interactive web applications.
This course covers the fundamentals of PHP programming, Introduction to Oracle database, some advanced features of the language, and creation of database driven applications using PHP & Oracle
Course Overview for Web Application Development with PHP & Oracle db:
You Will Learn How To:
- Write effective, efficient PHP scripts
- Embed PHP scripts in HTML pages to create dynamic Web pages
- Manipulate data from Web page forms
- Structure PHP code using user-defined functions and external libraries
- Develop database-enabled Web applications using Oracle database
Recommended Pre-requisites:
Some understanding of programming concepts, HTML, and experience working with a DBMS is recommended prior to attending this course.
PHP & Oracle Db: Course Outline
* Introduction to PHP
o PHP's role in the WWW
* Language fundamentals
o PHP Basics
o PHP Data types
o Storing & retrieving information in variables
o Basic operations with variables
o Variable rules
* Decision making in PHP
o Comparison operators
o The if construct
o The while construct
o The for construct
* Arrays and PHP
o Working with arrays
o Sorting arrays
o Other array related functions
o Multi-dimensional arrays
* Re-using PHP code
o Functions
+ Declaring functions
+ Passing data by reference
o Including code in scripts
o Variable scope in PHP
* PHP and the WWW server
o Working with web forms
o PHP POST & GET form elements
o Embedding forms with PHP code
o Validating form data
o Preventing spoofed submissions
o Guidelines for secure PHP
o Understanding magic quotes
o Setting default values in forms
o Processing uploaded files
o Retrieving & Sorting uploaded files
* Working with Oracle
o A brief history of Oracle
o Relational database concepts
o Database tables
* Using the CREATE TABLE statement
* SQL Data types
o Integer data types
o Floating point data types
o Character data types
o Other SQL data types
* SQL column modifiers
* Manipulating data in SQL
o The SELECT statement
+ Overall SELECT syntax
+ Selecting values to display
+ Restricting selections using the WHERE clause
+ Using ORDER BY to sort query results
+ Using LIMIT to limit result sets
o The INSERT statement
o The UPDATE Statement
o The DELETE and TRUNCATE TABLE statements
* Accessing databases using PHP
o Downloading & Installing ADODB
o Creating a Data Source Name (DSN)
o Setting connection options & connecting to the database
o Executing SQL statements
o Executing prepared statements
o Multiple statement execution
o Retrieving information about queries (metadata)
o Transactions and queries
o Retrieving data from a database
o Single-step queries
* Managing web sessions
o Using PHP session handling
o PHP cookie handling
* Handling date & time in PHP
o Diplaying dates & times
o Parsing a date or time
o Generating relative times
* Working with files in PHP
o Reading & writing files with PHP
o File permissions
o Handling errors
* Sending email using PHP
o PHP Email settings
o Sending text messages using PHP
o Sending HTML formatted email messages using PHP
* Creating a Database Driven PHP Application with Oracle db at the backend.
* Debugging PHP Code
o PHP Error handling
o PHP debugging tools
o Suppressing errors
Project:
Create a Database Driven Web Application using PHP & Oracle - For example, create a Membership Application, an Orders Database, a CD shop catalogue & search project, or select a project of your own choice (after consultation with the trainer).
Certification:
Certificate of attendance would be given to participants.
Materials:
Notes in folders will be provided.
Class Size:
8-12 participants
How to Register for the 3 Day PHP & Oracle Workshop
Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at 6296-2995.
Call Kamini at 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class of PHP & Oracle database.
Note: This class is a very practical, and hands-on workshop session. It requires you to take part in PHP programming techniques during the class. A laptop pre-loaded with the necessary software is provided to each participant, for use during this workshop.
Join today, and Master PHP Applications with Oracle easily, with step by step instructions, and helpful, patient Trainers to guide you.
You can also join our 3 Day PHP & MySQL Workshop.