This course provides an in-depth, hands-on experience with SAS In-Database on SAS Viya. It introduces in-database basic concepts like running SQL queries in a database from SAS as well as advanced mechanisms like running SAS decisions or SAS scoring models inside a database. You will learn how to use database data efficiently from SAS. Practical hands-on on Azure with Teradata, Databricks and Azure Synapse are included.
Learn How To
Use SAS In-Database Technologies to;Maximize the usage of a database before processing data in SAS Run SAS Data Quality tasks in a database Accelerate the loading of database data in CAS Publish and run SAS Scoring Models, Rule Sets and Decisions in a database
Who Should Attend
Data Engineers who need to optimize data movement between SAS and a database.
Prerequisites
Before attending this course, you should be familiar with;SAS Viya fundamentals SAS coding techniques SAS Studio Data access concepts and data movement concerns Database fundamentals;Familiarity with SAS Model Studio / SAS Model Manager / SAS Intelligent Decisioning is also helpful.
Course Outline
SAS In-DatabaseIntroductionSAS In-Database BasicsFrom a SAS Compute Server From CASSAS Data Quality AcceleratorUsageSAS In-Database DATA Step ProcessingUsageSAS Data Connect AcceleratorUsageSAS Scoring AcceleratorIntroduction From SAS Code From SAS Model Studio / SAS Model Manager From SAS Intelligent DecisioningSAS In-Database DeploymentGeneral Principles Teradata Specifics Databricks Specifics Azure Synapse SpecificsFast TracksScoring Accelerator for Databricks Scoring Accelerator for Azure Synapse