+44 (0) 345 257 0137

Teradata Best Practices

VLDB Teradata Best Practices

Teradata Information Overload

There are lots and lots of Teradata manuals covering all things Teradata.

Some of the Teradata manuals are more useful than others. The Teradata manuals of interest to most people still run to thousands and thousands of pages. At least they're free to download these days — some of us remember when they were A4 binders only!

In addition to the Teradata manual, there are also lots of Teradata courses covering topics such as Teradata Architecture, Teradata SQL, Teradata Design, Teradata Database Administration etc. We even teach the traditional Teradata courses ourselves.

It would take weeks and weeks of back-to-back training to get through just the core Teradata training courses, even if your boss approves the cost and time away from your desk.

So much back-to-back Teradata training in a short period of time is not something we'd recommend anyway. It's just information overload.


Teradata Best Practices

"A best practice is a method or technique that has been generally accepted as superior to any alternatives because it produces results that are superior to those achieved by other means or because it has become a standard way of doing things"
(https://en.wikipedia.org/wiki/Best_practice).

The senior team at VLDB have been using Teradata since the late 1980s/early 1990s.

During the early 2000s we duly sat the Teradata Certification exams. This resulted in us having four of the first UK Teradata Certified Masters in our team. Exam passes & certificates are nice to have, but there's simply no replacement for decades at the coalface, no sir. Been there, seen that, done that, got the t-shirt, as they say.

Anyway, we think we've picked up a few Teradata best practices over the last 30 years. One or two we even claim we came up with all on our own — no really!


Teradata Best Practices Overview


All about nodes, storage, bynet interconnect & vprocs.

Using BI & ETL tools and Teradata Tools & Utilities (TTU) like BTEQ, Fastload & Fastexport.

How to control data distribution across the Teradata AMPs.

How to get data in and out of Teradata.

How to write efficient SQL applications.

How to tell if your SQL queries are good, bad or just plain ugly!

How to help Teradata run your queries faster.

Inner joins, outer joins and even product joins.

Data types, nulls, constraints and referential integrity.

When & how to partition tables to aid query performance.

When to use views, and when to not use views.

Secondary indexes, join indexes.

How to find out useful information by running SQL queries against the Teradata data dictionary.

Teradata Best Practices Overview

  • Teradata Architecture — all about nodes, storage, bynet interconnect & vprocs
  • Connectivity — using BI & ETL tools and Teradata Tools & Utilities (TTU) like BTEQ, Fastload & Fastexport
  • Primary Indexes — how to control data distribution across the Teradata AMPs
  • Loading & Unloading — how to get data in and out of Teradata
  • Teradata Application Development — how to write efficient SQL applications
  • Explain Plans — how to tell if your SQL queries are good, bad or just plain ugly!
  • Statistics — how to help Teradata run your queries faster
  • Joins — inner joins, outer joins and even product joins
  • Tables Creation — data types, nulls, constraints and referential integrity
  • Partitions — when & how to partition tables to aid query performance
  • Views — when to use views, and when to not use views
  • Indexes — secondary indexes, join indexes
  • Data Dictionary Queries — how to find out useful information by running SQL queries against the Teradata data dictionary

Teradata Zero-to-Hero

VLDB's Teradata Best Practice training is designed to get you from 'Teradata zero' to 'Teradata hero' as fast as possible. For those that already know how to write SQL queries, we'll help you cut through the masses of Teradata manuals and open your eyes to what you really need to know.


The Boring Bits

Yes, course attendees will need to already be familiar with SQL. Sorry, this isn't a Teradata SQL or Teradata Bootcamp course. Attendees don't need to be SQL super-heroes, but a working knowledge of running SQL queries against a relational database is required.

The Teradata Best practice course can be tailored for either 1 day or 2 days. The choice is yours as to whether you want 'just the info' or if you'd prefer to run through real examples from your existing applications.

We can teach Teradata Best Practice either on site or at the VLDB offices in Liverpool. Overnight accommodation in Liverpool can be arranged if a 2 day course in our office is required.


Training Guarantee

We promise not to just talk at you for the duration of the course. We know how painful that is.

We also promise to start and finish on time.

VLDB's training is always fully interactive and hands-on.


Learn From The Experts

VLDB's Teradata Best Practice training is based on decades of real-world Teradata experience.

Our Teradata Masters learned their trade at some of the most long-established Teradata sites in the UK, such as Lloyds (and TSB pre-merger), Barclays, Vodafone, ShopDirect (and Littlewoods and GUS pre-merger), Co-op, Freeman/Grattan and Iceland.

We've even picked up experience from the likes of Bank of America and Verizon Wireless in the USA, plus Nokia and Kesko in Europe.


Iceland Foods Ltd is a British supermarket chain
Barclays Financial Services Company
Kesko Food Retail Company
FGH Freemans Grattan Holdings Retail Company
Shop Direct Online Retail Company

Bank of America Corperation
Nokia Telecommunications Company
Vodafone Telecommunicationns Company
Lloyds Banking Group, Retail Banking Company
Verizon Wireless Telecommunications Company


Teradata Blog Articles

The following Teradata articles published via the VLDB Blog should give an insight into VLDB’s Teradata knowledge.



Contact VLDB today to start putting our Teradata Best Practice insights to work on your behalf.