2023 2024 Student Forum > Management Forum > Main Forum

 
  #1  
5th January 2016, 12:11 PM
Unregistered
Guest
 
SAS SQL course

I am interested in doing the SAS SQL training course from the Support SAS so can you please give me the course outline of it?
  #2  
5th January 2016, 12:14 PM
Super Moderator
 
Join Date: May 2012
Re: SAS SQL course

Support SAS is providing software solutions since 1976, it provides SAS SQL training course, here are the details of it

The SAS e-Lecture series bundles four lectures that build upon the skills that you developed in the SAS SQL 1: Essentials course.

The four lectures included in the bundle are
Indexing SAS Data Sets for WHERE Optimization 1: Index Qualification and Data Profiling

Indexing SAS Data Sets for WHERE Optimization 2: Index Application and Performance

Beyond SQL Essentials: The Need for Speed when Accessing SAS Data

Beyond SQL Essentials: The Need for Speed when Accessing RDBMS Data.


Duration
2.25 hours

Prerequisites
Before listening to these lectures, you should have completed the SAS Programming 1: Essentials course and the SAS SQL 1: Essentials course or have equivalent knowledge.

Completion of the SAS Programming 2: Data Manipulation Techniques course is helpful but not required.

Course Outline

Indexing SAS Data Sets for WHERE Optimization 1: Index Qualification and Data Profiling
using the CONTENTS procedure to retrieve data set information
considerations for indexing
distribution of data values

Indexing SAS Data Sets for WHERE Optimization 2: Index Application and Performance
creating test data tables and verifying size and uniformity
creating indexes on the test data tables
benchmarking the performance of filtering the test tables
comparing and analyzing benchmark results

Beyond SQL Essentials: The Need for Speed when Accessing SAS Data
review of the SAS/ACCESS LIBNAME statement and performance measures
optimizing queries

Beyond SQL Essentials: The Need for Speed when Accessing RDBMS Data
review of the SAS/ACCESS LIBNAME statement and performance measures
optimizing SQL pass-through queries

Contact Details:
SAS UK HQ
Wittington House
Henley Road, Medmenham
Marlow, Buckinghamshire
SL7 2EB
Phone: 01628 486 933


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 01:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4