MySQL for Developers Screencast and Slides

Here is a screencast about MySQL  for Developers

If you are a developer using MySQL, you should learn enough to take advantage of its strengths, because having an understanding of the database can help you develop better-performing applications. This session will talk about MySQL database design and SQL tuning for developers. Some topics include:

• MySQL Storage Engine Architecture
• Schema, the basic foundation of performance
• Think about performance when choosing Data Types
• Indexes and SQL tuning
• Understanding SQL Statements using EXPLAIN
• Scans and seeks
• Solving performance problems in your queries
• A Few Things to consider for JPA/Hibernate devlopers, Lazy loading and Optimistic locking

You can download the slides here
https://techdayscode.dev.java.net/servlets/ProjectDocumentList?folderID=9890

You can read more about this at
MySQL for Developers
GlassFish and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client
High Performance MySQL book
MySQL Pluggable Storage Engine Architecture
MySQL Storage Engine Architecture, Part 2: An In-Depth Look
Optimizing Queries with EXPLAIN
Java Persistence with Hibernate book
Jay Pipes blog 
Colin Charles blog
mysql performance blog
Ronald Bradford blog
Taking JPA for a Test Drive
Pro EJB 3: Java Persistence API
Pro MySQL, Chapter 6: Benchmarking and Profiling