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

Teradata Certification Solutions Development Guide (V14)

The Teradata Certification Solutions Development Guide is designed for those who are interested in becoming a Teradata Certified Solutions Developer. Through simplified examples and explanations, this guide prepares the reader to take the Teradata Solutions Development Exam.

  • Logical, Physical, Access Layer Models
  • Space Usage and Table Types
  • SQL Optimization Strategies
  • Multi-Level Partitioned Primary Indexes (MLPPI)
  • NoPI and Columnar Tables
  • Secondary and Join Indexes
  • Join Types and Strategies
  • Explain Terminologies
  • Load Utility Considerations
  • Data Integration and Performance
  • Performance Monitoring Tools and Facilities
  • Solution Planning Techniques

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 Solutions Developer

“A successful candidate has the knowledge and skills necessary to design and write optimized applications that integrate and access data in Teradata environments. The candidate leverages the parallelism and data manipulation techniques in Teradata. The candidate makes effective choices and use of available Teradata utilities, features, and functions in developing quality solutions.”*

Teradata Certification Solutions Development Exam TEO-145 is required for:

  • 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 – Data Modeling        

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Logical Data Modeling
  • Access Layer Modeling (Semantic Data Modeling)
  • Physical Data Modeling
  • Chapter 2: Practice Questions

Chapter 3 – Space Usage and Table Types           

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Perm/Spool/Temp Space
  • Permanent Space Terminology
  • CREATE TABLE Definitions
  • SET/MULTISET Tables
  • Derived Temporary Tables
  • Volatile Temporary Tables
  • Global Temporary Tables
  • Queue Tables
  • Chapter 3: Practice Questions

Chapter 4 – SQL Optimization Strategies             

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Locking
  • Recursive Queries
  • Views
  • Macros
  • Stored Procedures
  • Ordered Analytic Functions
  • Date/Time Manipulation
  • Period Data Types
  • Period Manipulation
  • Calendar Functions
  • Business Calendars
  • Nulls
  • Row vs. Set Manipulation
  • Collect Statistics
  • Chapter 4: Practice Questions

Chapter 5 – Indexes       

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • PI/SI Access Chart
  • NUSI Bitmapping
  • Value-Ordered NUSI
  • Hash NUSI
  • PPI – Partitioned Primary Index
  • MLPPI
  • No Primary Index (NoPI) tables
  • Column-Partitioned Tables
  • Column Partitioning and Query Performance
  • Horizontal Partitioning
  • Vertical Partitioning
  • Join Indexes
  • Sparse Indexes
  • Chapter 5: Practice Questions

Chapter 6 – Joins and Explain    

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Joins
  • Join Strategies
  • Join Types
  • Inner Joins
  • Outer Joins
  • Join Strategies
  • Merge Joins
  • Nested Joins
  • Hash Joins
  • Inclusion and Exclusion Join
  • Product Joins
  • EXPLAIN Terminology
  • Chapter 6: Practice Questions

Chapter 7 – Utilities      

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • BTEQ
  • FastLoad
  • FastExport
  • MultiLoad
  • TPump
  • Teradata Parallel Transporter
  • Utility Limits
  • Parameters
  • CLOBs and BLOBs
  • Client performance considerations
  • SET vs. MULTISET table loading
  • Duplicate Row Elimination
  • Data availability and integrity
  • Load Strategies
  • Chapter 7: Practice Questions

Chapter 8 – Data Integration and Performance 

  • Teradata Certification Solutions Development Objectives
  • Development Choices
  • Normalization
  • Event driven
  • Business Intelligence (BI)
  • Active Data Warehouse
  • Data integration
  • Data access
  • Unicode
  • Considerations for Loading PPI and MLPPI Tables
  • Considerations for Loading NoPI Tables
  • Chapter 8: Practice Questions

Chapter 9 – Maintaining Data Integrity 

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Triggers
  • RI Constraints
  • Check Constraints
  • Transaction mode
  • Multi-statement requests
  • Multi-request Transactions
  • User Defined Functions (UDFs)
  • Chapter 9: Practice Questions

Chapter 10 – Performance Monitoring Tools & Facilities             

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Access Logging
  • Database Query Log (DBQL)
  • Teradata Query Scheduler
  • Teradata Active System Management (TASM)
  • Teradata Viewpoint
  • Teradata Workload Analyzer
  • Priority Scheduler
  • Workload Designer
  • Workload Health
  • Resource Partitions and Performance Groups
  • Schmon Utility
  • Teradata Analyst Pack
  • Visual Explain
  • Statistics Wizard
  • Index Wizard
  • Teradata System Emulation Tool (TSET)
  • ResUsage
  • Locking Logger
  • DBC.AMPUsage
  • Chapter 10: Practice Questions

Chapter 11 – Solution Planning

  • Teradata Certification Solutions Development Objectives
  • Before You Begin
  • Capacity planning
  • Security planning
  • Migration Planning
  • Administration planning
  • Data integration
  • Dual system architecture
  • Chapter 11: Practice Questions

Paperback: 361 pages
Publisher: Cerulium Corporation (2014)
ISBN: 978-0989400541

In Stock: Yes

http://www.teradata.com/Certification

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