Job Meter = High
Introduction to SAS/ACCESS Interface to Teradata
30 Hours
Online Instructor-led Training
USD 1399 (About this Course
This course teaches you how to read Teradata tables in Teradata using SAS 9.4 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata, query a single Teradata table and multipleTeradata tables, and you also learn efficiency techniques and options for optimizing data access performance.
Learn how to- read Teradata tables using the LIBNAME statement and the SQL Pass-Through Facility
- use options and efficiency techniques for optimizing data access performance
- join data using the SQL procedure and the DATA step
- publish and use SAS formats in Teradata.
Target Audience
SAS programmers that need to access data in Teradata from within SAS
----------------------------------------------------------------------------
Introduction to SAS/ACCESS Interface to Teradata
Course Details & Curriculum
Introduction
- course logistics
- overview of SAS/ACCESS software
- overview of Teradata
- connecting to Teradata
- creating SQL Procedure Pass-Through Queries
- using SQL Pass-Through Facility
- using the LIBNAME statement for Teradata
- using Data Set options
- creating views
- combining tables
- benefits of the Libname method
- improving performance with the LIBNAME statement
- taking advantage of Teradata indexes
- overview of SAS In-Database technology
- using Base SAS procedures in Teradata
- using SAS formats and user-defined formats in Teradata