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