Bookstore
  • Cart  |
  • Print  |
  • Feedback  |
Training Console
  |  
800-333-7660

SAS/ACCESS

Title Level Training Formats
SAS/ACCESS Interfaces e-Lectures
This SAS e-Lecture series bundles four lectures that address how to use SAS/ACCESS software to access third-party databases. The four lectures included are

3 Intermediate e-Learning
SAS Certification Review: Base Programming for SAS 9
This course provides a review of the majority of topics in the SAS Base Programming Exam for SAS 9. It addresses the five exam content areas: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, and Handling Errors.

3 Intermediate Classroom Live Web Classroom
Processing Database and Spreadsheet Data with SAS/ACCESS Software
This course teaches you how to read Oracle, DB2, or Microsoft Access or Excel tables into your SAS programs using SAS/ACCESS software.

3 Intermediate Classroom
Introduction to SAS/Access Interface toTeradata
This course teaches you how to read Teradata tables in Teradata using SAS 9.3 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata, query a single Teradata table and mulitple Teradata tables, and you also learn efficiency techniques and options for optimizing data access performance.

3 Intermediate Classroom
SAS SQL 2: Processing Data Efficiently in Real-World Scenarios
In this course, students learn advanced techniques for processing data using Structured Query Language (SQL), explore issues that can degrade SQL query performance, and gain hands-on experience in tuning SQL queries and databases. The course centers on a case study designed to simulate a real-world data environment, including commonly encountered performance-degrading issues. Each week of class focuses on one or more specific performance issues.

Through a virtual learning environment, this unique course combines the flexibility of self-paced learning with instructor guidance and support through a moderated online discussion forum. Each week, students must complete several online study activities by the goal date. Students interact with the instructor and classmates in an online discussion forum to receive additional instruction and help with case study work and exercises.

The course consists of one orientation week followed by five weeks of independent course activities. To achieve maximum benefit from this course, students must dedicate time each week to meet the deadline for submitting the course work. Students should formally set aside five to six hours per week to

  • complete weekly assignments (which might include reading, viewing prerecorded lectures, working on exercises and the case study, and taking quizzes)
  • contribute to the discussion forum by sharing their experience and ideas, asking questions, and responding to postings from the other students in the class.
To receive a certificate of completion and CEUs for this course, students must complete all case study tasks and submit final case study results.

4 Expert Live Web Classroom