Discussion

The MySQL 5.0 for Developers course teaches someone:

• the MySQL tools (command-line clients and MySQL Query Browser)
• the various data types in MySQL, including the changes to varchar in 5.0
• how to create and drop tables
• how to create indexes (unique, non-unique and fulltext indexes)
• how to use foreign keys with the InnoDB storage engine
• how to write DML statements using SELECT (plus GROUP BY, ORDER BY, LIMIT, DISTINCT and UNION), INSERT, UPDATE, DELETE and REPLACE
• to use the built-in functions in MySQL
• to use transactions with InnoDB and the various isolations levels supported by MySQL
• to write various JOIN statements and subqueries
• how to create views and to understand why they are useful
• use prepared statements
• write stored functions and stored procedures in MySQL 5.0
• write triggers in MySQL 5.0
• use the new INFORMATION_SCHEMA to view metadata