Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

SAS(R) SQL Methods and More

  • Tuition USD $375
  • Reviews star_rate star_rate star_rate star_rate star_half 2006 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.

I thought the material was well-paced and organized, and the instructor made himself available for additional questions and context. Provided real-world examples of underlying concepts

It was great content, some additional exam prep focus would have been nice. I believe everyone in the class has the goal of passing some AWS cert exams.

The class should probably be spread out over more sessions. Too much information for 3 days.

Great first experience with ExitCertified. I look forward to many more trainings.

Very good company, excellent course offerings and nice staff both admin and course instructors. Keep it up!

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