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 overview of SAS Viya, including platform architecture, applications, and code development. Each demonstration is designed for learners to follow along and experience how SAS Viya supports every phase of the analytics lifecycle in a single integrated platform.

    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

      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 ﹀

    • 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

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

    • COURSE

      Govern Data with SAS® Information Catalog
      SHOW MORE ﹀
      This workshop offers a hands-on exploration of SAS Viya's capabilities for Data Governance, focusing on the SAS Information Catalog and its related tools. Learn to navigate asset exploration, manage a business glossary, and integrate data lineage for improved governance practices.

    • COURSE

      Managing and Querying Data Using Flows in SAS Studio
      SHOW MORE ﹀
      Master managing and querying data with our introductory course on using steps in flows, an intuitive point and click tool that visualizes data pipelines in SAS Studio on the SAS Viya platform.

    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.

    • COURSE

      DevOps with SAS® Viya® and GitLab
      SHOW MORE ﹀
      This interactive workshop offers a unique opportunity to learn how to use SAS Viya content development with GitLab repositories, facilitating seamless DevOps collaborations. The course emphasizes the implementation of GitLab CI/CD pipelines to automate development processes in SAS Studio. By attending this workshop, you stand to gain insights and skills to streamline your DevOps processes, promote teamwork, and boost productivity.

    • COURSE

      Scheduling and Orchestrating SAS® Programs and Flows with Apache Airflow
      SHOW MORE ﹀
      Learn how to schedule and orchestrate SAS programs, flows, and jobs using Apache Airflow.

    • COURSE

      Versioning with SAS® Studio Git Integration
      SHOW MORE ﹀
      Join our hands-on workshop to leverage the power of Git within SAS Studio on the SAS Viya platform and elevate your software project management to new heights. This training session will provide you with the essential skills to integrate Git for version control in your development workflow, enabling you to efficiently manage your source code for SAS and Python programs, SAS Studio flows, or custom steps.

    • COURSE

      Managing SAS® and Python Program Development with Git in SAS® Viya® Workbench and SAS® Viya®
      SHOW MORE ﹀
      This workshop provides hands-on instructions for managing SAS and Python program development using Git in SAS Viya Workbench and SAS Viya. Participants will learn to implement trunk-based development strategies and execute code using job flows, the SAS Viya Command Line Interface, and Airflow DAGs. The course is designed for intermediate users and covers essential tools like SAS Studio, Visual Studio Code, and Apache Airflow.

    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.

    • CERTIFICATION PREP

      SAS Certified Associate: Programming Fundamentals Using SAS Viya
      SHOW MORE ﹀
      As you prepare for the SAS Viya Fundamentals of Programming certification exam, you will learn how to work with CAS tables and data sources, use CAS-enabled procedures, modify DATA step and SQL programs to run in CAS, and use user-defined formats in CAS.

    • CERTIFICATION PREP

      SAS Certified Specialist: Intermediate Programming Using SAS Viya
      SHOW MORE ﹀
      As you prepare for the SAS Viya Intermediate Programming certification exam, you will you learn how to modernize your SAS code to take advantage of SAS Cloud Analytic Services (CAS). You will learn how to access, manage, analyze, and manipulate in-memory tables on the distributed CAS server using traditional SAS code as well as the native CAS programming language (CASL), new scripting language designed to support the entire analytics life cycle.

    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.

    • COURSE

      Accessing Data on Google Cloud with SAS® Viya®
      SHOW MORE ﹀
      This workshop covers how to access data in the Google Cloud Ecosystem with SAS Viya. It includes an introduction to Google Cloud with a focus on the data pieces. You learn how SAS fits in this ecosystem and gain experience with Google Cloud Storage, Google Cloud SQL, Google Dataproc, and Google BigQuery.

    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 Studio
    • SAS Visual Statistics
    • SAS Viya
    • SAS Studio Analyst
    • SAS Lineage
    • SAS/ACCESS
    • Base SAS
    • 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