PHP & MySQL

The PHP and MySQL training course teaches students about the basics of the php scripting language. This course teaches students how to create, launch and manage websites using the php scripting language. The php is the most widely used, free and efficient alternative to softwares such as Microsoft ASP.

About the course: The php and MySQL training course mainly focuses on server-side scripting that helps one to make innovative, dynamic and interactive web pages.

This course teaches students how to execute scripts on the server. The students gain valuable tips and tricks for using the php language and syntax.

This course focuses on teaching how to streamline php’s interaction with MySQL, sql and other such platforms. It also teaches students how to reuse codes using functions.

By the end of the entire course the students will be able to work easily with php and MySQL and see how php’s sessions and cookies can be used to build full scale application so fast and effectively.

Prerequisites: 

This course asks students to have basic knowledge of the scripting language. They must know the basics of scripting and they must be able to work well with them. In order to take up this course the students must already be familiar with php and MySQL uses.

Target Students:

Any person willing to learn php and MySQL can take up this course. Students willing to develop their carrier in server side scripting can also enroll for this course.

PHP & MySql Course Outlines:

• Overview of the Case Study – The e-Store
• Populating Web pages from a database
• User-driven queries/browse
• Data Entry and Validation
• User Authentication and Management
• Reporting
• Learning PHP
• PHP Basics
• Conditions and Branches
• Loops
• Variables and Arrays
• Strings
• Functions
• MySQL databases
• Database Basics
• Loading a Database
• MySQL command Interpreter
• Creating a database
• Modifying a database
• Administering a database
• Developing an application using PHP and MySQL
• The e-Store
• MySQL functions in PHP
• Querying a database
• User-Driven Querying
• Previous and Next Browsing
• Inserts, Updates, and Deletes
• User Authentication and Management
• Ordering and Shipping