Re: PLSQL training CBT

From: Ed Prochak <>
Date: Mon, 18 Feb 2008 04:52:01 -0800 (PST)
Message-ID: <>

On Feb 15, 11:55 am, wrote:
> Hi Guys,
> We are taking on a couple of junior PLSQL programmers straight out of
> university who are well versed with the basics of PLSQL.  We will
> provide a level of on site training but would like them to have a more
> thorough level of understanding of the topics such as creating PLSQL
> blocks; packages, triggers, procedures, functions, cursors etc etc
> before letting them loose on our systems!.
> Rather than sending them on an expensive oracle course, we have
> decided to do much of the training on site with CBT's and integrate
> them within our Oracle development team.
> Do any of you know of any good Computer based training courses for the
> intermediate (not beginner) programmer whether it be CD or a website.
> They both have quite an in depth knowledge of SQL so that is not
> really a requirement for us at this moment.
> I have done quite intensive google searches but before I buy anything
> I thought I would see what you guys would recommend as much of the
> CBT's I have seen are more geared towards the absolute beginner which
> is not really relevant to us.
> Any advice would be great!
> Chris

I don't quite unbderstand their skill level. You say they "are well versed with the basics of PLSQL" but apparently they do not know about functions and procedures? I could possibly understand them not knowing packages, but not knowing functions? Sounds like they only know SQL, so maybe you mistyped?

I would suggest a mentoring approach rather than CBT. Having them work with a more experienced developer gives you two benefits: they learn the PL/SQL and they learn the development culture of your company. this could include small programming assignments, participating in code reviews, and later debugging existing packages.

Unless the person has a knack for learning on their own, in which case getting them a good book should do it.

I have taught Oracle PL/SQL both in a class and one-on-one. I think the human interaction provides a greater benefit. (IOW, I'm a little biased here).

  Ed Received on Mon Feb 18 2008 - 06:52:01 CST

Original text of this message