#1
5th January 2016, 12:11 PM
| |||
| |||
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
| |||
| |||
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 |