Re: [NOVICE] PostgreSQL Training

Hi John;

I was actually looking at dividing it into the following areas (fairly
similar to your suggestion, actually):

1: Basic competency: Entry level dev/small time admin. Basic database
design and operation concepts. Basic SQL competency.

2: Advanced competency: performance tuning, trigger development,
advanced features. Competent admin, mid-range dev.

3: In depth advanced documentation for specialists:
* Enterprise DBA's
* Application developers using extremely advanced features (2-phase
commit, when supported, for example, in distributed transactions).
* Developers of PostgreSQL modules (types, PL's, C functions,
advanced stored procedures).

I think that it is important that dev's and dba's see things from
eachothers' perspective. However, I do agree that at some point, there
is a divide which needs to be accepted rather than bridged.

Best Wishes,
Chris Travers

On Sat, 2003-12-13 at 00:00, John Sidney-Woollett wrote:
> If you considering a skills outline, also consider dividing it two areas;
> developer and dba.
>
> My experience is mostly with Oracle (more years than I care to remember),
> and with this product in many organizations, there are usually two camps;
> the dba (God) and the developers (devils - always trying to break the db,
> and annoy the dba)
>
> >From watching this list for the past couple of weeks it appears that many
> members of this list are both developer (some of postgres itself and
> others, users of postgres) and dba.
>
> I think that the divide (with Oracle) is mostly political and cultural,
> and that the best database solutions are those built by individuals or
> teams that straddle both camps.
>
> I've come to Postgres because I working with a startup that cannot afford
> the Oracle web license. I suspect that a proportion of new users are also
> those who have come from other databases for varying reasons (often
> financial, missing feature set etc).
>
> To cater for this "market", maybe it would be best to provide material
> that caters specifically to the DBA, the developer, or those that want to
> be both.
>
> Just my $0.02 (FWIW).
>
> John Sidney-Woollett
>
> Bruce Momjian said:
> > Chris Travers wrote:
> >> I am wondering if you are interested in helping with some sort of skills
> >> outline project-- what skills we as a community think are important for
> >> someone to claim basic mastery over the database manager. Not as if you
> >> don't have enough to do already ;-) Maybe at least as a mentor.
> >
> > Sure, makes sense.
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania
> > 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>