training@globalonlinetrainings.com

SAS SCALABLE PERFORMANCE DATA SERVER-ONLINE-TRAINING

SAS Scalable Performance Data Server Course Content

Introduction
  • what is the SAS Scalable Performance Data Server?
  • introduction to the workshop scenario
SAS Scalable Performance Data Server Architecture
  • introduction
  • overview of parallel processing
  • connecting to SPD Server from SAS and non-SAS clients
Configuring SAS Scalable Performance Data Server
  • physical disk setup
  • the SPD Server parameter file
  • the LIBNAME parameter file
  • SPD Server auditing and log files
  • troubleshooting tips
Administration and Maintenance of SPD Server Using SAS Management Console
  • overview
  • administering SPD Server users and groups
  • administering SPD Server access control lists
  • using the SPD Server Process Profile Manager
Storing and Loading Data in the SAS Scalable Performance Data Server
  • using the SPD Server LIBNAME engine and the SQL Pass-Through facility
  • loading data
  • partitioning data efficiently
  • SPD Server cluster tables
Creating and Storing Indexes in the SAS Scalable Performance Data Server
  • understanding the importance of indexes
  • creating indexes
Installation of the SAS Scalable Performance Data Server
  • basic installation of SPD Server
  • UNIX topics
  • Windows topics
  • testing and troubleshooting
The SAS Scalable Performance Data Server and SAS Data Integration Studio
  • overview of SAS Data Integration Studio
  • registering SPD Server libraries
  • registering SPD Server tables
  • creating SPD Server tables
  • indexing SPD Server tables
  • adding user code to the job