Creating Database Applications Using PHP & MySQL
Course Contents: Creating Database Applications Using PHP
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)
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 & MySQLIntroduction to PHP
PHP language building blocks
Writing PHP scripts
Writing Web Pages with PHP
Interacting with the server
Manipulating user input
Applying Advanced Scripting Techniques
Exploiting the built-in functionality of PHP
Structuring PHP code
Building Complete Web Applications
Managing errors
Handling problematic situations
Establishing database connectivity
|
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



