SAS Data Engineering Learning Subscription

These data engineering courses are designed for programmers, data engineers, data integration developers, and data quality stewards using SAS for their data engineering solution.
ENROLL FREE
7-Day Trial
Purchase this digital subscription to:
Unlock digital courses
Unlimited access to digital courses and books in this subscription.
Prepare for certification
Unlimited access to certification preparation materials.
Shareable digital badges
Earn a digital badge for each completed course.
Hands-on learning and practice
Get Full access to SAS software to practice as you learn.

About this Subscription




Gain expertise in applying SAS methods to design and implement fit-for-purpose data pipelines to support business applications and analytic solutions. Data is sourced from a variety of systems in many different formats. Data engineers need to connect to these source systems, efficiently extract the relevant data, and then cleanse and transform the data and load that data into target systems.

Learn how to:
  • Understand the applications on the SAS Viya platform and how each is used in the phases of the SAS Analytics Life Cycle: Data, Discovery, Deployment and Orchestration.
  • Access data from a variety of systems and formats and transform it for business or analytical objectives.
  • Modify existing Base SAS programs to execute on the platform.
  • Tune SAS programs accessing relational database tables for optimized execution.
  • Profile data to understand the structure and content and identify data quality issues.
  • Apply data quality algorithms to standardize data values and identify duplicate entities.
  • Create SAS Studio flows to design data engineering pipelines to access, transform, and load tables.
  • Design SAS Studio flow custom steps to execute customized programs.
  • Schedule and manage jobs to execute SAS Studio flows.
  • Process, transform, and publish event stream data in real time.
  • Use SAS software with AWS cloud services.


    • No SAS experience or programming experience is required, although you should have some computer experience.


    Courses Included in Subscription

    Getting Started

    1

    • COURSE

      SAS Viya Data Engineering: Getting Started
      SHOW MORE ﹀
      Get started using SAS Data Engineering by spending a little time each day learning a new aspect of the offering. Over the course of a few weeks, you'll get a good idea of the skills you may need to leverage SAS' data engineering capabilities. At the end of your journey be sure to explore formal enablement opportunities to continue your quest in becoming a SAS Data Engineer.

    SAS Viya Overview

    2

    • COURSE

      SAS® Viya® Overview
      SHOW MORE ﹀
      This course provides an introduction to the applications in SAS Viya and discusses how each application is used in each phase of the SAS Analytics Life Cycle: Data, Discovery, Deployment, and Orchestration.

    Data Engineering Applications

    3

    • COURSE

      Building SAS® Studio Flows in SAS® Viya®
      SHOW MORE ﹀
      This course is for users who do not have SAS programming experience but need to access and prepare data, and present summarized results. This course focuses on using flows, a point-and-click tool in SAS Studio that visualizes data transformation processes.

    • COURSE

      Using SAS® Studio Engineer Steps in SAS® Studio Flows
      SHOW MORE ﹀
      This course shows how to use Table Loader steps in SAS Studio flows to perform Insert and Update operations for database tables, including how to implement slowly changing dimensions. This course also covers how to execute SAS Intelligent Decisioning decisions with a SAS Studio flow step.

    • COURSE

      Developing Custom Steps with SAS® Studio Analyst
      SHOW MORE ﹀
      The course teaches you how to develop custom steps to create a user interface to dynamically customize SAS code that can then be shared, reused, and executed in SAS Studio.

    • COURSE

      Self-Service Data Preparation in SAS® Viya®
      SHOW MORE ﹀
      This course provides an overview of the data preparation capabilities of SAS Data Preparation in SAS Viya. These data preparation capabilities include bringing data in from a variety of sources, assessing the structure and quality of data, preparing and cleansing the data to be fit for purpose, exploring and monitoring the relationships between objects in your environment, and sharing the data with others to promote collaboration and operational use.

    • COURSE

      Using SAS® Studio Flows and Custom Steps in SAS® Viya®
      SHOW MORE ﹀
      This course provides training on SAS Studio Flow in SAS Viya. It also covers how to create Custom Steps.

    • COURSE

      Using SAS Data Preparation in SAS® Viya®
      SHOW MORE ﹀
      This course provides training on SAS Data Preparation. It covers the SAS Viya applications of SAS Drive, SAS Data Explorer, SAS Data Studio, SAS Environment Manager: Jobs and Flows, and SAS Lineage.

    DataOps

    4

    • COURSE

      Using Azure DevOps and Azure Pipelines in SAS® Viya®
      SHOW MORE ﹀
      Learn how Azure DevOps supports, enhances, and accelerates the Analytics lifecycle in SAS Viya.

    SAS Viya Programming Certification

    5

    • COURSE

      Accelerating SAS® Code on the SAS® Viya® Platform
      SHOW MORE ﹀
      This course is for SAS programmers who want to learn how to run code on the SAS Viya platform. In the course, you first learn how you can easily run traditional SAS code in SAS Viya like you have in SAS 9. Then you learn how to modernize your SAS code to take advantage of SAS Cloud Analytic Services (CAS) on the platform to boost program performance. CAS is a high-performance in-memory analytic engine that performs massively parallel processing (MPP) on data of any size, working with multiple machines, CPUs, and threads for lightning-fast results. The course focuses on how to access, manage, analyze, and manipulate in-memory tables on the distributed CAS server using traditional SAS code as well as new coding techniques. This course is not intended for beginning SAS software users.

    • COURSE

      High-Performance Data Processing with CASL in SAS® Viya®
      SHOW MORE ﹀
      In this course, you learn how to leverage SAS Cloud Analytic Services (CAS), the high-performance server that provides the run-time environment for data management and analytics on the SAS Viya platform. You learn how to access, explore, prepare, analyze, and summarize data using the native CAS programming language (CASL). CASL is a new scripting language designed to support the entire analytics life cycle.

    • COURSE

      SAS Viya Programming Certification Preparation
      SHOW MORE ﹀
      SAS certifications are globally recognized, so having them on your résumé proves you've received in-depth training from industry experts. These materials will help prepare you to earn the SAS Viya Programming Associate Certification and the SAS Viya Programming Specialist Certification.

    Data Engineering Programming

    6

    • COURSE

      Efficiency Tips for Database Programming in SAS®
      SHOW MORE ﹀
      This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors.

    • COURSE

      Using SAS® Software with AWS
      SHOW MORE ﹀
      This series of recordings describes and demonstrates the use of SAS software with AWS cloud services whether running SAS software in AWS or connecting to AWS services from SAS software running on-premises. These recordings show how you can use SAS in either of those scenarios to access AWS data storage and data management services, including AWS S3, AWS EMR, AWS RDS, AWS Redshift, and AWS Athena.

    • COURSE

      SAS® Programming Methods to Read, Process, and Write Database Tables
      SHOW MORE ﹀
      This course provides training on the generic aspects of how SAS connectivity works, including independent modules covering connectivity to specific data sources and connectivity in specific computing environments. Material will continue to be added to this course over time.

    • COURSE

      Leveraging the Power of the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      This course is for programmers who want to learn how to leverage the power of the SAS Quality Knowledge Base, or QKB. The QKB and the associated SAS Data Quality functions, routines, procedures, and CAS actions enable data cleansing, transformation, deduplication, and fuzzy matching using simplified code in DATA step, SQL, and CASL. The course builds on concepts presented in the SAS(R) Programming I: Essentials, SAS(R) Programming II: Manipulating Data with the DATA Step, and SAS(R) SQL 1: Essentials courses, and is not recommended for beginning SAS software users.

    • COURSE

      Data Management on SingleStore on the SAS® Viya® Platform
      SHOW MORE ﹀
      Introducing a true database management system into Viya opens the door to several new possibilities including easily managing data change. SingleStore’s UPSERT capability quickly and easily propagates source data change to the database that CAS reads directly. In this course, we continuously ingest data files that are dropped in real-time in a cloud object storage location (ADLS), load/update a SingleStore table accordingly and see if SAS Visual Analytics can capture those updates seamlessly.

    • COURSE

      CAS Data Management on the SAS® Viya® Platform
      SHOW MORE ﹀
      This course provides an in-depth look at the features and functionality of SAS Viya Data Management architecture, design, lifecycle, and programming.

    • COURSE

      SAS In-Database Technologies on the SAS® Viya® Platform
      SHOW MORE ﹀
      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.

    • COURSE

      SAS Viya: Data Management on Azure Cloud
      SHOW MORE ﹀
      This course prepares you to use Azure data sources with SPRE/SAS and SAS Viya/CAS. Topics include the Azure Eco system, Azure Data Lake Storage Gen2 (ADLS2), MS SQL Server, Azure Synapse, and connecting SAS and CAS to Azure data sources. The course provides practical hands-on exercises to fortify the material.

    • COURSE

      SAS Viya: Cloud Data Exchange
      SHOW MORE ﹀
      The SAS Cloud Data Exchange enables SAS users to connect and access data from a co-located database or from an on-premises database. The Cloud Data Exchange enables users to securely exchange on-premises data from behind a firewall to the SAS Viya platform in the cloud. All data transfer/exchange occurs on secured standard-based communications along with sophisticated authentication and authorization. The on-premises data center requires a single port opened through the firewall to facilitate the data exchange.

    Event Stream Processing

    7

    • COURSE

      SAS® Event Stream Processing: Essentials (6.2)
      SHOW MORE ﹀
      This course teaches you how to build SAS Event Stream Processing applications that ingest high-volume and high-velocity data streams, respond in real time, and store only relevant data elements. The course discusses basic concepts of event stream processing and introduces the component objects with which to build event stream processing applications.

    • COURSE

      SAS® Event Stream Processing Essentials
      SHOW MORE ﹀
      This course teaches you how to build SAS Event Stream Processing applications that ingest high-volume and high-velocity data streams, respond in real time, and store only relevant data elements. The course discusses basic concepts of event stream processing and introduces the component objects with which to build event stream processing applications.

    SAS Products Covered

    • SAS Visual Analytics
    • SAS Viya
    • SAS Studio
    • SAS Visual Statistics
    • SAS Studio Analyst
    • Base SAS
    • SAS/ACCESS
    • SAS Event Stream Processing
    • SAS Data Quality Solution
    • SAS Analytics Platform
    • SAS Environment Manager for Viya


    Digital Badges

    Earn a digital badge for each course that you complete and for each credential that you earn. Show off your achievements on your resume and in your social channels to highlight your skills and connect with potential employers.

    Certification Preparation



    When you complete the courses in this subscription, you will have the demonstrated skills necessary to prepare you to earn the following credentials:

  • SAS Certified Associate: Programming Fundamentals Using SAS Viya
  • SAS Certified Specialist: Intermediate Programming Using SAS Viya



    • “I think the self-paced training was the BEST I’ve ever taken. The videos were short and segmented correctly to keep my attention and the activities and quizzes were just enough to help my confidence.”

    Tony Mayo, SAS Customer