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/p...
SQL Online Documentation –
https://go.documentation.sas.com/?doc...
SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF
https://www.youtube.com/SASUsers?sub_...
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.htm...
Facebook ► / sassoftware
Twitter ► / sassoftware
LinkedIn ► / sas
Blogs ► https://blogs.sas.com
RSS ►https://www.sas.com/rss