Close
Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
« Important Announcement » Contact Us 877-206-0106 | USA Flag
Close
Close
Close
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

Close
photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Teradata Basics

Price
765 USD
1 Day
CFLQ-100
Classroom Training, Online Training
Teradata

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.
 

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

    Sorry, there are no public classes currently scheduled in your country.

    Please complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

View Global Schedule

Course Description

Overview

This Teradata Basics course is designed to illustrate the fundamentals of the Teradata database. Students learn about parallel processing, AMPs and PEPs, how Teradata lays out data evenly, Primary Index use, hashing, Perm and Spool Space, and protection features.

This course can be taught using Version 12, 13, or 14. Please inform your sales representative of which version you are currently using.
 

Objectives

Upon completion of the Teradata Basics course, students will be able to:
  • Describe the Teradata architecture
  • Explain data warehousing and data distribution
  • Calculate Teradata space
  • Apply data protection including Transient Journal, Fallback and RAID
  • Explain V2R5 partitioning

Audience

  • IT Professionals

Prerequisites

    • None

Topics

  • The Teradata Architecture
    • The Teradata Architecture
    • The Parsing Engine
    • The AMPs
    • Born to be parallel
    • The BYNET
    • Watch the Tera-Tom Video on Architecture
    • Collecting Statistics
    • Parsing Engine uses Statistics for the Plan
    • Columns and Indexes to Collect Statistics On
    • A Scalable Architecture
    • VProcs
    • Nodes and MPP
    • Watch the Tera-Tom Video on How AMPS store and process rows in Parallel
  • Logical Modeling
    • Logical Modeling – Primary and Foreign Keys
    • A Normalized Data Warehouse
    • Normalization
    • Dimensional Modeling also called Star Schema
  • The Primary Index
    • Physical Modeling - The Primary Index
    • Two Types of Primary Indexes (UPI or NUPI)
    • Unique Primary Index (UPI)
    • Non-Unique Primary Index (NUPI)
    • Multi-Column Primary Indexes
    • When do you define the Primary Index?
    • Watch the Tera-Tom Video on Primary Indexes
  • How Teradata Distributes and Retrieves Data
    • How Teradata Distributes and Retrieves Rows
    • Hashing the Primary Index Value
    • The Hash Map
    • Laying a Row onto the Proper AMP
    • Retrieving a Row by way of the Primary Index
    • Placing Non-Unique Primary Indexes (NUPI) Rows
    • Non-Unique Primary Indexes Continued
    • Placing (NUPI) Rows Continued
    • Retrieving (NUPI) Rows
    • Even Distribution with an UPI
    • Uneven Distribution with a NUPI
    • Unacceptable Distribution with a NUPI
    • Big Trouble – A Picture of a Full Table Scan
    • A Visual for Data Layout
    • Watch the Tera-Tom Video on Data Placement
    • Bonus Video - Tera-Tom Video on the Row-ID
    • Test your Teradata Primary Index Knowledge
  • Secondary Indexes
    • Secondary Indexes
    • The Secondary Index Subtable
    • USI – Always a Two-AMP Operation
    • USI Summary
    • Watch the Tera-Tom Video on Unique Secondary Indexes (USI)
    • NUSI Subtable is AMP-Local
    • NUSI Recap
    • Secondary Index Summary
    • Watch the Tera-Tom Video on Non-Unique Secondary Indexes (NUSI)
  • Partitioned Tables
    • A Table used for our Partitioning Example
    • Range Queries
    • Why we had to perform a Full Table Scan
    • A Partitioned Table
    • A Partitioned Table
    • One Year of Orders Partitioned
    • Fundamentals of Partitioning
    • Add the Partition to the Row-ID for the Row Key
    • Multi-Level Partitioning
    • Partitioning Rules
    • Watch the Tera-Tom Video on Partitioning
  • Space
    • The most Powerful USER
    • DBC owns all the Disk Space
    • DBC Example of 1000 GBs
    • DBC will first CREATE a USER or a DATABASE
    • Teradata is Hierarchical
    • Only two Objects can Receive PERM Space
    • PERM, SPOOL and TEMP Space
    • Spool is like a Speed Limit
    • All Space is calculated on a Per AMP Basis
    • Watch the Tera-Tom Video on Space
  • Join Indexes
    • Introduction to a Join Index
    • Join Index Fundamentals
    • A Multi-Table Join Index Example
    • Multi-Table Join Index Picture
    • Single-Table Join Index
    • Aggregate Join Index
    • Join Index Details to Remember
    • Watch the Tera-Tom Video on the Parody Teradata Query Search-Off
  • Data Protection
    • Data Protection
    • Transaction Concept
    • Transient Journal
    • RAID 1 - Mirroring
    • Cliques
    • VProcs Migrate when a Node Fails
    • Cliques – An 8-Node Example
    • Hot Standby Nodes
    • Hot Standby Nodes in Action
    • FALLBACK Protection
    • How Fallback Works
    • Fallback Clusters Exercise
    • Fallback Clusters
    • The Six Rules of Fallback
    • Down AMP Recovery Journal (DARJ)
    • Permanent Journal
    • Permanent Journal Rules
  • Locking
    • The Four Locks of Teradata
    • Teradata has 3 levels of Locking
    • Locking Modifiers – The Access Lock
    • Locks and their compatibility
  • The Steps to Active Data Warehousing
    • The Active Data Warehouse
    • Operational Data Stores Vs the Data Warehouse
    • How is all Started - OLTP, DSS, OLCP, and OLAP
    • Data Marts
    • Distributed Data Warehousing – The Future
    • Watch the Tera-Tom Video on the Nexus Nerds
    • Centralized Data Warehousing
  • Teradata Hardware, Software and Security
    • Teradata V12 Platforms
    • Teradata V12 Operating Systems
    • A Typical Cabinet and Node
    • LAN Connection for Network Attached Clients
    • Mainframe Connection to Teradata
    • LDAP
    • Access Rights
    • Automatic, Implicit, and Explicit Rights
    • Roles
    • Profiles
    • Views
    • Macros
    • Stored Procedures
    • User Defined Functions (UDF)
  • Teradata Tools
    • Teradata Analyst Pack
    • Teradata Visual Explain Utility
    • TSET
    • Index Wizard
    • Statistics Wizard
    • Three Levels of Workload Management
    • Teradata Dynamic Workload Manager
    • Priority Scheduler Fundamentals
    • Priority Scheduler with Additional Partitions
    • Database Query Log (DBQL)
    • Teradata Workload Analyzer
    • Performance Monitor
  • Load Utilities
    • Teradata Load Utilities
    • Teradata Load Utilities Continued
    • BTEQ
    • The Four Types of BTEQ Exports
    • BTEQ IMPORT Script
    • FastLoad
    • FastLoad has Two Phases
    • A Sample FastLoad Script
    • The SmartScript FastLoad Builder
    • MultiLoad
    • A Sample MultiLoad Script
    • The SmartScript MultiLoad Builder
    • TPump
    • Limitations of TPump
    • A Sample TPump Script
    • The SmartScript TPump Builder
    • FastExport
    • Teradata Parallel Transport
    • TPT Operators and their Functions
    • TPT Operator Types
    • TPT Operators and their Equivalent Load Utility
    • How to Run a TPT Script
    2023 Top 20 Training Industry Company - IT Training

    Need Help?

    Call us at 877-206-0106 or e-mail us at info@learnquest.com

    Personalized Solutions

    Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

    Contact Us

    Need Help?

    Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

    Talk to us

    20% Off All Project Management Training Courses

    Maximize project efficiency and profitability across the board.

    PROMO CODE: PROJECT20
    VALID THROUGH JUNE 30, 2024

    20% Off All AI Training Courses

    IBM TechXchange Conference 2024

    October 21-24 | Mandalay Bay, Las Vegas

    Save $127 with Code: TECHXCHANGE10

    Offer Expires June 30, 2024

    Self-Paced Training Info

    Learn at your own pace with anytime, anywhere training

    • Same in-demand topics as instructor-led public and private classes.
    • Standalone learning or supplemental reinforcement.
    • e-Learning content varies by course and technology.
    • View the Self-Paced version of this outline and what is included in the SPVC course.
    • Learn more about e-Learning

    Course Added To Shopping Cart

    bla

    bla

    bla

    bla

    bla

    bla

    Self-Paced Training Terms & Conditions

    ??spvc-wbt-warning??
    ??group-training-form-area??
    ??how-can-we-help-you-area??
    ??personalized-form-area??
    ??request-quote-area??

    Sorry, there are no classes that meet your criteria.

    Please contact us to schedule a class.
    Close

    self-paced
    STOP! Before You Leave

    Save 0% on this course!

    Take advantage of our online-only offer & save 0% on any course !

    Promo Code skip0 will be applied to your registration

    Close
    Nothing yet
    here's the message from the cart

    To view the cart, you can click "View Cart" on the right side of the heading on each page
    Add to cart clicker.

    Purchase Information

    ??elearning-coursenumber?? ??coursename??
    View Cart

    Need more Information?

    Speak with our training specialists to continue your learning journey.

     

    Delivery Formats

    Close

    By submitting this form, I agree to LearnQuest's Terms and Conditions

    heres the new schedule
    This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
    Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.