You are previewing V14 Certification: Teradata Basics.
O'Reilly logo
V14 Certification: Teradata Basics

Book Description

You are going to love this book because your confidence and knowledge will soar. V14 Certification: Teradata Basics has been designed to help you pass the test, but it is so much more. It is an incredible reference guide, learning tool, and foundation for passing all the tests and becoming a Teradata Certified Master.

Table of Contents

  1. Cover
  2. The Tera-Tom Video Series
  3. The Tera-Tom Genius Series
  4. Tera-Tom- Author of over 50 Books
  5. The Best Query Tool Works on all Systems
  6. Trademarks and Copyrights
  7. About Tom Coffing
  8. About John Nolan
  9. Contents
  10. Chapter 1 – Teradata Basics and Data Warehouse Concepts
    1. Passing Your Teradata Certification Tests
    2. What is Parallel Processing?
    3. The Basics of a Single Computer
    4. Teradata Parallel Processes Data
    5. Parallel Architecture
    6. The Teradata Architecture
    7. All Teradata Tables are spread across ALL AMPS
    8. Teradata Systems can Add AMPs for Linear Scalability
    9. Understand that Teradata can scale to incredible size
    10. AMPs and Parsing Engines (PEs) live inside SMP Nodes
    11. Each Node is attached via a Network to a Disk Farm
    12. Two SMP Nodes Connected Become One MPP System
    13. There are Many Nodes in a Teradata Cabinet
    14. Inside a Teradata Node
    15. The Boardless BYNET and the Physical BYNET
    16. The Parsing Engine
    17. The AMPs Responsibilities
    18. This is the Visual You Want to Know in order to Understand Teradata
    19. Features That Are Unique To Teradata
    20. The Three Teradata V14 Platforms and Their Operating System
    21. The Five Stages of Data Warehouse Evolution
    22. The Evolution (Four Stages) of Data Processing
    23. A Distributed Architecture vs. a Centralized Architecture
    24. The Three Types of Data Marts
    25. The Eight Types of Objects in Teradata
    26. The Two Types of Data Models
    27. Relational Models vs. Enterprise Models
    28. The Two Methods of Processing Rows of Data
    29. LAN Connections for Network Attached Client
    30. Mainframe Connections to Teradata
    31. Teradata Tools for the DBA
    32. Teradata Unity
    33. LDAP Security
  11. Chapter 2 – The Primary Index
    1. The Primary Index is defined when the table is CREATED
    2. A Unique Primary Index (UPI)
    3. Primary Index in the WHERE Clause - Single-AMP Retrieve
    4. Using EXPLAIN
    5. A Non-Unique Primary Index (NUPI)
    6. Primary Index in the WHERE Clause - Single-AMP Retrieve
    7. Using EXPLAIN in a NUPI Query
    8. Service Level Goals and Service Level Agreements
    9. A conceptual example of a Multi-Column Primary Index
    10. Primary Index in the WHERE Clause - Single-AMP Retrieve
    11. A conceptual example of a Table with NO PRIMARY INDEX
    12. A Full Table Scan is likely on a table with NO Primary Index
    13. An EXPLAIN that shows a Full Table Scan
    14. Table CREATE Examples with four different Primary Indexes
    15. What happens when you forget the Primary Index?
    16. Why create a table with No Primary Index (NoPI)?
  12. Chapter 3 – Hashing of the Primary Index
    1. The Hashing Formula Facts
    2. The Hash Map Determines which AMP will own the Row
    3. The Hash Map Determines which AMP will own the Row
    4. Placing rows on the AMP
    5. Placing rows on the AMP Continued
    6. A Review of the Hashing Process
    7. Non-Unique Primary Indexes have Skewed Data
    8. The Uniqueness Value
    9. The Row Hash and Uniqueness Value make up the Row-ID
    10. A Row-ID Example for a Unique Primary Index
    11. A Row-ID Example for a Non-Unique Primary Index (NUPI)
    12. Two Reasons why each AMP Sorts their rows by the Row-ID
    13. AMPs sort their rows by Row-ID to Group like Data
    14. AMPs sort their rows by Row-ID to do a Binary Search
    15. Table CREATE Examples with four different Primary Indexes
    16. Null Values all Hash to the Same AMP
    17. A Unique Primary Index (UPI) Example
    18. A Non-Unique Primary Index (NUPI) Example
    19. A Multi-Column Primary Index Example
    20. A No Primary Index (NoPI) Example
  13. Chapter 4 - Partition Primary Index (PPI) Tables
    1. The Concept behind Partitioning a Table
    2. Creating a PPI Table with Simple Partitioning
    3. A Visual Display of Simple Partitioning
    4. An SQL Example that explains Simple Partitioning
    5. Creating a PPI Table with RANGE_N Partitioning per Month
    6. A Visual of One Year of Data with Range_N per Month
    7. An SQL Example explaining Range_N Partitioning per Month
    8. A Partition # and Row-ID = Row Key
    9. An AMP Stores its Rows Sorted in only Two Different Ways
    10. Creating a PPI Table with RANGE_N Partitioning per Day
    11. A Visual of Range_N Partitioning Per Day
    12. An SQL Example that explains Range_N Partitioning per Day
    13. Creating a PPI Table with CASE_N
    14. A Visual of Case_N Partitioning
    15. An SQL Example that explains CASE_N Partitioning
    16. Number of PPI Partitions Allowed
    17. How many partitions do you see?
    18. NO CASE and UNKNOWN Partitions Together
    19. A Visual of Case_N Partitioning
    20. Multi-Level Partitioning Combining Range_N and Case_N
    21. A Visual of Multi-Level Partitioning
    22. The SQL on a Multi-Level Partitioned Primary Index
    23. Altering a PPI Table to Add or Drop Partitions
    24. Deleting a Partition
    25. Deleting a Partition and saving its contents
  14. Chapter 5 - Secondary Indexes
    1. Creating a Unique Secondary Index (USI)
    2. What is in a Unique Secondary Index (USI) Subtable?
    3. A Unique Secondary Index (USI) Subtable is hashed
    4. A Primary Index Query vs. a Unique Secondary Index Query
    5. How the Parsing Engine uses the USI Subtable
    6. A USI is a Two-AMP Operation
    7. Creating a Non-Unique Secondary Index (NUSI)
    8. What is in a Unique Secondary Index (USI) Subtable?
    9. Non-Unique Secondary Index (NUSI) Subtable is AMP Local
    10. How the Parsing Engine uses the NUSI Subtable
    11. Creating a Value-Ordered NUSI
    12. Quiz – Answer the Tough USI Questions
    13. Answer to Quiz – Answer the Tough USI Questions
    14. A Picture with a Base Table, USI, and NUSI Subtable
    15. Quiz – Tough Questions on the USI and NUSI Subtables
    16. Answer – Tough Questions on the USI and NUSI Subtables
    17. A Query Using an USI Only Moves Two Blocks
    18. A Query Using A NUSI Always Uses All AMPs
    19. Two Non-Unique Secondary Indexes (NUSI) on a Table
    20. How the PE Decides on the NUSI or the Full Table Scan
    21. Primary Index vs. Secondary Index
    22. The Bigger Quiz
    23. The Bigger Quiz Answers
    24. Multiple Choice DBA
    25. Multiple Choice DBA
    26. What are the Big Four Tactical Queries?
    27. The Four Tactical Queries
  15. Chapter 6 – Columnar Tables
    1. Columnar Tables have NO Primary Index
    2. This is NOT a NoPI Table
    3. NoPI Tables Spread rows across all-AMPs Evenly
    4. NoPI Tables used as Staging Tables for Data Loads
    5. NoPI Table Capabilities
    6. NoPI Table Restrictions
    7. What does a Columnar Table look like?
    8. Comparing Normal Table vs. Columnar Tables
    9. Columnar Table Fundamentals
    10. Example of Columnar CREATE Statement
    11. Columnar can move just One Container to Memory
    12. Containers on AMPs match up perfectly to rebuild a Row
    13. Indexes can be used on Columns (Containers)
    14. Indexes can be used on Columns (Containers)
    15. Visualize a Columnar Table
    16. Single-Column vs. Multi-Column Containers
    17. Comparing Normal Table vs. Columnar Tables
    18. Columnar Row Hybrid CREATE Statement
    19. Columnar Row Hybrid Example
    20. Columnar Row Hybrid Query Example
    21. Review of Row-Based Partition Primary Index (PPI)
    22. Visual of Row Partitioning (PPI Tables) by Month
    23. CREATE Statement for both Row and Column Partition
    24. Visual of Row Partitioning (PPI Tables) and Columnar
    25. How to Load into a Columnar Table
    26. Columnar NO AUTO COMPRESS
    27. Auto Compress in Columnar Tables
    28. Auto Compress Techniques in Columnar Tables
    29. When and When NOT to use Columnar Tables
    30. Did you know?
  16. Chapter 7 – Space
    1. When your System Arrives, there is only User named DBC
    2. USER DBC
    3. First Assignment is to create another User just under DBC
    4. USER DBC
    5. Perm and Spool Space
    6. Perm Space is for Permanent Tables
    7. Spool Space is work space that builds a User’s Answer Sets
    8. Spool Space is in an AMP’s Memory and on its Disk
    9. Users are Assigned Spool Space Limits
    10. What is the Purpose of Spool Limits?
    11. Why did my query Abort and say “Out of Spool”?
    12. How can Skewed Data cause me to run “Out of Spool”?
    13. Why did my Join cause me to run “Out of Spool”?
    14. What does my system look like when it first arrives?
    15. DBC owns all the PERM Space in the system on day one
    16. DBC’s First Assignment is Spool Space
    17. DBC’s 2nd Assignment is to CREATE Users and Databases
    18. The Teradata Hierarchy Begins
    19. The Teradata Hierarchy Continues
    20. Differences between PERM and SPOOL
    21. Databases, Users, and Views
    22. What are Similarities between a DATABASE and a USER?
    23. What is the Difference between a DATABASE and a USER?
    24. Objects that take up PERM Space
    25. A Series of Quizzes on Adding and Subtracting Space
    26. Answer 1 to Quiz on Space
    27. Space Transfer Quiz
    28. Answer to Space Transfer Quiz
    29. Drop Space Quiz
    30. Answers to Drop Space Quiz
  17. Chapter 8 – The User Environment
    1. DBC is the only user when the system first arrives
    2. DBC will Create Databases and Give them Space
    3. DBC will create some initial Users
    4. A Typical Teradata Environment
    5. What are Similarities between a DATABASE and a USER?
    6. Roles
    7. Create a Role and then Assign that Role Its Access Rights
    8. Create a User and Assign them a Default Role
    9. Granting Access Rights
    10. There are Three Types of Access Rights
    11. Description of the Three Types of Access Rights
    12. Profiles
    13. Creating a Profile and a User
    14. ProfileInfoVX, RoleMembers, RoleInfo and UserRoleRights
    15. Accounts and their Associated Priorities
    16. Creating a User with Multiple Account Priorities
    17. Account String Expansion (ASE)
    18. The DBC.AMPUsage View
  18. Chapter 9 - Join Indexes
    1. Creating a Multi-Table Join Index
    2. Visual of a Join Index
    3. Outer Join Multi-Table Join Index
    4. Visual of a Left Outer Join Index
    5. Compressed Multi-Table Join Index
    6. A Visual of a Compressed Multi-Table Join Index
    7. Creating a Single-Table Join Index
    8. Conceptual of a Single Table Join Index on an AMP
    9. Single Table Join Index Great For LIKE Clause
    10. Single Table Join Index with Value Ordered NUSI
    11. Aggregate Join Indexes
    12. Compressed Single-Table Join Index
    13. Aggregate Join Index
    14. New Aggregate Join Index (Teradata V14.10)
    15. Sparse Join Index
    16. A Global Multi-Table Join Index
    17. Creating a Hash Index
    18. Join Index Details
  19. Chapter 10 – Locking
    1. The Four Major Locks of Teradata
    2. The Read Lock
    3. The Read Lock and Joins
    4. The Write Lock
    5. The Exclusive Lock
    6. The Three Levels of Locking
    7. Locking at the Row Hash Level
    8. Locking at the Table Level
    9. Locking at the Database Level
    10. The Ongoing Battle between Read and Write Locks
    11. Compatibility between Read Locks
    12. Why Read Locks Wait on Write Locks
    13. Why Write Locks Wait on Read Locks
    14. The Access Lock is Different from the Other Locks
    15. What is the Purpose of an Access Lock?
    16. Locking Modifiers - Locking Row, Table or Database
    17. All Views should consider the Locking for Access Statement
    18. What is a Dead Lock or a Deadly Embrace?
    19. Pseudo Tables are designed to minimize Dead Locks
    20. Pseudo Tables are referenced in the Explain Plan
    21. Incompatible Locks Wait on each Other
    22. The Checksum Lock of Teradata
    23. The Nowait Option for Locking
    24. The Automatic Locking for Access Button inside Nexus
  20. Chapter 11 - View Functions
    1. Creating a Simple View
    2. The Semantic Layer
    3. Basic Rules for Views
    4. How to Modify a View
    5. Exceptions to the ORDER BY Rule inside a View
    6. How to Get HELP with a View
    7. Views sometimes CREATED for Formatting or Row Security
    8. CREATING Views for Complex SQL such as Joins
    9. WHY certain columns need Aliasing in a View
    10. Aggregates on View Aggregates
    11. Locking Row for Access
    12. Updating Data in a Table through a View
    13. Maintenance Restrictions on a Table through a View
  21. Chapter 12 - Macro Functions
    1. The 14 rules of Macros
    2. CREATING and EXECUTING a Simple Macro
    3. Multiple SQL Statements inside a Macro
    4. Complex Joins inside a Macro
    5. Passing an INPUT Parameter to a Macro
    6. Troubleshooting a Macro with INPUT Parameters
    7. Troubleshooting a Macro with INPUT Parameters
    8. An UPDATE Macro with Two Input Parameters
    9. Executing a Macro with Named (Not Positional) Parameters
  22. Chapter 13 – Data Modeling Techniques
    1. The Four Stages of Modeling for Teradata
    2. The Logical Model
    3. The Logical Model can be loaded inside Nexus
    4. Primary Keys Compared to Foreign Keys
    5. First, Second and Third Normal Form
    6. First Normal Form
    7. Second Normal Form
    8. Third Normal Form
    9. Quiz – Choose that Normalization Technique
    10. Answer to Quiz – Choose that Normalization Technique
    11. Quiz – What Normalization Is It Now?
    12. Answer to Quiz – What Normalization Is It Now?
    13. The Employee_Table and Department_Table Can Be Joined
    14. The Employee_Table and Department_Table Join SQL
    15. Dimensional Modeling
  23. Chapter 14 – Things to Consider
    1. Teradata Mode vs. ANSI Mode
    2. ANSI Mode Transactions
    3. Teradata Mode Transactions
    4. Multi-Statement Transaction in BTEQ
    5. Teradata Mode Default is a Set Table
    6. An Example of a Duplicate Row Error
    7. Creating a Set Table with a Unique Primary Index
    8. Creating a Set Table with a Unique Secondary Index
    9. ANSI mode defaults to a Multiset Table
    10. Using a Volatile Table to Get Rid of Duplicate Rows
    11. Creating a Volatile Table
    12. You Populate a Volatile Table with an INSERT/ SELECT
    13. The Three Steps to Use a Volatile Table
    14. Why Would You Use the ON COMMIT DELETE ROWS?
    15. The HELP Volatile Table Command Shows your Volatiles
    16. A Volatile Table with a Primary Index
    17. The Joining of Two Tables Using a Volatile Table
    18. Creating a Secondary Index on a Volatile Table
    19. You Can Collect Statistics on Volatile Tables
    20. The New Teradata V14 Way to Collect Statistics
    21. CREATING A Global Temporary Table
    22. Using a Simple Global Temporary Table
    23. Two Brilliant Techniques for Global Temporary Tables
    24. The Joining of Two Tables Using a Global Temporary Table
  24. Chapter 15 – A DBA’s best friend - The Data Dictionary
    1. The Data Dictionary Resides in User DBC
    2. The DBC.DBCInfoV View
    3. Querying the Data Dictionary
    4. Using the Keyword USER
    5. Restricted Views have an X at the End of their Name
    6. The V is New with Teradata V12
    7. The V and the Restricted X are Now Often Combined
    8. A Recap of What We Have Learned So Far
    9. The DBC.DatabasesV View
    10. The DBC.Users View
    11. The DBC.AMPUsage View
    12. Clearing Out the DBC.AMPUsage Data
  25. Chapter 16 - Compression
    1. User Defined Compression Techniques
    2. Lossy and Lossless Compression
    3. Algorithmic Compression
    4. Block Level Compression
    5. Temperature-Based Block Level Compression
    6. The Teradata 2690 has Hardware Compression
    7. Row-Level Compression Utilizing a Compressed Join Index
    8. A Visual of a Compressed Multi-Table Join Index
    9. Important Information about Multi-Value Compression (MVC)
    10. Presence Bytes are also used for Multi-Value Compression
    11. A MVC Compression Example that Compresses Two Values
    12. A MVC Compression Example that Compresses Three Values
    13. Quiz – Name that MVC Compression Value
    14. The Next Important Concept in MVC Compression
    15. Quiz – Can you Fill in the MVC Compression Values?
    16. Answer – Can you Fill in the MVC Compression Values?
    17. The Multi-Value Compression (MVC) Cost vs. the Savings
    18. The Cost List of MVC Compression
    19. Auto Compress in Columnar Tables
    20. Auto Compress Techniques in Columnar Tables
    21. Columnar Tables Automatically Compress unless NO AUTO COMPRESS
  26. Chapter 17 – Protection Features
    1. A List of the Protection Features
    2. Transient Journal Protects the Transaction Integrity
    3. The Transient Journal in Action
    4. A Single Transaction could Involve All AMPs
    5. The Secret to turning off the Transient Journal
    6. Fallback to Protect against an AMP Failure
    7. Fallback Clusters
    8. AMPs in a Cluster are Physically Separated
    9. The Reason AMPs in a Cluster are Physically Separated
    10. The Price you pay for Fallback
    11. How to Create a Table with Fallback
    12. How to Create a Table with No Fallback
    13. How to Alter a Table to Add or Drop Fallback
    14. What is a Virtual Disk?
    15. Why do AMPs each have Four Physical Disks?
    16. Is a Mirror just like Looking into a Mirror?
    17. RAID 1 Mirroring – Redundant Array of Independent Disks
    18. What does RAID Protect?
    19. How Does RAID Fail?
    20. Do RAID and Fallback have a Connection?
    21. What is a Clique?
    22. If a Node goes down the AMPs migrate within the Clique?
    23. Does Teradata Reset during a Node Failure?
    24. Four Node Cliques
    25. Migrating AMPs in Four Node Cliques
    26. The Hot Spare Node
    27. The Hot Spare Node in Action
    28. With a Hot Spare a Second Teradata Reset isn’t Needed
    29. A Node, It’s AMPs and their Disks
    30. How Cliques are Physically Defined
    31. Cliques are cabled so Migrating AMPs can access their Disks
    32. A Review of Fallback and Clusters
    33. An Example of Fallback and Clusters
    34. Quiz 1 – How Many Clusters do you see?
    35. Quiz 1 Answer – How Many Clusters do you see?
    36. Quiz 2 – How Many Cliques do you see?
    37. Quiz 2 Answer – How Many Cliques do you see?
    38. Quiz 3 – What have we lost? Multiple Choice Answer
    39. Quiz 3 Answer – What have we lost? Multiple Choice Answer
    40. Quiz 4 – What have we lost? Multiple Choice Answer
    41. Quiz 4 Answer – What have we lost? Multiple Choice Answer
    42. Quiz 5 – What have we lost? Which Answer is False?
    43. Quiz 5 Answer – What have we lost? Which Answer is False?
    44. Quiz 6 – What have we lost? Pick Two True Answers
    45. Quiz 6 Answer – What have we lost? Pick Two True Answers
    46. Summary of the facts for Fallback, Clusters, and Cliques
    47. Quiz 7 –How Many Virtual Disks (Vdisks) are in this System?
    48. Quiz 7 Answer –How Many Virtual Disks are in this System?
    49. Quiz 8 –How Many Physical Disks are in this System?
    50. Quiz 8 Answer–How Many Physical Disks are in this System?
    51. Quiz 9 – How Many Transient Journals in this System?
    52. Quiz 9 Answer –How Many Transient Journals in this System?
    53. Quiz 10 – How Many Transient Journals are Open?
    54. Quiz 10 Answer – How Many Transient Journals are Open?
    55. Quiz 11 – How Much Space?
    56. Quiz 11 Answers – How Much Space?
    57. Quiz 12 – How Much Space with Fallback?
    58. Quiz 12 Answers – How Much Space with Fallback?
    59. Quiz 13 – How Many Disks could we lose with RAID 1?
    60. Quiz 13 Answer – How Many Disks could we lose?
    61. Quiz 14 – How Many Disk losses could Kill Us?
    62. Quiz 14 Answer – How Many Disk losses could Kill Us?
    63. Quiz 15 – How Many AMPs could we lose if Lucky?
    64. Quiz 15 Answer – How Many AMPs could we lose if Lucky?
    65. Quiz 16 – How Many AMPs could we lose if Unlucky?
    66. Quiz 16 Answer – How Many AMPs could we lose Unlucky?
    67. The Permanent Journal
    68. Difference between the Transient and the Permanent Journal
    69. Difference Between the Before and After Permanent Journal
    70. Full System Backup compared to an After Journal
    71. How Full System Backups work with the After Journal
    72. The Many Different Permanent Journal Options
    73. Where is the Permanent Journal Stored?
    74. Using Common Sense about Journal Locations
    75. After Journals are Never stored in the Same Node or Clique
    76. What is a Dual After Journal?
    77. What is a Dual Before Journal?
    78. What is a Journal?
    79. Creating a Table with Fallback and a Before and After Journal
    80. Does Fallback Affect a Permanent Journal?
    81. Permanent Journal Rules
    82. Example 1: Permanent Journal Scenarios to Test the Rules
    83. Example 2: Permanent Journal Scenarios to Test the Rules
    84. Example 3: Permanent Journal Scenarios to Test the Rules
    85. How to Create Database with a Permanent Journal
    86. Creating Tables under different Journal Circumstances
    87. Permanent Journal’s Three Main Areas
    88. The Current Journal consists of the Active and Saved Areas
    89. Permanent Journal Commands
    90. Deleting a Permanent Journal
    91. Some Great Advice for Maintaining the Permanent Journals
    92. Recovery Using the Permanent Journals
    93. The Journals View in DBC (DBC.Journals)
    94. Archive Recovery Console (ARC)
    95. Reasons You Might Utilize ARC
    96. ARC raising the BAR (Backup Archive Restore)
    97. ARC Commands in Alphabetical Order
    98. An ARC Example of an Archive and then a Restore
  27. Chapter 18 - Viewpoint
    1. Database Administration (DBA) on Teradata
    2. Viewpoint
    3. Logging into Viewpoint
    4. The First Time you Login to Viewpoint
    5. The Add Content Menu for Monitoring
    6. The Add Content Menu for TASM
    7. The Add Content Menu for Tools
    8. The Add Content Menu for Trend Reporting
    9. Adding your first Content
    10. How the Page looks after you add your first Content
    11. Adding Additional Pages
    12. The Fundamentals of Viewpoint Pages and Portals
    13. Adding Multiple Portals to a Single Page
    14. All Portals to Their Individual Tab
    15. Portlet Controls
    16. The Rewind Control
    17. Query Monitor Overview
    18. Query Monitor Details View
    19. Query Monitor Actions
    20. My Queries
    21. Calendar
    22. System Health
    23. System Health Drilldown
    24. Space Usage
    25. Space Usage Preferences
  28. Chapter 19 - TASM
    1. Three Levels of Workload Management
    2. Pre-execution, Query Execution, and Post-execution
    3. What is TASM?
    4. Query Management compared to Workload Management
    5. The Active Workload Management Concept
    6. Active Events
    7. What is the Secret Sauce for Query Management?
    8. The life of a Query
    9. What is a Workload?
    10. Workload Examples
    11. There are Four Types of Query Rules
    12. Common Sense Examples of Filters and Throttles
    13. Performance Period Examples
    14. The Scoop on Object Throttles
    15. Load Utility Throttles
    16. Creating Workloads
    17. When Creating Workloads the “WHO” is your Foundation
    18. After the “WHO” comes the “WHERE”
    19. After the “WHO” and the “WHERE” comes the “WHAT”
    20. Exception Actions
    21. Teradata Workload Analyzer
    22. Teradata Workload Analyzer
    23. Pre-execution, Query Execution, and Post-execution
    24. Why use Priority Scheduler?
    25. The Concept of a Resource Partition
    26. Resource Partitions
    27. The Clever Idea behind Resource Partitioning
    28. The Brilliant Idea behind Resource Partitioning
    29. The Concept of Resource Partitions and Weights?
    30. The Concept of a Workload in a Resource Partition
    31. How to Configure Priority Scheduler
    32. Workload Designer
    33. The Three Areas of the Workload Designer
    34. How the Area of Workload Designer are Used
  29. Chapter 20 - Teradata Load Utilities Introduction
    1. The Teradata Utilities
    2. Block Level Utilities
    3. Row Level Utilities
    4. The Active Load Concept
    5. BTEQ – Batch Teradata Query Tool
    6. How to Logon to BTEQ in Interactive Mode
    7. Running Queries in BTEQ in Interactive Mode
    8. BTEQ Commands vs BTEQ SQL Statements
    9. How to Logon to BTEQ in a SCRIPT
    10. Running Queries in BTEQ through a Batch Script
    11. Running a BTEQ Batch Script through the Command Prompt
    12. Running a BTEQ Batch Script through the Run Command
    13. Using Nexus to Build Your BTEQ Scripts
    14. Using Nexus to Build Your BTEQ Scripts
    15. FastLoad
    16. Block Level Utility Limits
    17. FastLoad has Two Phases
    18. FastLoad Phase 1
    19. FastLoad Phase 2
    20. A Sample FastLoad Script Created by Nexus SmartScript
    21. Executing the FastLoad Script
    22. The Nexus SmartScript Easily Builds Your Utilities
    23. The Nexus SmartScript FastLoad Builder
    24. Create and Execute Your FastLoad Scripts with Nexus
    25. MultiLoad
    26. Block Level Utility Limits
    27. MultiLoad has Five Phases
    28. MultiLoad has IMPORT and DELETE Tasks
    29. A Sample MultiLoad Script Created by Nexus SmartScript
    30. TPump
    31. TPump is NOT a Block Level Utility and has No Limits
    32. Limitations of TPump
    33. A Sample TPump Script Created by Nexus SmartScript
    34. FastExport
    35. New Rules for Block Utilities
    36. A Sample FastExport Script Created by Nexus SmartScript
    37. FastExport by Default places Null Indicators in Output
    38. A Sample FastExport Script Created by Nexus SmartScript
    39. What is TPT?
    40. TPT Producers Create Streams and Consumers Write Them
    41. The Four Major Operators of TPT
    42. TPT can read from multiple source files in Parallel
    43. TPT can have more Operators than Consumers
    44. TPT Operators and their Equivalent Load Utility
    45. How to Run a TPT Script
  30. Chapter 21 – Teradata Tools and Everything Active
    1. Teradata Analyst Pack
    2. Teradata Visual Explain Utility
    3. TSET
    4. Index Wizard
    5. Statistics Wizard
    6. Active Access Queries
    7. Active Availability
    8. The Active Workload Management Concept
    9. Active Events
    10. The Active Load Concept
    11. Active Enterprise Integration
  31. Chapter 22 – Practice Test Questions to Build Your Confidence
    1. Questions without answers:
    2. Questions with answers:
  32. Chapter 23 – Lessons with Tera-Tom Video Guide
    1. Video 1 - Teradata Basics - The Architecture
    2. Video 2 - Hashing the Primary Index
    3. Video 3 - The Cold Hard Teradata Facts
    4. Video 4 -Inside the Amps’ Disc
    5. Video 5 - PPI (Partitioned Primary Index Tables)
    6. Video 6 Teradata Columnar
    7. Video 7- Space
    8. Video 8 - How Teradata Joins Tables Together
    9. Video 9- Protection Features (1/3)
    10. Video 10- Protection Features (2/3)
    11. Video 11- Protection Features (3/3)
    12. Video 12- Collect Statistics (1 of 2)
    13. Video 13- Collect Statistics (2 of 2)
    14. Video 14- Locking
    15. Video 15- Temporal Tables
    16. Video 16- Join Indexes
    17. Teradata SQL Video 1 - The Basics of SQL
    18. Teradata SQL Video 2 – Building Your SQL Knowledge
    19. Teradata SQL Video 3 - Aggregates
    20. Teradata SQL Video 4 - Joins
    21. Teradata SQL Video 5 - Dates
    22. Teradata SQL Video 6 – Temporary Tables (Derived)
    23. Teradata SQL Video 7 – Volatile and Global Temporary Tables
    24. Teradata SQL Video 8 – Ordered Analytic Functions
    25. Teradata SQL Video 9 – Advanced Ordered Analytics
    26. Teradata SQL Video 10 - Subqueries
    27. Teradata SQL Video 11 – Substring and Positioning
    28. Teradata SQL Video 12 – Data Interrogation
    29. Teradata SQL Video 13 - Views
    30. Teradata SQL Video 14 - Macros
    31. Teradata SQL Video 15 – Stored Procedures
    32. Teradata SQL Video 16 – Set Operators
    33. Teradata SQL Video 17 – Creating Tables