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 Load Utilities

Price
1,530 USD
2 Days
CFLQ-220
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 Load Utilities course is designed to provide students with a deeper knowledge and understanding of the Teradata Load Utilities. Students will learn the Teradata load utilities at the most basic level and going to the most advanced level with many examples.
 

Objectives

Upon completion of the Teradata Load Utilities course, students will be able to:
  • Define Teradata Utilities
  • Collect Statistics
  • Explain Table Create and Data Types
  • Modify Temporary Tables
  • Apply Batch Teradata Query (BTEQ)
  • Demonstrate FastLoad
  • Practice MultiLoad
  • Examine TPump
  • Initiate FastExport
  • Understand Teradata Parallel Transport (TPT)
  • Identify Major Keys to Building TPT Scripts
  • Properly Choose TPT Utility Commands
  • Run a TPT Script
  • Translate TPT Operators and their Equivalent Load Utility
  • Recall Tera-Tom’s Top Tips

Audience

  • Anyone who has a desire to learn the Teradata Load Utilities from beginners to an advanced audience

Prerequisites

    • None

Topics

  • Teradata Utilities Introduction
    • The Teradata Utilities
    • Block Level Utilities
    • Row Level Utilities
    • Fast Path Inserts Using Insert/Select
    • Fast Path Deletes
    • Freespace Percent
    • Referential Integrity and Load Utility Solutions
    • NoPI Tables
    • Why Would a NoPI Table have a Row-ID?
  • Collect Statistics
    • The Teradata Parsing Engine (Optimizer) is Cost Based
    • The Purpose of Collect Statistics
    • When Teradata Collects Statistics, it creates a Histogram
    • The Interval of the Collect Statistics Histogram
    • What to COLLECT STATISTICS On?
    • Why Collect Statistics?
    • How do you know if Statistics were collected on a Table?
    • The Basic Syntax for COLLECT STATISTICS
    • The New Teradata V14 Way to Collect Statistics
    • COLLECT STATISTICS Directly From another Table
    • The Official Syntax for COLLECT STATISTICS
    • How to Recollect STATISTICS on a Table
    • Teradata Always Does a Random AMP Sample
    • Random Sample is Kept in the Table Header in FSG Cache
    • Multiple Random AMP Samplings
    • How a Random AMP gets a Table Row count
    • Random AMP Estimates for NUSI Secondary Indexes
    • USI Random AMP Samples are Not Considered
    • There’s No Random AMP Estimate for Non-Indexed Columns
    • A Summary of the PE Plan if No Statistics Were Collected
    • Stale Statistics Detection and Extrapolation
    • Extrapolation for Future Dates
    • How to Copy a Table with Data and the Statistics
    • How to Copy a Table with NO Data and the Statistics
    • When to COLLECT STATISTICS Using only a SAMPLE
    • Examples of COLLECT STATISTICS Using only a SAMPLE
    • Examples of COLLECT STATISTICS for V14
    • How to Collect Statistics on a PPI Table on the Partition
    • Teradata V12 and V13 Statistics Enhancements
    • Teradata V14 Statistics Enhancements
    • Teradata V14 Summary Statistics
    • Teradata V14 MaxValueLength
    • Teradata V14 MaxIntervals
    • Teradata V14 Sample N Percent
    • Teradata Statistics Wizard
  • Table Create and Data Types
    • Creating a Table with a Unique Primary Index
    • Creating a Table with a Non-Unique Primary Index
    • Creating a Table and forgetting to put in a Primary Index Clause
    • Creating a Set Table
    • Creating a Multiset Table
    • Creating a Set Table that won’t have a Duplicate Row Check
    • Set Table with a Unique Constraint Eliminates the Duplicate Row Check
    • Creating a Table with a Unique Secondary Index
    • Creating a Table with a Multi-Column Primary Index
    • Data Types
    • Major Data Types and the number of Bytes they take up
    • Making an exact copy a Table
    • Making a NOT-So-Exact Copy a Table
    • Copying a Table with a new Default Primary Index
    • Troubleshooting Copying and Changing the Primary Index
    • Copying only specific columns of a table
    • Copying a Table with Data and Keeping the Statistics
    • Copying a Table with No Data and Statistics
    • Copying a table Structure with Zeroed Statistics
    • Creating a Table:
      • Fallback
      • No Fallback
      • Before Journal
      • Dual Before Journal
      • After Journal
      • Dual After Journal
      • Journal Keyword Alone
    • Why use a Before Journal?
    • Why Use an After Journal?
    • Creating a Table with Customization of the Data Block Size
    • Creating a Table with Customization on FREESPACE Percent
    • Creating a QUEUE Table
    • Example of how a Queue Table Works
    • The Concept behind Partitioning a Table
    • Creating a PPI Table with Simple Partitioning
    • Creating a PPI Table with RANGE_N Partitioning per Month
    • A Visual of One Year of Data with Range_N per Month
    • An SQL Example explaining Range_N Partitioning per Month
    • Creating a PPI Table with RANGE_N Partitioning per Day/Week
    • Creating a PPI Table with CASE_N
    • NO CASE and UNKNOWN Partitions Together
    • Combining Older Data and Newer Data in PPI
    • Multi-Level Partitioning Combining Range_N and Case_N
    • NON-Unique Primary Indexes (NUPI) in PPI
    • PPI Table with a Unique Primary Index (UPI)
    • Tricks for Non-Unique Primary Indexes (NUPI)
    • Character Based PPI for RANGE_N and CASE_N
    • Dates and Character-Based Multi-Level PPI
    • TIMESTAMP Partitioning
    • Using CURRENT_DATE to define a PPI
    • ALTER to CURRENT_DATE the next year
    • Altering a PPI Table to Add or Drop Partitions
    • Deleting a Partition and saving its contents
    • Using the PARTITION Keyword in your SQL
    • SQL for RANGE_N and CASE_N
  • Temporary Tables
    • There are three types of Temporary Tables
    • CREATING A Derived Table
    • Naming the Derived Table
    • Aliasing the Column Names in the Derived Table
    • Most Derived Tables Are Used To Join To Other Tables
    • Multiple Ways to Alias the Columns in a Derived Table
    • Our Join Example with a Different Column Aliasing Style
    • Column Aliasing Can Default for Normal Columns
    • CREATING A Derived Table using the WITH Command
    • Our Join Example With the WITH Syntax
    • The Same Derived Query shown Three Different Ways
    • Clever Tricks on Aliasing Columns in a Derived Table
    • A Derived Table lives only for the lifetime of a single query
    • An Example of Two Derived Tables in a Single Query
    • WITH RECURSIVE Derived Table
    • Defining the WITH Recursive Derived Table
    • Looping
    • Creating a Volatile Table
    • You Populate a Volatile Table with an INSERT/SELECT
    • The Three Steps to Use a Volatile Table
    • Why Would You Use the ON COMMIT DELETE ROWS?
    • The HELP Volatile Table Command Shows your Volatiles
    • A Volatile Table with a Primary Index
    • The Joining of Two Tables Using a Volatile Table
    • The New Teradata V14 Way to Collect Statistics
    • Four Examples of Creating a Volatile Table Quickly
    • Four Advanced Examples of Creating a Volatile Table Quickly
    • Creating Partitioned Primary Index (PPI) Volatile Tables
    • Using a Volatile Table to Get Rid of Duplicate Rows
    • Using a Simple Global Temporary Table
    • Two Brilliant Techniques for Global Temporary Tables
    • The Joining of Two Tables Using a Global Temporary Table
    • CREATING A Global Temporary Table
  • BTEQ – Batch Teradata Query
    • BTEQ – Batch Teradata Query Tool
    • How to Logon to BTEQ in Interactive Mode
    • Running Queries in BTEQ in Interactive Mode
    • BTEQ Commands vs BTEQ SQL Statements
    • WITH BY Command for Subtotals
    • WITH Command for a Grand Total
    • WITH and WITH BY Together for Subtotals and Grand Totals
    • How to Logon to BTEQ in a SCRIPT
    • Running Queries in BTEQ through a Batch Script
    • Running a BTEQ Batch Script through the Command Prompt
    • Running a BTEQ Batch Script through the Run Command
    • Using Nexus to Build Your BTEQ Scripts
    • Using BTEQ Scripts to IMPORT Data
    • What Keywords Mean in a BTEQ Script
    • Creating a BTEQ IMPORT for a Comma Separated Value File
    • Four Great Examples/Ways to Run a Teradata BTEQ Script
    • BTEQ Export – Four types of Export Variations
    • Creating a BTEQ Export Script in Record Mode
    • The Appearance of Record Mode vs Report Mode Data
    • Using Report Mode to Create a Comma Separated Report
    • Creating a BTEQ IMPORT for a Comma Separated Value File
    • Using Multiple Sessions in BTEQ
    • BTEQ Fast Path Inserts
    • BTEQ Can Use Conditional Logic
    • Using a BTEQ Export and Setting a Limit in a UNIX System
  • FastLoad
    • FastLoad
    • Block Level Utility Limits
    • FastLoad Pahse 1 & 2
    • Executing the FastLoad Script
    • The Nexus SmartScript FastLoad Builder
    • Create and Execute Your FastLoad Scripts with Nexus
    • FastLoad to a NoPI Table
    • FastLoad and CHECKPOINT
    • Loading Multiple Input Files with FastLoad
    • Valid Data Types That Can Be Used in a FastLoad
    • A FastLoad that Converts Data Types
    • A FastLoad that Uses the NULLIF Statement
    • FastLoad and Referential Integrity Solutions
    • The Output Report from FastLoad
    • Recovering a FastLoad that has failed
    • A BTEQ Export and then a FastLoad
    • A FastExport and then a FastLoad Needs Indicators
  • MultiLoad
    • MultiLoad
    • Block Level Utility Limits
    • MultiLoad has Five Phases
    • MultiLoad has IMPORT and DELETE Tasks
    • A Sample MultiLoad Script Created by Nexus SmartScript
    • Referential Integrity and Load Utility Solutions
    • MultiLoad That Inserts and Updates from Two Different Files
    • A MultiLoad Example That UPSERTs
    • A MultiLoad DELETE MODE Example
    • MultiLoad DELETE Rules
    • Five Formats of MultiLoad Files
    • A NoPI Table Does Not Work with MultiLoad
    • Executing a MultiLoad Script
    • The Output Report from MultiLoad
    • Host Utility Locks (HUT Locks)
    • Troubleshooting MultiLoad
  • TPump
    • TPump
    • Limitations of TPump
    • A Sample TPump Script Created by Nexus SmartScript
    • Executing a TPump Script
    • TPump Begin Load Statement Options
    • Five Formats of TPump Files
    • TPump Script with Error Treatment Options
    • TPump UPSERT Script
    • The Output Report from TPump
  • FastExport
    • FastExport
    • New Rules for Block Utilities
    • A Sample FastExport Script Created by Nexus SmartScript
    • FastExport by Default places Null Indicators in Output
    • A Sample FastExport Script Created by Nexus SmartScript
    • No Spool Options with FastExport
    • FastExport with No Spool
    • FastExport that Joins Two Tables
    • FastExport Modes
    • How to Eliminate Indicators in your FastExport Script
    • Executing a FastExport Script
  • Teradata Parallel Transport (TPT)
    • What is TPT?
    • TPT Producers Create Streams and Consumers Write Them
    • The Four Major Operators of TPT
    • TPT Operators and their Equivalent Load Utility
    • How to Run a TPT Script
    • Six Syntax Rules when Creating TPT Scripts
    • TPT Scripts are divided into two major sections
    • Three Required Define Statements in the Declarative Section
    • The Major Keys to Building TPT Scripts
    • Schemas
    • The DDL Operator
    • The SQL Selector Operator
    • SQL_Selector Operator Export to Delimited File
    • SQL Selector Example
    • The Export Operator
    • Export Operator to Formatted Flat File Example
    • Deferred Schema
    • Export a Table to a Binary Flat File
    • The Load Operator
    • Load from Binary File
    • Data Connectors
    • Load Table from Flat File
    • Update Operator
    • Teradata V14.10 Extended MultiLoad Protocol (MLOADX)
    • Update Operator Example
    • Stream Operator
    • Stream Operator Example
    • Easy Loader Example (tdload)
    • TPT Utility Commands
    • OS Command Operator
    • Job Variables Example
    • Include Statement
    • Operator Templates
    • Using Operator Templates
    • Operator Template Example
    • Moving Data from Netezza to Teradata
  • Top SQL Commands Cheat Sheet
    • SELECT All Columns from a Table and Sort
    • Select Specific Columns and Limiting the Rows
    • Changing your Default Database
    • Keywords that describe you
    • Select TOP Rows in a Rank Order
    • A Sample number of rows
    • Getting a Sample Percentage of rows
    • Find Information about a Database/Table
    • Using Aggregates
    • Performing a Join
    • Using Date, Time and Timestamp
    • Using Date Functions
    • Using the System Calendar
    • Formatting Data
    • Using Rank
    • Using a Derived Table
    • Using a Subquery
    • Correlated Subquery
    • Using Substring
    • CASE Statement
    • Using an Access Lock in your SQL
    • Collect Statistics
    • CREATING a Volatile Tables
    • Finding the Typical Rows per Value for specific column
    • Finding out how much Space you have
    • How much Space you have Per AMP
    • Finding your Space
    • Finding Space Skew in Tables in a Database
    • Finding the Number of rows per AMP for a Column
    • Finding Account Information
    • Ordered Analytics
  • 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

    Cybersecurity Awareness Month 2024

    Get Ahead of Online Threats with 20% Off Security Training.

    Use SECURITY20 at checkout. Valid through October 31, 2024.

    Browse Training Courses

    IBM TechXchange Conference 2024

    October 21-24 | Mandalay Bay, Las Vegas

    Join us for four action-packed days to immerse yourself in innovation and learning. Gain practical skills in Generative AI, harness IBM technology, and engage with tech industry experts.

    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??

    Exam Terms & Conditions

    ??exam-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

    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.

    If you would like to request a quote for 5 or more students, please contact CustomerService@learnquest.com to be assigned an account representative.

    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.