SAS(R) SQL Methods and More

  • Tuition USD $325
  • Reviews star_rate star_rate star_rate star_rate star_half 1110 Ratings
  • Course Code SQLMM
  • Duration 4 hours
  • Available Formats Classroom

This class teaches you how to improve the performance of SQL queries, and how to troubleshoot and tune other SAS processes that access relational database tables using SAS/ACCESS interfaces.

Skills Gained

  • discuss formal benchmarking and tuning of production SQL queries
  • recognize correlated subqueries and the alternate techniques that can be used to improve performance
  • use SAS options to evaluate query efficiency
  • understand conditions that can prevent SQL pass-through for execution in the database
  • modify SQL queries to maximize pass-through capabilities.

Who Can Benefit

  • Data analysts and SAS programmers

Prerequisites

  • Before attending this course, you should have at least six months of experience writing SAS programs including PROC SQL code, or have completed the SAS® SQL 1: Essentials course and have used PROC SQL in SAS for at least one month. The course builds on concepts presented in both the SAS® Programming 1: Essentials and SAS® SQL 1: Essentials courses, and is not recommended for beginning SAS software users. Specifically, you should be able to
  • write and submit SAS programs, including PROC SQL steps
  • read and interpret the SAS log
  • diagnose and correct syntax errors
  • access and manipulate data in SAS data libraries.

Course Details

Introduction

  • course overview
  • course logistics

Performance Considerations

  • computer resources and efficiency
  • benchmarking

Implicit versus Explicit Pass-Through

  • implicit pass-through with the LIBNAME statement
  • using data set options with implicit pass-through
  • explicit pass-through in PROC SQL and PROC FedSQL

Perplexing Performance Problems

  • correlated subqueries
  • cross-library operations

Learning More

  • learning more

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

ExitCertified class worked well and provided good starting point for Architecting on AWS

I am very satisfied with the course and teacher(Bill), and with the given option I will play with labs more after the class is over. Thank you

The course was well organized, and the labs and class participation helped a lot.

Great training that provided pro-tips a plenty that were immediately put to use.

I had a good experience with ExitCertified. I got a deeper understanding of AWS and should be able to put it to practice immediately.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward