overview of SPD Server

SAS data sets used in the SPD Server class

Scalable Performance Data Server Architecture

connecting to SPD Server with a SAS client

investigating a client other than a SAS client

parallel processing

Installation (Self-Study)

installing SPD Server on UNIX

installing SPD Server on Windows

testing and troubleshooting

Configuring the Scalable Performance Data Server

the SPD server parameter file

physical disk setup

the LIBNAME parameter file

troubleshooting

auditing SPD Server

Administration and Maintenance of SPD Server

overview of SPD Server Security

administering SPD Server using the SAS Management Console

administering Access Control Lists using the SAS Management Console

administering SPD Server using the SPD Server Account Manager

administering Access Control Lists using the SPDO procedure

Storing and Loading Data in Scalable Performance Data Server

data storage

partioning data

using the LIBNAME statement

loading data

SPD Server Compression

cluster tables

Creating and Storing Indexes in SPD Server 

SPD index structure

index creation

Using the SQL Procedure

SQL Pass-Through Facility

asynchronous execution

parallel GROUP-BY

SQL Pass-Through Facility and the LIBNAME statement

Optimizing Performance (Best Practices)

overview of techniques

sorting SPD Server tables

subsetting SPD Server tables using WHERE clauses

SQL planner optimizations

using the MINMAXVARLIST= table option

scalability testing

reviewing other optimization techniques

Backup and Restore of SAS SPD Server Data Glossary Summary of SPD Server Options and Macro Variables

LIBNAME statement options

SPD server macro variables

SPD server table options

SPDSSERV.PARM options

write SAS programs