MySQL for Developers Screencast and Slides

http-equiv="content-type">





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

href="https://techdayscode.dev.java.net/servlets/ProjectDocumentList?folderID=9890">https://techdayscode.dev.java.net/servlets/ProjectDocumentList?folderID=9890




You can read more about this at

href="http://weblogs.java.net/blog/caroljmcdonald/archive/2008/09/mysql_for_devel.html">MySQL
for Developers

href="http://java.sun.com/developer/technicalArticles/glassfish/GFandMySQL_Part4Intro.html">GlassFish
and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client

High Performance
MySQL book

MySQL Pluggable
Storage Engine Architecture

href="http://dev.mysql.com/tech-resources/articles/storage-engine/part_2.html">MySQL
Storage Engine Architecture, Part 2: An In-Depth Look

Optimizing
Queries with EXPLAIN

Java Persistence with
Hibernate book

Jay Pipes blog  style="text-decoration: underline;">

Colin Charles blog

mysql performance blog

Ronald Bradford blog

Taking
JPA for a Test Drive

Pro EJB 3: Java
Persistence API

href="http://dev.mysql.com/tech-resources/articles/pro-mysql-ch6.html">Pro
MySQL, Chapter 6: Benchmarking and Profiling