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

Teradata Certification Basics (V14)

The Teradata Certification Basics Guide is designed for those who are interested becoming Teradata Certified Professional or higher. Through simplified examples and explanations, this guide prepares the reader to take the Teradata Basics Exam.

  • Data Warehouse Architectures
  • Relational Database Concepts
  • Teradata Database Fundamentals
  • Importance of Data Distribution
  • Data Protection Features
  • Security and Privacy Methods
  • Load, Extract and Archive Utilities
  • Teradata Analyst Pak Features
  • Workload and Systems Management
  • Easy-to-Understand Examples

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 14 Certified Professional

“A successful candidate has knowledge of the core concepts of the Teradata database and related technologies. The candidate understands relational database concepts, the major components, features, functionality, and Teradata’s data distribution and data access methods. The candidate has an understanding of operational, tactical, strategic business intelligence, and analytical processing.”*

Teradata Certification Basics Exam TEO-141 is required for:

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

 

Chapter 1: Teradata Product Overview 

  • Teradata Certification Basics Objectives
  • The Teradata RDBMS
  • Teradata’s Unique Features
  • Teradata Active Solutions
  • Supported Platforms
  • Chapter 1: Practice Questions

Chapter 2: Data Warehouse Architectures          

  • Teradata Certification Basics Objectives
  • Data Layers
  • Active Data Warehousing
  • Evolution of Data Processing
  • Distributed Architecture
  • Centralized Data Warehouse
  • Data Marts
  • Processing Types and Characteristics
  • Chapter 2: Practice Questions

 Chapter 3: Relational Database Concepts            

  • Teradata Certification Basics Objectives
  • Logical Data Modeling
  • Primary Keys
  • Foreign Keys
  • Normalization
  • Dimensional Modeling
  • Star Schema vs. 3NF Model
  • Chapter 3: Practice Questions

Chapter 4: Teradata RDBMS Components and Architecture        

  • Teradata Certification Basics Objectives
  • Parsing Engine (PE)
  • Teradata BYNET
  • Access Module Processors (AMPs)
  • Nodes
  • Space Allocation
  • Chapter 4: Practice Questions

Chapter 5: Database Managed Storage and Data Access               

  • Teradata Certification Basics Objectives
  • Data Distribution Management
  • Primary Indexes
  • Join Index (JI)
  • Index Columns and Statistics
  • Data Distribution on the AMPs
  • Access Methods
  • Locking
  • Chapter 5: Practice Questions

Chapter 6: Storage Optimization             

  • Teradata Certification Basics Objectives
  • Compression
  • Lossy and Lossless Compression
  • Multi-Value Compression (MVC)
  • Row-Level Compression
  • Columnar Container Compression
  • Algorithmic Compression (ALC)
  • Block-Level Compression
  • Temperature-Based Block-Level Compression
  • Hardware-Based Block-Level Compression
  • Chapter 6: Practice Questions

Chapter 7: Data Availability Features    

  • Teradata Certification Basics Objectives
  • Transient Journal
  • Fallback
  • Down AMP Recovery Journal
  • Redundant Array of Independent Disks (RAID)
  • Cliques
  • Hot Standby Node
  • Chapter 7: Practice Questions

Chapter 8: Security and Privacy

  • Teradata Certification Basics Objectives
  • Authentication
  • Teradata Wallet
  • Privileges and Access Rights
  • Access Rights Mechanisms
  • Roles
  • Profiles
  • Row Level Security
  • Views
  • Macros
  • Stored Procedures
  • User Defined Functions (UDFs)
  • Chapter 8: Practice Questions

Chapter 9: Teradata Tools and Utilities 

  • Teradata Certification Basics Objectives
  • BTEQ
  • FastLoad
  • FastExport
  • MultiLoad
  • TPump
  • Teradata Analyst Pack
  • Teradata Administrator
  • Chapter 9: Practice Questions

Chapter 10: Workload Management      

  • Teradata Certification Objectives
  • Response Time and Throughput
  • Teradata Active System Management
  • Teradata Workload Analyzer
  • Teradata Viewpoint
  • Priority Scheduler
  • Database Query Log (DBQL)
  • Chapter 10: Practice Questions

Chapter 11: System Management           

  • Teradata Certification Basics Objectives
  • Dual Active Solutions
  • Teradata Data Mover
  • Teradata Multi-System Manager
  • Teradata Query Director
  • Teradata Replication Services
  • Teradata Unity
  • Chapter 11: Practice Questions

 

Paperback: 175 pages
Publisher: Cerulium Corporation (2013)
ISBN: 978-0983024293

In Stock: Yes

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

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