SAS/ACCESS Interface to Teradata Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

This SAS/ACCESS Interface to Teradata training course teaches to read Teradata tables in Teradata using SAS SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata, query a single Teradata table and multiple Teradata tables, and you also learn efficiency techniques and options for optimizing data access performance.

By attending SAS/ACCESS Interface to Teradata workshop, delegates will learn 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

Comfortable programming in SAS and Structured Query Language (SQL).
A working knowledge of Teradata would be helpful.

The SAS/ACCESS Interface to Teradata class is ideal for:

SAS programmers who need to access data in Teradata from within SAS

Introduction

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

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions