+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

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 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.


VLDB's Teradata Clients


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