Advanced Search 

 
  Train for a Better Future. Providing Quality Distance Learning Courses at Affordable Prices Date: 05/02/2012
Why Study with Us
•  Recognised qualifications
•  1000's successful students
•  Study at home at own pace
•  Latest course materials
•  Fast 1to1 tutor support
•  Flexible payment plans
•  Free UK P&P
•  Student community forum

Courses
Sage Courses
  Sage 50 Accounts
  Sage Instant Accounts
  Sage Instant Payroll
  Sage Payroll
 ICB Bookkeeping Courses
  ICB Upgrades
 ICB Membership & Exams
Business Practices
Accounting Books
Food Safety Course
Human Understanding
Child Care & Teaching Courses
Photography Course
Writing and Journalism
Web Design >>
  Web Design Home study course
  Web Design Online Courses
 ECDL

Customer Login
Email Address
Password
Open an Account
Forgotten Password

Newsletter
Please fill in your email address below to join our newsletter mailing list.

 Home Page - Web Design - Web Design Online Courses - PHP and MySQL Series

"PHP and MySQL Series"

PHP and MySQL Series

There are currently no reviews for this product. Be the first to review by clicking below!

Review this product...


Quantity:

Inc P&P: £110.00

  

Summary:

This series teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.

Audience:

This course is for anyone who would like to create dynamic Web sites using PHP and MySQL.

Features:

• Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Bookmarking tracks a learner's progress in a course.
• Exercises allow learners to practice in the actual application being studied.
• A glossary provides a reference for definitions of unfamiliar terms.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.

Includes:

Installing Required Software
•To install and configure MySQL
•To install and configure Apache with PHP
•To create MySQL users and grant privileges
•To test PHP and MySQL installations
•To configure PHP
PHP Basics
•Identify basic PHP syntax
•Create basic PHP scripts
•Send data to the Web browser
•Apply variables, strings, and constants to a PHP a script
Programming with PHP
•Handle HTML forms using PHP scripts
•Validate form data
•Manage arrays using various types of loops
•Work with magic quotes
Creating Dynamic Web Sites
•Create PHP scripts using multiple files
•Display and handle HTML forms within a single PHP script
•Create and call functions
•Create functions that take arguments and return values
•Set and alter variable scope
•Send email from a PHP script
SQL and MySQL
•Choose column types and other column properties
•Create databases and tables
•Insert records, select, update and delete data
•Use conditionals and functions
Advanced SQL and MySQL
•Normalize a database into First, Second and Third Normal Forms
•Create and populate a database in MySQL
•Search a database using joins, groupings, and FULLTEXT searches
•Change the search engine type of a table
•Create indexes to improve the ability to search a database
Error Handling and Debugging
•Identify error types
•View, log, and debug errors
•Adjust PHP's error reporting
•Create custom error handlers
Using PHP with MySQL
•Describe how arguments and PHP functions relate to the database
•Differentiate between simple and complex functions depending on execution results
•Understand the importance of associative and indexed arrays.
•Modify specific scripts to allow for secure data transmission
•Update database records using PHP scripts
Developing Web Applications
•Adjust behavior for server settings
•Pass variables and values to a script
•Edit existing records
•Paginate query results
•Make sortable displays
•Use HTTP headers
Cookies and Sessions
•Use cookies
•Use sessions
•Improve session security
•Manage the relationship between cookies and sessions
Web Application Security
•Prevent forms from being submitted multiple times
•Validate form data
•Define patterns and both match and replace them
•Manage database encryption and decryption techniques
Extended Topics
•Upload a file in PHP
•Develop JavaScript using PHP
•Utilize output buffering
•Identify Improved MySQL Extension functions
•Describe the purpose of PEAR
Content Management Example
•Create the advanced PHP scripts needed for a content management site
•Update and add information with a database
•Download files through PHP scripts and database interactions
•Manage files through PHP scripts and database interactions
User Registration Example
•Handle user registration
•Activate accounts
•Create login and logout scripts
•Apply password management
E-Commerce Example
•Create a database for an e-commerce site
•Create the administrative pages for an e-commerce site
•Create pages for a customer to browse the inventory and place orders from an e-commerce site
•Create and manage an online shopping cart for your e-commerce site
Subscription term: 12 months
 

Inc P&P: £110.00

  






This site and all contents are ©2003 Training Link - UK Provider Reference Number: 10008015
Email: info@training-link.co.uk   Telephone: 0800 594 2822
Basket
Basket
Checkout
Checkout

Your Basket...
Your basket is empty



Store Help
Terms And Conditions
Our Privacy Policy
Contact Us!
Testimonials
Site Map
Useful Links
Latest news and articles


Online Course


Secure Payments Powered by

Our Best Sellers
1. Level 1 Bookkeeping exam
2. Sage Line 50 Accounts Levels 1,2 &3 *Special Offer*
3. Level 2 Manual Bookkeeping exam
4. ICB Level 1 Certificate in Manual Bookkeeping
5. Level 2 Computerised Bookkeeping exam