Choose your language:

France
Germany
Hong Kong

India
Ireland
Japan
Malaysia
Netherlands
New Zealand

Singapore

Sweden
United Kingdom
United States
Course Code

RT683

Duration

3 Days

Some experience with Relational Databases and SQL is required.
This course is for Database Developers who want a fast-paced, intense introduction to Teradata programming. We will cover the parallel architecture of Teradata and virtual processing environment. The participants will create various table types and learn when to use each. They will also create procedural code in macros, user defined functions and stored procedures. They will understand and create BEFORE and AFTER triggers. We will investigate the various transaction control techniques and learn how to use them. Finally the participants will export and import data.
This course is designed for individuals who are Database Developers.

Upon completion of this course, participants will be able to:

  • Understand Teradata environment, terms and architecture 
  • Use Teradata query tools 
  • Use Teradata SQL, functions and macros 
  • Create permanent, temporary, volatile and queue tables 
  • Explore system functions 
  • Understand and use the Data Dictionary 
  • Create macros, UDF, stored procedures and triggers 
  • Understand ANSI and Teradata transactions 
  • Using Export and Import Utilities
Overview of Teradata Database
History
Version 14
Active Warehouse
Architecture
Virtual Processors
Unified Data Architecture
Aster Data
ANSI & Teradata SQL
Integrated Analytics
Warehouse Miner
Platform Family
Databases
Users
Default Database
Virtual Storage
Resources
Lab

Query Tools
Heterogeneous Client Access
Network Attachment Methods
Basic Teradata Query (BTEQ)
BTEQWin
SQL Assistant
Teradata Studio Express (SQL Assistant Java Edition)
Interactive Teradata Query (ITEQ)
Teradata Manager
ViewPoint
Other Tools
HELP SESSION
Lab

SQL Select
Data Manipulation Language (DML)
Syntax Diagrams
Select Syntax
TOP
Subqueries
Derived Tables
Recursive Query
Intersect
Except/Minus
Joins
Niladic Functions
Case Expressions
Data Dictionary
Lab

DB2 SQL Modifications
Insert
Update
Update Joins
Delete
Delete Joins
Merge
Copy Table
XML Services Functions
Lab

Tables
Table Types
Teradata Database data types
ANSI-compliant data types
Create Table Syntax
Identity Column
Compression
Columnar Storage
HELP TABLE
SHOW TABLE
Alter Table
Global Temporary Table
Volatile Table
Queue Table
SELECT AND CONSUME
Temporal Tables
Lab

Constraints
Data Integrity
Defaults
Primary Keys
Unique Keys
Foreign Keys
Reference Constraints
Check Constraints
Lab

Macros
Macro Use
Create Macro
Execute Macro
Parameters
Replace Macro
Information
Lab

User Defined Functions
Creating Functions
Parameters
Scaler Functions
Overloading Functions
Table Functions
Drop Function
Function Information
Dependencies
Lab

System Functions
Types
Aggregate Functions
Grouping Sets
Rollup, Cube Functions
String Functions
Date, Time Functions
Periods
Business Calendars
Math Functions
Convert Functions
Ordered Analytical Functions
Regular Expression Functions
Hash-Related Functions
Miscellaneous Functions

Stored Procedures
Creating Stored Procedures
Parameters
Parameter Defaults
Drop Procedure
Procedure Information
Labels
Variables
IF
FOR
WHILE
Signal
Get Diagnostics
FOR DO
Looping
Return
Cursors
Positioned Changes
Returning Result Sets
Lab

Advanced SP Techniques
SQLSTATE and SQLCODE
Condition Handlers
Condition Names
Resignal
Nested Procedures
Dynamic SQL
Receiving Result Sets
Recompile
Lab

Transactions
Session Modes
ANSI Transactions
Teradata Transactions
BEGIN TRANSACTION
Write Ahead Logging
Transaction Control
Managing Transactions
Transaction Logging
Lab

Triggers
Defining Triggers
Creating Triggers
Transition Variables
Transition Tables
BEFORE trigger
AFTER trigger
Examples
Lab

Export, Import and Load
FastExport
File Formats
Modifiers
FastLoad
Options
MultiLoad
Parallel Data Pump
Data Mover
Lab

Appendix
A1. Glossary
A2. Sample Database ER Diagram
Send Us a Message
First Name
*
Last Name
*
Company
*
Email
*
Address Line 1
*
Address Line 2
City
*
*
Zip Code
Telephone
*
*
Choose one
*
Comments