MySQL Developer training course

• Describe the MySQL client/server architecture
• Create tables appropriate for your data
• Troubleshoot errors and warnings
• We’ll look at creating and editing database
• Creating and working with tables
• Normalize tables
• Connecting to databases using Java / PHP
• How to work with data types and expression
• Getting meta data (information on data)
• Manipulating data
• Using Primary, Foreign Keys and Indexes to optimise data
• Joins and Subqueries to get data from more than one table
• Creating views to help work with your data
• Prepared statements and triggers
• Programming with stored routines
• Optimising data and dealing with errors

JBI's MySQL training course looks at covering everything a Developer would need to know - from setting up a MySQL server on a host, to extracting data from multiple tables using joins and subqueries. Maybe you’re wondering how to optimise your SQL statements and indexes, we cover this as well.