Event #2518: MySQL for Developers II

Start Date: 2007-4-18 End Date: 2007-4-20 Country: GBR Category: Training URL: http://www.stayahead.com/EventSchedule/outline.cfm?CourseCode=MYSD2 Delegates: MySQL Developers who have an understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course and the MySQL for Developers I course. The content of the course covers the topics required for the Certified MySQL Developer II examination. Objectives: By the end of the course, delegates will be able to: Import and export data Perform complex joins to access multiple tables Perform complex subqueries Manage and use views Use variables and prepared statements Create and use stored routines Create and use triggers Obtain database metadata Debug MySQL applications Understand basic optimisations Topics Covered: Importing and Exporting Data using SQL Import and Export from the Command Line Complex Joins and Subqueries Managing and Using Views User Variable Syntax and Properties Prepared Statements Stored Routine Definition Procedures and Functions Creating, Dropping and Altering Stored Routines Invoking Stored Routines Trigger Concepts Creating and Using Triggers Privileges for Stored Routines and Triggers Obtaining Database Metadata Debugging MySQL Applications Optimization Principles Storage Engines -- https://master.php.net/manage/event.php?id=2518&action=approve https://master.php.net/manage/event.php?id=2518&action=reject https://master.php.net/manage/event.php?id=2518