Cover image for Teradata Certification Associate Exam Practice Guide

Teradata Certification Associate Exam Practice Guide

Author Tom Coffing
Release Date: 2019/06/01
ISBN: 9781940540405
Topic:
0%
16
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

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.

Table of Contents

  1. Cover
  2. Title Page
  3. The Nexus and Nexus Core Server for the Cloud and On-Premises
  4. Trademarks and Copyrights
  5. About Tom Coffing
  6. Contents
  7. Chapter 1 – Database Concepts
    1. Teradata Certification Exams, Releases, and Websites
    2. Teradata Database Certification and Exam Path
    3. Teradata Associate Exam Objectives and Section Weightings
    4. What is Parallel Processing?
    5. What is a Database?
    6. What is SQL?
    7. How Can You Use a Database?
    8. There are Two Types of Databases
    9. Relational Database Model and Mathematical Set Theory Concepts
    10. Relational Term Review
    11. Rules for Teradata Databases, Tables, and Columns
    12. What is a Constraint?
    13. What is the Difference Between a Primary Key and a Foreign Key?
    14. Referential Integrity
    15. Quiz - Logical Model Primary Key Quiz
    16. Answer - Logical Model Primary Key Quiz
    17. Quiz - Logical Model Foreign Key Quiz
    18. Answer - Logical Model Foreign Key Quiz
    19. Dimensional Model – One Fact Table and Many Dimension Tables
    20. Quiz – What is the Primary Key of the Fact Table?
    21. Answer – What is the Primary Key of the Fact Table?
    22. Quiz – Name the Foreign Keys
    23. Answer – Name the Foreign Keys
    24. What is a Star Schema?
    25. Normalization
    26. A Denormalized Table
    27. Getting to First Normal Form
    28. A Table that is in Second Normal Form
    29. Tables Reaching Third Normal Form
    30. Dimensional Modeling
    31. What are the Advantages of a Normalized vs. Dimensional Model?
    32. Logical Data Model vs. Physical Data Model
    33. Logical Data Model vs. Physical Data Model Example
    34. Data Warehouses are Designed for Analytics
    35. The Four Stages of Modeling for Teradata
    36. Review Questions
    37. Review Questions
    38. Review Questions
    39. Review Questions
    40. Review Questions
    41. Review Questions
    42. Review Questions
    43. Review Questions
    44. Review Questions
    45. Review Questions
    46. Review Questions
  8. Chapter 2 – Data Warehouse Architecture
    1. A Distributed (Federated) Architecture vs. a Centralized Architecture
    2. What is a Data Mart?
    3. Independent Data Marts
    4. Dependent Data Marts
    5. Logical Data Marts
    6. Data Warehouse Architecture Layers
    7. How Data Flows Through a Data Warehouse
    8. Reasons to Deploy a Data Warehouse
    9. Review Questions
    10. Review Questions
    11. Review Questions
    12. Review Questions
  9. Chapter 3 – Architecture and Components
    1. Teradata Everywhere
    2. The Parsing Engine
    3. The AMPs Responsibilities
    4. Two Ways to Connect to Teradata
    5. Features that are Unique to Teradata
    6. How is the Teradata Database Used?
    7. Objects within the Teradata Database
    8. Set Table vs. Multiset Table
    9. Data Types
    10. Partitioned Tables
    11. Views
    12. Macro
    13. Trigger
    14. Stored Procedures
    15. Join Index
    16. Database vs. User
    17. Metadata – Object Management - Data Dictionary
    18. The Data Dictionary Resides in User DBC
    19. BYNET Network is the Communication Glue
    20. A Node
    21. Teradata Virtual Storage Tracks Hot, Medium and Cold Data
    22. Nodes Connect with the BYNET Networks
    23. Message Passing Layer or Communications Layer
    24. Parallel Database Extensions (PDE)
    25. Fallback Protects Against an AMP Failure
    26. Raid 1 Mirroring Protects Against a Disk Failure
    27. Cliques Protect Against a Node Failure
    28. How Cliques are Physically Defined
    29. Cliques are cabled so Migrating AMPs can access their Disks
    30. Teradata has Three Types of Space
    31. All Space is Calculated on a Per AMP Average
    32. How Spool Works
    33. Review Questions
    34. Review Questions
    35. Review Questions
    36. Review Questions
    37. Review Questions
    38. Review Questions
    39. Review Questions
    40. Review Questions
  10. Chapter 4 – Data Distribution and Access
    1. Primary Index Option #1 – Unique Primary Index (UPI)
    2. Primary Index Option #1 – Unique Primary Index (UPI) Query
    3. Primary Index Option #2 – Non-Unique Primary Index (NUPI)
    4. Primary Index Option #2 – Non-Unique Primary Index (NUPI) Query
    5. Using EXPLAIN in a Primary Index Query
    6. Primary Index Option #3 – Multi-Column Primary Index
    7. Primary Index Option #3 – Multi-Column Primary Index Query
    8. Primary Index Option #4 – No Primary Index Spreads Data Evenly
    9. Table CREATE Examples with four different Primary Indexes
    10. Teradata Tables that are Partitioned are called PPI Tables
    11. Teradata has Columnar Tables
    12. Unique Secondary Index (USI)
    13. Non-Unique Secondary Index (NUSI)
    14. Using a Simple Global Temporary Table
    15. Review Questions
    16. Review Questions
    17. Review Questions
  11. Chapter 5 – Security and Privacy
    1. Four Types of Locks in Teradata
    2. Lock Compatibility
    3. Lock Chart
    4. User Security – Password and Role
    5. Access Rights/Privileges
    6. Profiles
    7. Authentication and Middle-Tier Applications
    8. Privacy Mechanisms via Secure Zones
    9. Review Questions
    10. Review Questions
    11. Review Questions
    12. Review Questions
    13. Review Questions
  12. Chapter 6 – Teradata Tools and Utilities
    1. What is TPT?
    2. Teradata Parallel Transporter (TPT) Operators
    3. Teradata Parallel Transporter (TPT) Operators
    4. Other Important TPT Operators
    5. Teradata Unity for Managing Multiple Teradata Systems
    6. TASM - Teradata Active Systems Management
    7. What is TASM?
    8. What is the Secret Sauce for TASM?
    9. Teradata Studio
    10. Teradata Viewpoint
    11. The Add Content Menu for Monitoring
    12. Adding Multiple Portals to a Single Page
    13. Teradata Listener
    14. Teradata AppCenter
    15. Review Questions
    16. Review Questions
    17. Review Questions
    18. Review Questions
18.119.105.239