Course Description
This course provides a detailed overview of the features, functions and benefits of the Teradata database. Among the topics taught are data distribution, access, storage, and data protection methods. The suite of load, access, and management utilities and tools are also covered, as well as basic Teradata terminology and acronyms.
Prerequisites
None
Target Audience
This course is designed for:
- Database Administrators
- Architects/Designers
- Application Developers
- Data Analysts
Learning Objectives
Upon accomplishment of this course, participants will be able to:
- Describe the purpose and function of the Teradata Database
- Understand relational table structures using Primary Keys and Foreign Keys
- List the principal components of the Teradata Database and describe their functions
- Understand the hierarchy of database objects and space management
- Describe the function of the Primary Index and the Secondary Index
- Know how data distribution and data access mechanics work in the Teradata Database
- Describe the Teradata Database features that provide fault tolerance
- Understand the use and application of the Teradata Tools and Utilities
Content Outline
- Course Objectives
- Course Description
- Course Outline
- What is the Teradata Database?
- Teradata Parallel Architecture
- Relational Database Advantages
- Teradata Database Manageability
- Teradata Database Features
- Review Questions
- What is a Database?
- Logical/Relational Modeling
- Relational Databases
- Normalized Data Model vs. Star Schema Model
- Primary Keys
- Foreign Keys
- Answering Questions with a Relational Database
- Relational Advantages
- Review Questions
- Evolution of Data Processing
- Row vs. Set Processing
- Response Time vs. Throughput
- The Advantage of Using Detail Data
- Data Warehouse Usage Evolution
- Active Enterprise Intelligence
- Active Data Warehousing
- The Data Warehouse
- Data Marts
- Review Questions
- Major Components of the Teradata Database
- The Parsing Engine (PE)
- The BYNET
- The Access Module Processor (AMP)
- What is a Node?
- Teradata Virtual Storage
- Teradata Virtual Storage Concepts
- Storage Performance vs. Data Temperature
- Teradata with Hybrid Storage
- Multi-Temperature Data Example
- Teradata Compression Comparison
- Layers of the Data Warehouse Architecture
- Linear Growth and Expandability
- Review Questions
- Databases and Users Defined
- Teradata Database Objects
- Teradata Database Space
- Space Management
- Database Security
- Review Questions
- How Does the Teradata Database Distribute Rows?
- Primary Key (PK) vs. Primary Index (PI)
- Primary Indexes
- Defining the Primary Index
- Row Distribution via Hashing
- UPI Row Distribution
- Unique Primary Index (UPI) Access
- NUPI Row Distribution
- Non-Unique Primary Index (NUPI) Access
- Highly Non-Unique NUPI Row Distribution
- Partitioned Primary Index (PPI)
- Multi-Level Partitioned Primary Index (MLPPI)
- What is a NoPI Table?
- Teradata Columnar
- Teradata Columnar Benefits
- Review Questions
- Secondary Indexes
- Defining a Secondary Index
- Join Indexes
- Other Types of Secondary Indexes
- Primary Index vs. Secondary Index
- Full-Table Scans
- Review Questions
- Locks
- Transient Journal
- Fallback
- Down AMP Recovery Journal
- RAID Protection
- Cliques
- Hot Standby Nodes (HSN)
- Archiving and Recovering Data
- Review Questions
- Teradata Tools and Utilities Overview
- Query Tools
- BTEQ
- Teradata SQL Assistant
- Teradata Studio
- Load and Unload Utilities
- FastLoad Utility
- MultiLoad Utility
- FastExport Utility
- TPump Utility
- Teradata Parallel Transporter
- Teradata Parallel Transporter Operators
- System Management Components
- Workload Management Overview
- Workload Management Components
- Workload Management Architecture
- Viewpoint Workload Management Portlets Overview
- What is the Teradata Viewpoint?
- Viewpoint Data Collection Service
- Viewpoint Architecture
- Viewpoint Portal and Portlets
- Teradata Workload Analyzer
- Teradata Unity
- Teradata Multi-Systems Manager (TMSM)
- Management and Monitoring Architecture
- Teradata Data Mover
- Analyst Tools
- Teradata Visual Explain
- Teradata System Emulation Tool
- Review Questions
FAQs
To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.
We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.
Participants can easily access these labs over Cloud with the help of remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them in real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.