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





Comments:

Post a Comment:
Comments are closed for this entry.
About

caroljmcdonald

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today