Buy on Amazon now!

Teradata Aster Basics Certification Study Guide

The Teradata Aster Basics Certification Study Guide is designed for those who are interested in becoming a Teradata Aster Certified Professional. Through detailed examples, and explanations this guide prepares the reader to write the Teradata Aster Basics 6.10 Certification Exam.

  • What is Big Data?
  • Aster Database Features and Functions
  • Teradata Unified Data Architecture (UDA)
  • Logical and Physical Database Design Components
  • Aster Loader Architecture and Connectors
  • System Objects and Monitoring Options (AMC)
  • SQL-MapReduce (SQL-MR) Functions
  • Analytic Functions and nPath
  • Customer Use Cases
  • Aster AppCenter

The Teradata Aster 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 Aster Certification Study Guides.

Teradata Aster Certified Professional

“A successful candidate has knowledge of the core concepts of Teradata Aster. The candidate has the ability to determine which common analytical functions apply to common use cases and can explain the business value of the most frequently used analytical functions. The candidate can describe the overall architecture at a high level, describe the basic idea of SQL-MR, and understands basic relational database concepts.”*

Teradata Aster Basics Certification Exam TAA-BSC6.10 is required for:

  • Teradata Certified Technical Specialist

Chapter 1: Introduction to Big Data

  • Certification Objectives
  • What is Big Data?
  • How is Big Data Handled?
  • Why is Big Data Important?
  • How is Big Data Analyzed?
  • Big Data Analytical Challenges
  • Chapter 1: Practice Questions

CHAPTER 2 – Aster Data Solution Overview

  • Certification Objectives
  • Aster Data Discovery Platform
  • Aster Architecture Overview
  • Queen Node
  • Worker Nodes
  • Loader Nodes
  • Backup Nodes
  • Scalability
  • Database Scalability
  • Expanding an Aster Database
  • Loading Scalability
  • Backup Scalability
  • SQL-MapReduce
  • Aster Database Features
  • Database Access Control
  • Aster Analytics Processing
  • Query Optimization
  • Workload Management
  • Row/Column Table Architecture
  • Compression
  • Aster Tools
  • Teradata Studio
  • Teradata Viewpoint
  • Aster Management Console (AMC)
  • Aster Command Terminal (ACT)
  • Data Availability
  • v-Worker Replication
  • v-Worker Failover
  • RAID
  • Aster Database Sizing
  • Chapter 2: Practice Questions

CHAPTER 3 – Aster Teradata Integration

  •  Certification Objectives
  • Data Analysis Platform Needs
  • Teradata Integrated Data Warehouse (IDW)
  • Hadoop
  • Hortonworks Hadoop
  • Aster Discovery Platform
  • Aster Discovery Platform Configuration
  • Aster Data Deployment Options
  • Unified Data Architecture
  • QueryGrid
  • Big Data Architecture Positioning
  • User Interface
  • Data Platforms
  • Supporting Software
  • Chapter 3: Practice Questions

CHAPTER 4 – Data Modeling and Organization

  • Certification Objectives
  • Logical Data Models
  • Analytic Data Models
  • 3rd Normal Form Physical Model
  • Star Schema
  • Snowflake Schema
  • Aster Physical Design Components
  • Aster Database Structure
  • Databases
  • Schemas
  • Schema Search Path
  • Objects
  • Typical Aster Database Organization
  • Chapter 4: Practice Questions

CHAPTER 5 – Creating and Managing Tables

  • Certification Objectives
  • Aster Tables
  • Fact Tables
  • Dimension Tables
  • Persistence
  • Temporary Tables
  • Analytic Tables
  • Columns
  • Column Rules
  • Column Constraints
  • Data Types
  • Character Data Types
  • Numeric Data Types
  • Date/Time Data Types
  • Special Data Types
  • Physical and Logical Partitioning
  • Physical Partitioning by Hash
  • Physical Partitioning by Replication
  • Physical Partitioning Considerations
  • Logical Partitioning
  • Logical Partitioning Considerations
  • Logical Partition Maintenance
  • Multi-Level Partitioning
  • Managing Tables
  • Multi-Version Concurrency Control (MVCC)
  • Managing Table Space
  • TRUNCATE
  • VACUUM
  • VACUUM FULL
  • VACUUM Catalogs
  • “VACUUMing” Indexes
  • ANALYZE
  • VACUUM and ANALYZE Recommendations
  • Chapter 5: Practice Questions

CHAPTER 6 – Data Loading and Validation

  • Certification Objectives
  • Data Sources
  • Aster Loading Architecture
  • Aster Loading Data Flow
  • Loading Configuration Options
  • Loader Node
  • Aster Loader Tool
  • Invoking ncluster_loader
  • Input File Considerations
  • Pre/Post Load Processing
  • Loading Multiple Files/Multiple Tables
  • Loader Node Load Balancing
  • Error Logging
  • Error Table
  • Load Statistics
  • Load Correction
  • Aster Export Tool
  • Invoking ncluster_export
  • Other Data Input/Output Methods
  • COPY
  • SQL INSERT
  • ODBC/JDBC
  • Connectors
  • ETL Tools
  • Chapter 6: Practice Questions

CHAPTER 7 – System Tables and Management

  • Certification Objectives
  • System Tables/Views
  • User Owned Views
  • User Views
  • All Views
  • Database Object Based Views
  • Query Process Based Views
  • System Utilities
  • Aster Management Console (AMC)
  • Dashboard Tab
  • Processes Tab
  • Nodes Tab
  • Admin Tab
  • Chapter 7: Practice Questions

CHAPTER 8 – SQL-MR

  • Certification Objectives
  • What is SQL-MR?
  • SQL/Relational Databases
  • Map-Reduce/Distributed File Systems
  • Shortcomings of SQL and Map-Reduce
  • SQL-MR Development
  • SQL-MR
  • How Is SQL-MR Implemented
  • Development/Implementation
  • Processing Engines
  • Type of SQL-MR functions
  • Map/Row Functions
  • Reduce/Partition Functions
  • SQL and Map-Reduce Together
  • ON Clause
  • PARTITION BY Clause
  • ORDER BY Clause
  • Additional Argument Clause
  • Analytic Application Data Flow
  • Value of SQL-MR
  • Technical Value
  • SQL-MR Examples
  • Word Count
  • Tool Selection
  • Chapter 8: Practice Questions

CHAPTER 9 – Aster Analytical Foundation

  • Certification Objectives
  • Aster Analytics
  • Data Transformation
  • Pack
  • Pivot
  • Apache_Log_Parser
  • PSTParserAFS
  • Association Analysis
  • Basket_Generator
  • CFilter
  • Graph Analysis
  • Betweenness
  • Closeness
  • Path Analysis
  • Attribution
  • Path_Generator
  • Sessionization
  • nPath
  • Text Analysis
  • ExtractSentiment
  • nGram
  • TF_INF
  • Levenshtein Distance (LDist)
  • Statistical Analysis
  • Histogram
  • Confusion Matrix
  • Generalized Linear Model (GLM)
  • GLMPredict
  • Cluster Analysis
  • Canopy
  • K-means Clustering
  • Chapter 9: Practice Questions

CHAPTER 10 – nPath

  • Certification Objectives
  • What is nPath?
  • Visualizing nPath
  • nPath Syntax
  • Path Clauses – Input Preparation
  • nPath Clause – Search Specification
  • nPath Clauses – Output Formulation
  • nPath Pattern Operators
  • nPath Symbol Predicate Expressions
  • nPath Result Aggregate Functions
  • nPath Examples/Exercises
  • Chapter 10: Practice Questions

CHAPTER 11 – Custom Use Cases

  • Certification Objectives
  • Clickstream Analysis
  • Pattern of Events in a Sequence
  • Events Preceding an Account Closure
  • Finding Paths Across Sites
  • Online Retailer Use Cases
  • Online Gaming Use Cases
  • Attribution of Events
  • nPath Attribution
  • Social Networking Properties Contribution Graph
  • Multi-Channel Attribution
  • Attribution Examples
  • nPath Multi-Channel Attribution
  • Attribution Distribution
  • Detection of Fraud
  • Fraud Detection
  • Online Fraud at a Financial Institution
  • Real Time Fraud Detection
  • Fraud Analytics
  • Predictive Analytic
  • Propensity Modeling
  • Decision Tree – Training Module
  • Decision Tree – Classify Using Module
  • Healthcare Use Case
  • Text Analytics
  • Text Analytics – Lucene Sentiment
  • Entertainment Company Use Case
  • Network Flow Analysis
  • Call Data Record – Network Flow Analysis
  • Telecommunications Company Use Cases
  • Chapter 11: Practice Questions

CHAPTER 12 – Aster App Center

  • Certification Objectives
  • Aster App Center Overview
  • App Center Components
  • Web-based Interface
  • App Builder
  • Data Mapping
  • Data Visualization
  • Application Scheduler
  • User Access Control
  • External Access to Applications
  • App Center Administration
  • App Center Configuration
  • App Center Applications
  • App Center Authentication
  • Chapter 12: Practice Questions

Paperback: 206 pages
Publisher: Cerulium Corporation (2016)
ISBN: 978-0989400572

In Stock: Yes

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

2017-04-03T02:08:52+00:00