Skip to main content

MySQL for Developers Screencast and Slides

Posted by caroljmcdonald on March 18, 2009 at 10:31 PM PDT




http-equiv="content-type">
mysqlfordevelopers




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












Related Topics >>

Comments

Nice, good stuff :)