Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

SAS(R) SQL Methods and More

  • Tuition USD $325
  • Reviews star_rate star_rate star_rate star_rate star_half 347 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(R) 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(R) Programming I: Essentials and SAS(R) 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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

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

Lunchtime?

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.

Had great paid experiences, the free experience was not a waste of time, it provided the overview AWS that I needed to get started.

Attended a Power BI class in McLean with this company. The instructor (Mike Staves) was very good and attentive to the groups' learning needs. The facility was very good and the staff was more than accommodating.

Class material was clear and well communicated. Virtual setup was easy. Plenty of material was provided ahead of time. Sean was a fantastic instructor.

The instructor was very good. He had a terrific temperament and never seemed to get tired. He was very patient with some of the participants and their lack of experience.

Very good platform iMVP. I did Architecting on AWS from home and the quality of the material and the labs. Very committed and experienced instructor too.

Didin't give 5 stars because I found the material was too much for 3 days. Too many new concepts, products and strategies to learn in such a little time. I'll have to check all the material and test everything again to be sure all this knowledge is not lost!

0 options found

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