PMP® Exam Prep Tips

Receive PMP® Exam Preparation Tips & Project Management Articles

Current Promotions

PMP Exam Free Preview Session (Feb 9 and March 6, 2012)

Microsoft Project 2007 ($495 Only)

PHP & MySQL 

Microsoft PowerPoint 2007 (New Year Promotion)

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:
Intellisoft Systems PMI R.E.P.

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

 

Intellisoft Training Calendar   
View the Latest PHP & MySQL Training Schedule to reserve a seat.

Other Courses

Find out most popular courses
available at Intellisoft Systems

Course Enquiry
Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Pass Type (SG / PR / EP / SP / Others)
Number of Participants*
Home » IT Courses » Creating Database Applications with PHP & MySQL

Creating Database Applications Using PHP & MySQL


Course Contents: Creating Database Applications Using PHP


SDF Funding now Available . Call 6296-2995 for Details.

You Will Learn How To:

  • Install, Setup and Create a database using MySQL
  • Insert, Update, Delete Records in MySQL database tables
  • Write Queries against the MySQL database & Retrieve data using specific criteria
  • Write effective, efficient PHP scripts
  • Embed PHP scripts in HTML pages to create dynamic Web pages
  • Manipulate data from Web page forms
  • Track users as they navigate your site with cookies and other PHP features
  • Structure PHP code using user-defined functions and external libraries
  • Develop database-enabled Web applications using MySQL ( You can also get an Introduction to MySQL database in a separate training class too)
Course Benefits

PHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of database servers, including Oracle, MySQL and Microsoft SQL Server. In this introductory course, you gain a solid foundation for incorporating PHP techniques. Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content.

Who Should Attend

Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Programming or PHP experience is helpful but not required.

Hands-On Training

In this course, you develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web page. Exercises include:

  • Creating A MySQL Database, Creating Tables, Fields, and Inserting Records in the MySQL Database tables
  • Selecting Data from the MySQL database using various filtering criteria techniques.
  • Sort, Format and Convert MySQL data using specific MySQL Functions and features.
  • Generating Web pages dynamically using PHP
  • Retrieving and manipulating form data
  • Personalizing Web site content using cookies
  • Tracking user navigation on your Web site
  • Integrating database content to generate dynamic Web pages
  • Building modular scripts to enable code reusability
 

Creating Database Applications Using PHP & MySQL

Introduction to PHP

  • Origins of PHP in the open source community
  • Availability across multiple platforms
  • Installing as a module for Apache Web Server and Microsoft Internet Information Server
  • Running as a CGI engine for other Web servers
PHP language building blocks
  • Comparing PHP with other Web scripting languages
  • Investigating PHP data types
  • Integers, Floating point values, Strings, Booleans
Writing PHP scripts
  • Storing values in scalar variables
  • Employing ordinary and associative arrays
  • Writing conditional expressions
  • Implementing loops such as while, for and foreach
  • Building complete scripts incorporating loops and conditional expressions
Writing Web Pages with PHP
 
Interacting with the server
  • Embedding PHP code into HTML pages
  • Determining how data is sent from forms to PHP scripts
  • Creating dynamically-generated hyperlinks to call PHP scripts
Manipulating user input
  • Presenting the user with input options via different HTML form elements
  • Retrieving form data with $_POST and $_GET arrays
  • Validating retrieved data
  • Strategies for handling invalid input
  • Storing state information using cookies
Applying Advanced Scripting Techniques
 
Exploiting the built-in functionality of PHP
  • Formatting date and time information
  • Manipulating string data
  • Reading and writing data using file I/O functions
  • Investigating other built-in features
Structuring PHP code
  • Writing user-defined functions to structure your code
  • Passing arguments and default values to functions
  • Returning data from functions
  • Accessing global variables
  • Building code libraries for reusability
  • Incorporating external PHP scripts with require and require_once
Building Complete Web Applications
Managing errors
  • Investigating the HTTP header
  • Suppressing on-screen error messages on production servers
  • Configuring the php.ini file to control error messages
Handling problematic situations
  • Troubleshooting problems when manipulating data
  • Redirecting the browser to other pages
  • Modifying the PHP configuration file to suit your needs
  • Developing debugging strategies
Establishing database connectivity
  • Creating and managing database connections
  • Sending queries to the database server employing the most efficient methods
  • Retrieving query results as associative arrays
  • Looping through databases
  • Displaying returned data on Web pages
  • Avoiding potential problems by managing quotes and backslashes in data
  • Closing the database connection
 

Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders will be provided.

Class Size:
8-12 participants


Call (65) 6296-2995 or (65) 9877-3485 to enquire about the PHP training course, or email to training@intellisoft.com.sg

PMP is a registered mark of Project Management Institute, Inc.
Home | Contact Us | Join Us