MySQL programming and

PhpMyAdmin Online

• Overview of MySQL and PHPMyAdmin
• Understand basic concepts of how a database stores information via tables
• Understanding of SQL syntax used with MySQL
• Learn how to retrieve and manipulate data from one or more tables
• Know how to filter data based upon multiple conditions
• Updating and inserting data into existing tables
• Learning how the relationships between tables will affect the SQL.
• The advantages of store procedures with storing data using variables and functions.
• How SQL can be used with programming languages like PHP to create dynamic websites for visitors.
• Review of some sample PHP projects interacting with MySQL.