Suggestions on a Training Initiative

Edward Long

Suggestions on a Training Initiative
Hi everyone and happy blizzard. If only we were talking about the Dairy Queen variety of blizzard and not this mess.
In any case, I have been given an assignment to potentially build a SQL performance and design class for a bunch of Java developers who tend to work most frequently in Oracle. However, they need to be efficient in all 4 of the big 4 (DB2/LUW, DB2/Z, Oracle, Sql Server).

Pretty much the standard topics:
To join or not to join, best time to use triggers, stored procedure etc., effective use of explain and tools, transaction management (aka locking), debugging.

Have any of you done this? To adequately cover this many topics in 4 DBMS's in one week seems like a lot to cover especially with workshops.
 Would we do better to focus on just one of the 4?
Does someone have such a class we could start from?

Edward Long

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: Suggestions on a Training Initiative
(in response to Edward Long)
Ed,
1) Focus on one DBMS at a time, and it takes as long as it takes. There are a lot of differences when you open up the SQL performance box; I can't see how teaching them together would be useful.
2) I'd say you also want to cover:
a. Indexes, and what predicates use them (and CHAR and VARCHAR in index design!);
b. Cursor operations and Commit (performance implications);
c. correlated and non-correlated subqueries;
d. SQL Functions and their effect on efficiency.

--Phil Sevetson

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ed Long
Sent: Wednesday, February 02, 2011 1:12 PM
To: [login to unmask email]
Subject: [DB2-L] Suggestions on a Training Initiative

Hi everyone and happy blizzard. If only we were talking about the Dairy Queen variety of blizzard and not this mess.
In any case, I have been given an assignment to potentially build a SQL performance and design class for a bunch of Java developers who tend to work most frequently in Oracle. However, they need to be efficient in all 4 of the big 4 (DB2/LUW, DB2/Z, Oracle, Sql Server).

Pretty much the standard topics:
To join or not to join, best time to use triggers, stored procedure etc., effective use of explain and tools, transaction management (aka locking), debugging.

Have any of you done this? To adequately cover this many topics in 4 DBMS's in one week seems like a lot to cover especially with workshops.
Would we do better to focus on just one of the 4?
Does someone have such a class we could start from?

Edward Long


________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Leslie

Re: Suggestions on a Training Initiative
(in response to Philip Sevetson)
Ed

I will say this, I admire you even thinking you can cover four DBMSs in one
week with that much detail ... and further more to "Java" developers, who I
expect have very little attention span ... just an observation of many years
working with Java Developers .. they drive me mad! :-)

so in short you are looking at 1 day per DBMS to cover all that lot .. I
would do as you say and concentrate on 1 and do it well.

The alternative is to pull together, assuming sufficient time, a "Best
Practices" book maybe.....? with a good index for each dbms and they can
then use it as a reference guide, maybe?

Sometimes it is a lot cheaper to get people in who have all this material to
hand and can tailor a course to suit your particular needs.

just my two pence/cent worth ... :-)

Les

_____

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ed Long
Sent: 02 February 2011 18:12
To: [login to unmask email]
Subject: [DB2-L] Suggestions on a Training Initiative


Hi everyone and happy blizzard. If only we were talking about the Dairy
Queen variety of blizzard and not this mess.
In any case, I have been given an assignment to potentially build a SQL
performance and design class for a bunch of Java developers who tend to work
most frequently in Oracle. However, they need to be efficient in all 4 of
the big 4 (DB2/LUW, DB2/Z, Oracle, Sql Server).

Pretty much the standard topics:
To join or not to join, best time to use triggers, stored procedure etc.,
effective use of explain and tools, transaction management (aka locking),
debugging.

Have any of you done this? To adequately cover this many topics in 4 DBMS's
in one week seems like a lot to cover especially with workshops.
Would we do better to focus on just one of the 4?
Does someone have such a class we could start from?

Edward Long

_____


< http://www.idug.org > Independent, not-for-profit, User Run - the IDUG
difference!

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please < http://www.idug.org/register > register
here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv