• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

Introduction to SAS/ACCESS Interface to Teradata

30 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 30-Jun-2024
 Introduction to SAS/ACCESS Interface to Teradata course and certification
318 Learners

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
Using the SQL Pass-Through Facility
  • creating SQL Procedure Pass-Through Queries
  • using SQL Pass-Through Facility
Using the SAS/ACCESS LIBNAME Engine
  • using the LIBNAME statement for Teradata
  • using Data Set options
  • creating views
  • combining tables
  • benefits of the Libname method
Performance Considerations
  • improving performance with the LIBNAME statement
  • taking advantage of Teradata indexes
Base SAS In-Database Processing
  • overview of SAS In-Database technology
  • using Base SAS procedures in Teradata
  • using SAS formats and user-defined formats in Teradata
  •  
----------------------------------------------------------------------------

Didn't find what you are looking for?  Contact Us

course.php