Teradata Certification Associate Exam Practice Guide

Tom Coffing

• Publisher: Coffing Publishing
• Year: 2019
• ISBN:
  9781940540405
• Topic: Computer Science
• Subtopic: Data Warehousing
• Index: Computer Science

If you want to pass the certification test and become a "Teradata Certified Associate, " then this book is for you. Tera-Tom, a Teradata Certified Master who has more than 25 years of Teradata experience, explains the fundamentals of Teradata, relational databases, and every subject you need to pass the test. With hundreds of sample questions and Tom's easy explanations, you will soon be knowledgeable and certified on Teradata. Having Teradata knowledge and your certification means that the sky is the limit on your career.

Chapter 1 – Database Concepts

“I find that the harder I work the more luck I seem to have.”

– Thomas Jefferson

Teradata Certification Exams, Releases, and Websites

Teradata Certification (TCPP) Website:
www.teradata.com/certification.

Bypass Exams with Prior Teradata 14 Certification information:
www.teradata.com/products-and-services/Certification/Database#waivers

Registration Information:
www.pearsonvue.com/teradata

TCCP Contact Information:
email: [email protected] phone: [phone]

The Certification Exams use the Teradata releases above. The Teradata Certification Exams will be updated periodically to the latest Teradata release. The websites listed above provide additional information. The first website listed above explain the concepts and objectives for each exam.

Teradata Database Certification and Exam Path

The current Teradata Certification Exams are listed above. You can earn a wide variety of Teradata Certified Designations depending upon the tests completed. The exams require knowledge plus experience with Teradata release 16 and higher. Many of the test questions are scenario-based, and Teradata experience is needed to answer many of the questions, but the Tera-Tom Certification books will teach you what you need to know to give you the best chance of passing.

Teradata Associate Exam Objectives and Section Weightings

The exam objectives and section weightings above describe the content covered on the Associate Exam.

What is Parallel Processing?

“After enlightenment, the laundry”

- Zen Proverb

“After parallel processing the laundry, enlightenment!”

-Teradata Zen Proverb

Two guys were having fun on a Saturday night when one said, “I’ve got to go and do my laundry.” The other said, “What?!” The man explained that if he went to the laundry mat the next morning, he would be lucky to get one machine and be there all day. But, if he went on Saturday night, he could get all the machines. Then, he could do all his wash and dry in two hours. Now that’s parallel processing mixed in with a little dry humor!

What is a Database?

A table is made up of columns and rows. The CustomerTable has two columns and five rows. The Order Table has four columns and four rows.

Each row (also called a record) contains one instance of all the columns (also called fields) in a table.

Databases provide a mechanism for organizing data. Relational databases store data in tables. The storing, managing and retrieving of data are qualities of a database.

A table looks almost like an Excel spreadsheet because it has columns and rows, but a spreadsheet is considered a flat file. Tables in a relational database have relations with other tables. Notice the CustNo column is in two tables.

What is SQL?

Relational database management systems (RDBMS) use SQL (structured query language), pronounced either (Sequel or S Q L) as a database query language. Humans communicate with the help of varying languages, but SQL is a common language that all relational databases understand. The commonality of SQL is because of the American National Standards Institute (ANSI), which has representatives from most RDBMS Companies. ANSI compliant database can use a common SQL language, but each database will add extensions to their SQL to make them special. It is the SQL that is used to create, manage, manipulate, and query database objects, such as tables or views.

How Can You Use a Database?

Not all databases are alike. Teradata is special. No two database systems are the same.

There are Two Types of Databases

SQL databases have relations between tables and include constraints on data types and consistency. NoSQL does away with relational rules for the sake of speed, flexibility, and scale. Relational databases follow strict rules. NoSQL provides documents, contracts, pictures, and XML or JSON (Java Script Object Notation).

Relational Database Model and Mathematical Set Theory Concepts

Set theory is a branch of mathematical logic that studies sets. In theory, no two rows of a table can be duplicated, thus the name SET Table. A Teradata MULTISET table allows duplicate rows.

Set theory is a collections of objects. Although any type of object can be collected into a set, set theory is applied most often to objects that are relevant to mathematics.

A Relational database model uses conce...