See how a Course Works: Intro to Online Learning
Description
The PHP training course from Gatlin International provides a solid foundation in Web site development using MySQL and PHP. Our students complete a variety of course assignments that focus on learning how to write scripts and queries as well as building functional forms.
Upon completing the PHP training course, you'll have the skills you need to create an online catalogue that displays product information pulled from a PHP database.
Working with renowned our expert PHP instructor, Janet Valade, our students build a strong foundation for developing online mailing lists, customer accounts, product catalogues, user polls, forums, shopping carts, and much more.
The PHP training course form Gatlin International is technically challenging and students enrolling in this class should have a firm grasp of hand-coding XHTML and CSS and basic site development in Adobe Dreamweaver.
Take your career to the next level with PHP training from Gatlin International. Enroll today!
Outline
LESSON 2 Building and Using MySQL Databases
Most dynamic Web sites need a backend database. A database contains information that is displayed to users online, such as product information in a catalog. Lesson Two explores how to design, build, and access a MySQL database for a dynamic site. The lesson begins by explaining how MySQL works and showing how to access a MySQL database using a cPanel and phpMyAdmin. Next, you'll explore the basics of database design, learning how to define required information and structure database tables. Using phpMyAdmin, you'll learn to build a database and write SQL queries to add, retrieve, change, and remove data from it, as well as back up the database to your local development environment. In the exercise, you'll design and build a customer information database, and write SQL queries for typical customer information requests.
Additional Info
- Languages
- English
- Course Length
- 60.00 hours
- Duration of Access
Enrolled students have access to the class for six months. During this period, questions or assignments may be submitted at any time to the instructor. Each course lesson requires an average of 10 hours of study time.
- Instructor
Janet Valade is the author of five published books on PHP and MySQL: PHP & MySQL Web Development All-in-One Desk Reference for Dummies, PHP & MySQL: Your visual blueprint for creating dynamic, database driven Web sites, PHP & MySQL Everyday Apps for Dummies, PHP & MySQL for Dummies Third Edition, and PHP 5 for Dummies. Janet has also written a Dreamweaver book and a Linux book.
Janet has over 20 years experience in the computing field. Most recently, she designed and programmed the Web site for a small engineering firm, including programming the e-commerce functionality for the site and converting the documentation for the company products to Web documents. Prior to that, she provided technical support to faculty and staff at a large University for over 10 years, as well as providing systems analysis, designing and developing a state-wide data archive, and designing and presenting seminars and workshops on a variety of technology topics.
- Prerequisites/Audience
Courses are designed for adult learners interested in building skills and portfolio for a design career. To take the course, students simply require a computer (PC or Mac), an Internet connection (56 Kbps modem or faster), and any required software. For courses with software requirements, computers must meet software manufacturers' system requirements.
- Requirements/Materials Included
To take this course you'll need Adobe Dreamweaver and basic Dreamweaver experience, basic experience in hand-coding HTML, including an understanding of the different types of HTML form fields. An account with a Web hosting provider. If you do not yet have a Web hosting account, providers will be recommended to you. If you do have a Web hosting account, you must have access to PHP and MySQL.
- Certification
3 CEU’s
SessionsCollege is accredited by the Distance Education and Training Council (DETC). Certificate programs are accredited by the Middle States Commission on Secondary Schools
