SAS Tutorial | SAS SQL Methods and More

This SAS tutorial will show how to build on your SQL knowledge as you learn to evaluate and improve the performance of your SQL queries. Watch as John McCall discusses formal benchmarking and tuning of production SQL queries and uses SAS options to evaluate query efficiency. Access the exercises in our Virtual Learning Environment link below. You’ll be prompted to log into your SAS profile or create one. Content Outline 0:00:00 – Welcome 0:02:20 – Overview of SAS SQL course topics 0:03:51 – SAS/ACCESS Software overview 0:09:10 – Performance Considerations: Efficiency and Benchmarking 0:34:35 – Implicit versus Explicit Pass-Through SQL Queries 1:12:31 – Correlated Subqueries and Cross-Library Operations 1:42:10 – Learn more about SAS customer support Learn more about SAS Software SAS Programming path – https://support.sas.com/training/us/paths/prg.html SQL Online Documentation – https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=en SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_confirmation=1 ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change. CONNECT WITH SAS SAS ► https://www.sas.com SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690 SAS Analytics Explorers ► https://explorers.sas.com/en/home.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690 Facebook ► https://www.facebook.com/SASsoftware Twitter ► https://www.twitter.com/SASsoftware LinkedIn ► https://www.linkedin.com/company/sas Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss