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