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
.