Teradata Utilities for V2R6.x Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 394
Course Abstract:	A practical, hands-on course which explains how to submit high volume Teradata jobs, including performing SELECT, INSERT, UPDATE, and DELETE operations in a batch environment using the Teradata Application Utilities for maximum performance and efficiency. This course has been updated to reflect the new features and functions of Teradata V2R6.x.
Audience:	Database Administrators, Data Warehouse Architect (Designer), Data Transformation Specialist, Enterprise or IT Architect, Technical or Data Warehouse Applications Specialist (Applications Developer; Programmer/Analyst), Data Warehouse Technical Specialist. This course helps individuals pursuing the Teradata Certified Application Developer certification prepare for the exam.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Identify and state the purpose of each data load utility (BTEQ, FastLoad, MultiLoad and TPump) and each data unload utility (BTEQ and FastExport) available with the Teradata Database > Code interactive and batch scripts to IMPORT data into the Teradata Database and EXPORT data to the host from the Teradata Database using BTEQ > Identify features, benefits and usage of the FastLoad utility > Identify features, benefits and usage of the MultiLoad utility > Identify features, benefits and usage of the TPump utility > Identify features, benefits and usage of the FastExport utility > Identify features, benefits and usage of the Support Environment commands that are used with the MultiLoad, TPump and FastExport utilities
Course Topics:	Chapter 1 — Introduction An Introduction To The Teradata Utilities Chapter 2 — BTEQ Logging On To BTEQ Using BTEQ To Submit Queries With By Statement With By Statement Cont. Transactions in Teradata Mode Alternative Transactions in Teradata Mode Transactions in ANSI Mode Rollback Advantages to ANSI Mode Creating a Batch Script for BTEQ Running Your Batch Script in BTEQ Results from a BTEQ Batch Script Placing our BTEQ Output to a File Reading Out BTEQ Output from the Text File Using BTEQ Conditional Logic Using BTEQ to Export Data Executing our BTEQ Script to Export Data BTEQ Export Modes Explained BTEQ Export Example Using Record (Data) Mode BTEQ Export Example Using Field (Report) Mode BTEQ Import Example Determining Out Record Lengths BTEQ Commands Sequence Control Commands Chapter 3 — Fastload Fastload Has Two Phases Fastload Commands Fastload Sample Executing A Fastload Script Another Sample Fastload Script Checkpoints Converting Data Types With Fastload When You Cannot Restart Fastload When You Can Restart Fastload Restarting Fastload: A More In-Depth Look Restarting Without Checkpoint Using INMODS with Fastload Chapter 4 — Multiload Error Tables, Work Tables And Log Tables Supported Input Formats Multiload Has Five Import Phases Multiload Commands Parameters For .Begin Import Mload Parameters For .Begin Delete Mload A Simple Multiload Import Script Building Our Multiload Script Executing Multiload Another Simple Multiload Import Script Multiload Import Script Error Treatment Options For The .DML Label Command An Import Script With Error Treatment Options A Import Script That Uses Two Input Data Files Redefining The Input A Script That Uses Redefining The Input Delete Mload Script Using A Hard Coded Value A Delete Mload Script Using A Variable An Upsert Sample Script Troubleshooting Multiload Errors Restarting Multiload Release Mload: When You Don’t Want To Restart Multiload Multiload And INMODs How Multiload Compares With Fastload Chapter 5 — TPump Tpump Has Many Unbelievable Abilities Supported Input Formats Tpump Commands And Parameters Load Parameters In Common With Multiload .Begin Load Parameters Unique To Tpump Tpump Example Creating A Flatfile For Our Tpump Job To Utilize Creating A Tpump Script Executing The Tpump Script Tpump Script With Error Treatment Options A Tpump Script That Uses Two Input Data Files A Tpump Upsert Sample Script Monitoring Tpump Handling Errors In Tpump Using The Error Table Common Error Codes And What They Mean Restarting Tpump Tpump And Multiload Comparision Chart Chapter 6 — Fastexport Fastexport Fundamentals Maximum Of 15 Loads Fastexport Support And Task Commands Support Environment Commands Task Commands Fastexport Supported SQL Commands A Fastexport In Its Simplest Form Sample Fastexport Script Fastexport Modes And Formats A Fastexport Script Using Binary Mode Appendix A: Mainframe Load Utility Examples BTEQ Mainframe Export Example – JCL BTEQ Mainframe Export Script Example – Data Mode BTEQ Mainframe Import Example – JCL BTEQ Mainframe Import Script Example – Data Mode Fastexport Mainframe Example – JCL Fastexport Mainframe Script Example–Record Mode Fastload Mainframe Example – JCL Fastload Mainframe Script Example – Text Mode Multiload Mainframe Example – JCL Multiload Mainframe Script Example – Text Mode Multiload Mainframe Script Example – Continued
Prerequisites:	There are no prerequisites for this course.

Teradata Utilities for V2R6.x Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology