Rép. : Re: PostgreSQL Training - Mailing list pgsql-novice

Amy,

As it seems you'll have to learn without face-to-face formailzed training

The Postgresgl.org web site has _a_lot_ of resources that may help a novice, including:

The tutorial part of the doc:
http://www.postgresql.org/docs/current/static/index.html

The tutorials at http://techdocs.postgresql.org/#tutorials
"Introduction to PostgreSQL 7.1.x : Starting concepts" is a bit outdated but the concepts are still OK

The book
PostgreSQL:Introduction and Concepts by Bruce Momjian
http://www.postgresql.org/docs/awbook.html

The FAQs
http://www.postgresql.org/docs/faqs/FAQ.html

The SQL language is (supposed to be) a standard. Pg follows the standard. It is also quite close Oracle's SQL dialect
andconcepts ( including PL/SQL, triggers, sequences, ...). 
So, any generic or Oracle-based book/tutorial/training will be OK to learn the basics.

That's how I've learned it, as most of us I Guess...

HTH
Erwan


>>> "Amy Young" <Amy_Young@hilton.com> 10/12/2003 16:34:36 >>>
Thanks for everyone's support.  I really appreciate it.  I will admit
that I learn *best* -- at least in the beginning -- through structured,
formalized face-to-face training.  But, there does appear to be a
community of support here.  I haven't started with the basics out of the
book yet, so I think I'll start there (I'm at the VERY beginning, and
don't want to bog down the list with TOO basic questions).  But, rest
assured, I'll be back.

Thanks again,

Amy

    -----Original Message----
    From: sank89@sancharnet.in [mailto:sank89@sancharnet.in]
    Sent: Wednesday, December 10, 2003 9:18 AM
    To: Amy Young
    Cc: Bret Busby; pgsql-novice@postgresql.org;
pgsql-general@postgresql.org
    Subject: Re: [NOVICE] PostgreSQL Training
    Importance: High


    Dear Amy Young  ,

    You will get full support from this PostgreSQL community  but
before asking question please do add some common things like
    My System Configuration is :
    OS                                         Blah
    GCC compiler                        More Blah
    PostgreSQL server Version     Even  More Blah
    PostgreSQL  data  path            /mydir/myblah/data
    And yes If you are using PHP or Perl for data representation
their full details

    And then state your full problem / question with steps if
possible

    Here we are to help you , am I right guys :-)        and  Mr.
Bruce are you listening

    Regards,
    V Kashyap.



        Bret,

        Thanks for voicing your opinion.  I'll second it as
loudly as I can.

        I work for a small 5 member team in a major hospitality
corporation.
        Our team has a mish mash of responsibilities (help desk,
tool design
        through MS Excel and MS Access, and corporate
reporting).  We are just
        pushing the limits of MS Access capabilities with the
amount of data we
        are getting pushed to us for our corporate reporting.
The amount of
        data is only going to grow and we realize we NEED to
move to a SQL
        server of some kind.  Cost containment is a huge factor,
so the
        free-ware aspect of PostgresQL is extremely enticing.
However, only 1
        person on our team has ANY experience with SQL servers
and none with
        PostgreSQL. We originally started investigating MySQL,
but found it to
        be slower than the convoluted work around we've
developed in MS Access.
        Further investigation revealed that it may be due to how
we had the
        server set up.  Then, someone suggestions PostgreSQL.

        I have been reading what I can, and while I understand
some of the
        concepts, and I am still mostly floundering my way
through "Greek".  I
        need a strong foundation in the basics. I had found the
MySQL class and
        have added that to my goals for next year.  However, it
will take some
        strong arguments to convince my superiors to send me to
training for
        something that will "sort of" apply to what we are doing
in the office.
        So my options are: use MySQL instead or don't go to
training.

        In the mean time, I will investigate the "21 day" book
(I have used the
        series many times!) and hope the PostgreSQL community
will recognize the
        need for some training classes (The certifications are
optional as far
        as I'm concerned, though I recognize the power of
certifications since I
        used to teach at New Horizons Computer Training Center.
I just want
        someone to hold my hand and walk me through the entire
process so I can
        learn the lingo.  Then, I can figure things out on my
own).  And I'll be
        asking as many questions on the list server as I can.

        Cheers,

        Amy Young
        Sr. Revenue Analyst
        Memphis, TN

        -----Original Message-----
        From: pgsql-novice-owner@postgresql.org
        [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of
Bret Busby
        Sent: Wednesday, December 10, 2003 1:09 AM
        To: pgsql-novice@postgresql.org;
pgsql-general@postgresql.org
        Subject: Re: [NOVICE] PostgreSQL Training


        On Tue, 9 Dec 2003, Bryan Encina wrote:



            Date: Tue, 9 Dec 2003 15:06:05 -0800
            From: Bryan Encina <bryan.encina@valleypres.org>
<mailto:bryan.encina@valleypres.org>
            To: 'Bruce Momjian' <pgman@candle.pha.pa.us>
<mailto:pgman@candle.pha.pa.us>
            Cc: pgsql-novice@postgresql.org
            Subject: Re: [NOVICE] PostgreSQL Training





        ---------------------------(end of
broadcast)---------------------------
        TIP 4: Don't 'kill -9' the postmaster

        .