INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
 
CWNP Series
 
  CWNA  
  CWSP  
 
Network Security
 
  Intro. to Network Security  
  Ethical Hacker Program  
 
Linux
 
  Linux Fundamentals  
  Linux System Administration  
  Linux Internet Sys. Admin.  
 
Sun Java & J2EE
 
  Java Programming Language  
  J2EE  
 
Web Design & Programming
 
  HTML 4.0 and CSS  
  ASP  
  JavaScript  
  Dreamweaver MX  
  Flash MX  
  PHP & MySQL  
 
Graphic Design
 
  AutoCad 2004  
  Photoshop  
  3D Studio MAX  
  Adobe Premier  
 
Programming
 
  C Programming  
  OOP with C++  
 
Others
 
  SPSS Fundamentals  
  SPSS - Statistic Multivariate  
  Riset Pemasaran Dgn SPSS  
  Software Engineering  
  Crystal Reports 10  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 

This course provides the basic techniques to build any Web database application. The courseware includes a comprehensive collection of material useful as a course guide and further as a reference book for Basic Database Administration & PHP scripting. Some topics that will be discussed in this course are Building and using a MySQL database, Adding PHP to HTML files, Using the features of the PHP language, Using HTML forms to collect information from users, Showing information from a database in a Web page, and Storing information in a database.

 
 
Course schedule

Duration: 5 days.
To view the schedule for this class, click here.

Who should attend

The audience for this course include Database Administrators, Web Developers and programmers

Prerequisites

The participants should have a conceptual understanding of RDBMS and fair knowledge of SQL commands. The candidates should also be conversant with HTML and general programming logic.

Course Outline

INTRODUCTION TO WEB DEVELOPMENT
•  An Introduction to Web Development
•  HTML Basics
•  Advanced HTML

INTRODUCTION TO WEB DATABASE APPLICATION
•  Introduction to Web Database Application
•  Introduction to MySQL
•  Introduction to PHP
•  How PHP and MySQL Work Together?

SETTING UP YOUR WORK ENVIRONMENT
•  Setting Up MySQL Server
•  Setting Up PHP Server

BUILDING A DATABASE
•  Creating a New Database
•  Deleting a Database
•  Adding Tables to a Database
•  MySQL Datatype Names
•  Changing the Database Structure
•  Communicating with MySQL

MOVING DATA IN AND OUT OF THE DATABASE
•  Adding Information
•  Retrieving Information
•  Combining Information from Tables
•  Updating Information
•  Removing Information

PROTECTING YOUR DATA
•  Controlling Access to Your Data
•  Setting Up MySQL Accounts

GENERAL PHP
•  Adding a PHP Section to an HTML Page
•  Writing PHP Statements
•  Using PHP Variables
•  Using PHP Constants
•  Working with Numbers
•  Working with Character Strings
•  Working with Dates and Times
•  Comparing Values
•  Joining Comparison with and/or/xor
•  Adding Comments to Your Program

PHP BUILDING BLOCKS FOR PROGRAMS
•  Using PHP Arrays
•  Useful Conditional Statements
•  Using Loops
•  Using Functions

DATA IN, DATA OUT
•  Connecting MySQL and PHP
•  Getting Information from a Database
•  Getting Information from the user
•  Putting Information into Database

MOVING INFORMATION FROM ONE PAGE TO THE NEXT
•  Moving Information from Page to Page
•  Using PHP Sessions

 
 
 

 
 


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail: info@informit.tc

 
  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved