Archives of the TeradataForum
Message Posted: Tue, 04 Jan 2005 @ 16:32:43 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|