Archives of the TeradataForum

Message Posted: Tue, 04 Jan 2005 @ 16:32:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Chris' list was already pretty complete, so I can simply add a couple of things:

If you want to understand SQL for Teradata well, DO read the manuals. Some parts of the manuals are extremly well written, particularly the ones explaining the different join-types (merge, hash, etc) that TD chooses.

You can download the manuals for free from the www.info.ncr.com

The 'Introduction to Teradata R RDBMS' manual is a good place to start. It also talks about TD basic architecture. It makes sense to read these parts too, even if SQL is your main interest. I think it's more important to understand the underlying architecture even for only writing SQL when you work on TD than it is for other DBs.

There are 6 TD SQL manuals. They are numbered through, and I think those numbers can be tought of as indicator of difficulty. Just start with Volume 1 and work your way up :)

I don't think there are many good books about TD out there (at least there were none when I got my start...), so I would look at the manuals first... (plus, they come at no costs)

To me the most important things would be:

1. Understanding basic set theorie (so you can see how it applies to SQL and RDBMS)

2. Having a mentor that is very knowledgeble. There is no better way to learn to code good SQL than to inherit somebody elses.

3. Read the forum. You will recognize all the gurus that hang out here soon enough ;))

And obviously all this only works if you actually have a reason to write SQL, etc yourself...

Best of luck!

Mirjam

	<Prev	Next>		<<First	<Prev	Next>	Last>>