Buy on Amazon now!
Buy on Appl iBooks now!
Buy on Kobo books now!

Teradata Certification Physical Design and Implementation (v14)

The Teradata Certification Physical Design and Implementation Guide is designed for those who are interested in becoming a Teradata Certified Technical Specialist or higher. Through simplified examples and explanations, this guide prepares the reader to take the. Through simplified examples and explanations, this guide prepares the reader to take the Teradata Physical Design and Implementation Exam.

  • Extended Logical and Physical Data Models
  • Primary and Secondary Indexes
  • Multi-Level Partitioned Primary Indexes (MLPPI)
  • Denormalization Techniques
  • Join Types and Strategies
  • Explain Terminology
  • Query Analysis using DBQL and Access Logging
  • Locking Modifiers and Transactions
  • Considerations for Implementing Statistics and Compression
  • Database Objects, Manipulation, and Management

The Teradata 14 Certification Study Guides are the only Teradata authorized study publications. Cerulium Corporation partners with Teradata and the Teradata Certified Professional Program to author the Teradata 14 Certification Study Guides.

Teradata Certified Technical Specialist

“A successful candidate has core knowledge and skills about Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language as well as the core knowledge and skills necessary to design and implement a Teradata Database from a logical data model. The candidate understands the Teradata implementation of data distribution, space usage, data access and data manipulation processes. The candidate can implement a Teradata Database using a set of requirements.”*

Teradata Certification Physical Design and Implementation Exam TEO-143 is required for:

  • Teradata Certified Technical Specialist
  • Teradata Certified Database Administrator
  • Teradata Certified Solutions Developer
  • Teradata Certified Enterprise Architect
  • Teradata Certified Master

 

Chapter 1: The Teradata Certified Professional Program              

  • Pursue Teradata Certification with Confidence™
  • Your Teradata 14 Certification Upgrade Roadmap
  • Certification… Knowledge Building to Mastery
  • Path to Teradata 14 Mastery
  • Exam Registration
  • Where to Find More Information

Chapter 2: Extended Logical Model        

  • Teradata Certification Physical Design Implementation Objectives
  • Application Development Life Cycle
  • Logical Data Model
  • Primary Keys (PK)
  • Foreign Keys (FK)
  • Normalization
  • Extended Logical Data Model (ELDM)
  • Column ACCESS in the WHERE Clause
  • Data Demographics
  • Distinct Values
  • Maximum Rows Per Value
  • Typical Rows Per Value
  • NULL Values
  • Change Rating
  • ELDM Template
  • Chapter 2: Practice Questions

Chapter 3: Physical Data Model (PDM) 

  • Teradata Certification Physical Design and Implementation Objectives
  • Primary and Secondary Index Factors
  • System Generated Keys
  • Natural Key
  • Surrogate Key
  • Step 1 – Review Distribution
  • Step 2 – Eliminate based on Change Rating
  • Step 3 – NUSI Elimination via Value Access Frequency
  • Step 4 – Choose the Primary Index
  • Step 5 – Choose the Secondary Indexes
  • Join Access Frequency Priority
  • Value Access Frequency Priority
  • USI to Eliminate Duplicate Row Checking
  • NUSI Considerations
  • Multi-Column NUSI Columns Used as a Covered Query
  • Value-Ordered NUSIs
  • A Formula for Calculating a Strongly Selective NUSI
  • Typical Row and Block Sizes
  • Chapter 3: Practice Questions

Chapter 4: Data Distribution      

  • Teradata Certification Physical Design and Implementation Objectives
  • Primary Index
  • Unique Primary Index (UPI)
  • Non-Unique Primary Index (NUPI)
  • Primary Index and the Row Hash
  • Row Hash, Hash Map, and Hash Buckets
  • Review: Inserting a Row on an AMP
  • Unique Row Identifier
  • RowID for Unique Primary Index
  • RowID for Non-Unique Primary Index
  • Row Retrieval Using the Primary Index
  • Checking for Collisions
  • Row Distribution – NUPIs
  • Row Distribution – UPIs
  • How Teradata Handles Data Distribution
  • NoPI (No Primary Index)
  • Access Methods
  • Chapter 4: Practice Questions

Chapter 5: Partitioned Primary Indexes               

  • Teradata Certification Physical Design and Implementation Objectives
  • Primary Index Access (NPPI)
  • Partitioned Primary Index (PPI) Access
  • Implementing PPI
  • Partition Elimination and Full Table Scans
  • Accessing via the Primary Index in a PPI Table
  • Accessing via the Primary Index on PPI Table
  • Workaround
  • Partitioning with CASE_N
  • RANGE_N Partitioning
  • PPI with Multiple Ranges Defined
  • CHARACTER PPI
  • Implementing Multi-Level Partitioned Primary
  • Indexes
  • MLPPI Examples
  • Rules for MLPPI
  • Partition Ordering
  • Columnar Partitioning
  • Determining the Rows in Each Partition
  • Altering PPI Tables to Add or Delete Partitions
  • ALTER TABLE TO CURRENT
  • ALTER TABLE vs. CREATE TABLE
  • NO CASE, NO RANGE, or UNKNOWN
  • Join Considerations and PPI
  • PPI Advantages
  • PPI Limitations
  • Chapter 5: Practice Questions

Chapter 6: Secondary Indexes  

  • Teradata Certification Physical Design and Implementation Objectives
  • Secondary Index Subtable
  • Unique Secondary Index (USI)
  • Unique Secondary Index Walkthrough
  • Non-Unique Secondary Index (NUSI)
  • Non-Unique Secondary Index Walkthrough
  • Value Ordered Secondary Index
  • Value Ordered NUSI Walkthrough
  • Non-Unique Secondary Indexes and Statistics
  • NUSI Bit Mapping
  • Covering Indexes
  • Chapter 6: Practice Questions

Chapter 7: Denormalization Techniques              

  • Teradata Certification Physical Design Implementation Objectives
  • Derived Data
  • Storing Aggregates
  • Pre–Joining Tables
  • Covered Query
  • Summary Tables
  • Derived Tables
  • Volatile Temporary Tables
  • Global Temporary Tables
  • Denormalization Effects
  • Chapter 7: Practice Questions
  • Chapter 8: Join Types and Strategies
  • Certification Objectives
  • Basic Join Example
  • Join Types and Strategies
  • Join Strategies: Merge
  • Join Strategies: Merge Strategy #1
  • Join Strategies: Merge Strategy #2
  • Join Strategies: Merge Strategy #3
  • Join Strategies: Merge Strategy #4
  • Nested Join
  • Hash Join
  • Exclusion Join
  • Product Joins
  • Cartesian Product Join
  • Chapter 8: Practice Questions

Chapter 9: Join Indexes               

  • Teradata Certification Physical Design and Implementation Objectives
  • Basic types of Join Indexes
  • When to Use a Join Index
  • Join Index Considerations
  • Join Indexes versus Other Options
  • Join Indexes versus Views
  • Join Indexes versus Summary Tables
  • Join Indexes versus Temporary Tables
  • Single-Table Join Index
  • Multi-Table Join Index
  • Aggregate Join Index
  • Sparse Index
  • Global Join Index
  • Global Join Index – Multi-Table Join Back
  • Global Join Index as a “Hashed-NUSI”
  • Hash Indexes
  • Hash Indexes Versus Single-Table Join Indexes
  • Chapter 9: Practice Questions

Chapter 10: Explains      

  • Teradata Certification Physical Design and Implementation Objectives
  • Explain Terminology
  • Full Table Scan
  • Unique Primary Index (UPI)
  • Non-Unique Primary Index (NUPI)
  • Unique Secondary Index (USI)
  • Non-Unique Secondary Index (NUSI)
  • Pseudo Locks
  • Confidence Levels
  • Parallel Operations
  • Redistributed by Hash Code
  • Duplicated on All AMPs
  • Join Index
  • BMSMS Bit Mapping
  • PPI Tables and Partitions
  • Group AMPs, SORT, Eliminating Duplicate Rows,
  • and No Residual Conditions
  • Last Use, End Transaction, and Computed Globally
  • Chapter 10: Practice Questions

Chapter 11: Query Analysis and Tools   

  • Teradata Certification Physical Design Implementation Objectives
  • Help and Show Commands
  • Using DBQL
  • DBC.Accesslog
  • MERGEBLOCKRATIO
  • PACKDISK
  • Teradata Index Wizard
  • Visual Explain
  • Skewed Distribution
  • CREATE TABLE … AS
  • Avoid Implicit Data Conversion
  • Full Table Scans
  • Aggregations
  • Nested Views
  • Chapter 11: Practice Questions

Chapter 12: Locks and Transactions        

  • Teradata Certification Physical Design and Implementation Objectives
  • Teradata locks and Levels
  • Locks Strategies and Compatibility
  • Locking Modifiers
  • The NOWAIT Option
  • Utility Locks
  • Showlocks
  • Release Lock Commands
  • ANSI Versus Teradata Mode
  • Multi-Statement Serialization Locks
  • Merge-Into Locks
  • Chapter 12: Practice Questions

Chapter 13: Databases, Objects, Manipulations, and Management         

  • Teradata Certification Physical Design and Implementation Objectives
  • Databases and Users
  • Database Space Considerations
  • Data Types
  • CREATE TABLE Attributes
  • CREATE TABLE AS Attributes
  • SET Versus MULTISET
  • Queue Tables
  • Tables – Rename, Alter, Drop
  • Column Attributes
  • Unicode Data Types
  • Insert/Select Considerations
  • Update/Insert Considerations
  • Merge Into Considerations
  • Referential Integrity
  • Constraint Types
  • Chapter 13: Practice Questions

Chapter 14: Temporal Tables     

  • Teradata Certification Physical Design and Implementation Objectives
  • Period Temporal Data Types
  • AS OF Query
  • Chapter 14: Practice Questions

Chapter 15: Compression            

  • Teradata Certification Physical Design and Implementation Objectives
  • How Compression Works
  • Determining the Table Header Size
  • Considerations Before Implementing Compression
  • Determining the Proper Data Type
  • Implementing Compression
  • Compression Case Sensitivity Example
  • Alter Options with Compression
  • Compressed Join Indexes
  • Column Compression
  • Algorithmic Compression
  • Software-Based Block-Level Compression
  • Temperature-Based Block-Level Compression
  • Compression Considerations
  • Chapter 15: Practice Questions

Chapter 16: Statistics    

  • Teradata Certification Physical Design and Implementation Objectives
  • Collect Statistics Process
  • STATS Storage
  • Statistics Considerations
  • Multi-Column Statistics Considerations
  • Random AMP Sampling
  • Data Dictionary Cache
  • Full Statistics
  • Sample Statistics
  • Summary Statistics
  • COLLECT STATISTICS Detailed Syntax
  • Enabling a Rollup
  • COLLECT STATISTICS Examples
  • HELP STATISTICS Options
  • SHOW STATISTICS Command
  • COLLECT STATISTICS – Recommendations
  • Statistics Wizard
  • Chapter 16: Practice Questions

 

Paperback: 315 pages
Publisher: Cerulium Corporation (2013)
ISBN: 978-0989400510

In Stock: Yes

*http://www.teradata.com/Certification

2017-03-23T17:58:47+00:00