Understanding SAS® In-Database Technologies on the SAS® Viya® Platform
DM299W : DM299A
This course offers a comprehensive introduction to SAS In-Database technologies, focusing on the concepts and architecture that enable efficient, scalable analytics by processing data within the database environment. You'll explore how SAS Compute Server and SAS Cloud Analytic Services (CAS) support in-database execution, how the DATA step can be accelerated, and how large volumes of data can be loaded in parallel using the SAS Data Connect Accelerator. The course also covers the in-database publishing and execution of models and decisions using code or SAS tools like SAS Model Studio, SAS Model Manager, and SAS Intelligent Decisioning. Deployment considerations for external data platforms are also discussed.
Learn How To
Leverage SAS In-Database technologies to optimize performance with SAS Compute Server and CAS.
Accelerate DATA step processing, data loading, and model scoring directly within database environments.
Use SAS tools and code-based approaches to publish and execute models and decisions in-database.
Who Should Attend
Data engineers and architects who want to deepen their understanding of SAS In-Database technologies and learn how to optimize analytics performance in SAS Viya when working with relational databases and modern data platforms
Prerequisites
To get the most out of this course, you should have a solid understanding of:
The fundamentals of SAS Viya.
Key concepts related to data access and data movement.
Basic principles of databases and database management.
Course Outline
Getting Started with SAS In-Database
Introduction to SAS In-Database Technologies
Foundations of In-Database Processing
SAS In-Database Basics with the SAS Compute Server
SAS In-Database Basics with SAS Cloud Analytic Services (CAS)
Accelerating the DATA Step In-Database
In-Database Processing with the DATA Step
Optimizing CAS Data Loading
Massively Parallel Data Loading with SAS Data Connect Accelerator
In-Database Scoring and Model Publishing
Introduction to Scoring Acceleration in SAS Viya
Publishing and Executing Models Using Code
Publishing Models with SAS Model Studio and SAS Model Manager
Publishing Rule Sets and Decisions with SAS Intelligent Decisioning
In-Database Deployment
Deploying SAS In-Database Features to External Data Platforms
Live Class Schedule
Duration: 3.5 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.