php mysql Database and Dynamic Web Design Training

web site database programming

Database and Dynamic Web Design In this challenging 6-lesson course you will learn principles for coding PHP—the technology that operates many e-commerce Web sites—and enables interactive tools and applications.

Working with instructor Alex Foley, you'll learn how to create Web sites using PHP and the MySQL database server. By learning the basic language syntax of PHP, you will design a database as part of a relational database system, set up mailing lists, and create discussion forums and a storefront. You'll even build a working shopping cart. There is no advanced Web technology background necessary for this course—but students will need a thorough knowledge of HTML, a Web-hosting account, and an interest in writing code.

On this page: enrollment details | instructor | class projects and objectives | prerequisites

Class Title: Database and Dynamic Web Design Start Date: Classes start daily. Enroll today and gain immediate access. Class Length: Three months of access to class materials and instructor feedback. Instructor: Alexander Foley Other details: Self-paced, online, 24 access to online learning environment
	Tuition: $803

Class Instructor Bio: Alexander Foley is an online development consultant and the Technical Director of The Credo Group, an online insurance marketing company. Alex has more than 10 years of Internet application development for a broad range of industries. Alex has managed and participated in all stages of application development for projects in a variety of languages, frameworks, and infrastructures. Alex has played a variety of roles in the development of large and small Internet-based applications for such notable corporations as New York Life, Mutual of Omaha, Prudential, Blue Cross Blue Shield, and MasterCard. LEFT: Image from Database and dynamic Web Design with Ialex Foley. Place hat in Cart? You'll build a complete database driven shopping cart that could (theoretically) sell this purple top hat.

Class Projects and Objectives:

This online class is packed with projects and tips.  Students can expect to:

• See how PHP and HTML cohabitate within a script.
• Learn how, when, and why to use variables.
• Discover and use the various types of operators.
• Learn how to use flow control structures within scripts.
• Create an HTML form with an accompanying PHP script for the "back end."
• Demonstrate a knowledge of basic PHP syntax.
• Design and implement a working HTML form and PHP script.
• Learn the elements that make up a database.
• Discover the wonderful world of database normalization.
• Become familiar with the basics of the SQL language, used to talk to database servers.
• Connect and manipulate a MySQL database using PHP.
• Demonstrate the knowledge of basic database design.
• Design and implement a working HTML form and PHP script that performs specific tasks.
• Ensure that the system is prepared to send mail.
• Learn about the structure of an e-mail.
• Use PHP to send mail to one or more recipients.
• Create a subscription mechanism for a mailing list.
• Demonstrate a knowledge of PHP and database syntax.
• Create a data scheme for a subscribers table, based on new parameters.
• Write (and use) a script that sends mail to all subscribers.
• Learn the hierarchy of what's contained within a forum.
• Define and create a user registration form.
• Develop the display mechanism for levels of the forum and its accompanying input forms.
• Demonstrate an understanding of discussion area logic and hierarchical structure.
• Use PHP and MySQL skills to add in some "extras" that will enhance the user experience.
• Learn how the hierarchical elements of a store are represented in a database.
• Define catalog items for the store. Build appropriate database tables.
• Create the display scripts for a storefront.
• Demonstrate an understanding of the logic and hierarchical structures within an online storefront.
• Make these templates aesthetically pleasing.
• Use PHP and MySQL to create an administrative area for storefront maintenance.
• Learn about the elements of a shopping cart.
• Turn an item detail script into a form for adding items to a cart.
• Learn about the checkout process and apply some elements to the store.
• Demonstrate a knowledge of how the shopping cart and checkout process work, in the context of an online store.
• Integrate new features into an existing storefront design.
• Add omnipresent cart links, an Add to Cart script, a View Cart script, and a Remove from Cart script.
• Develop a set of rules regarding postage and tax costs, and implement these after a user performs a (simulated) checkout procedure.