MySQL for Developers

By the end of the course, delegates will be able to: * Understand MySQL Client/Server concepts * Use advanced features of the MySQL Client * Understand various types of Connector * Use advanced data types * Manage databases, tables, indexes, views * Write complex SQL query statements * Use advanced SQL expressions and functions * Modify, Import and export data * Perform complex joins and subqueries * Use variables and prepared statements * Create and use stored routines * Create and use triggers * Obtain database metadata * Debug MySQL applications * Understand Basic Optimisations Course content

• Client/Server Concepts and Architecture
• The MySQL Client Program and Connectors
• Data Types including Bit and Binary
• Managing Databases, Tables, Indexes and Views
• Retrieving and Aggregating Data
• AdvancedSQLExpressions and Functions
• Modifying, Importing and Exporting Data
• Complex Joins and Subqueries
• User Variable Syntax and Properties
• Prepared Statements
• Stored Routine Definition
• Procedures and Functions
• Creating, Dropping and Altering Stored Routines
• Invoking Stored Routines
• Trigger Concepts, Creation and Use
• Privileges for Stored Routines and Triggers
• Obtaining Database Metadata
• Debugging MySQL Applications
• Optimization Principles
• Storage Engines