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.
START FREE TRIAL
Purchase this digital subscription to:
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

    Getting Started

    1

    • COURSE

      SAS Viya Data Engineering: Getting Started
      SHOW LESS ︿
      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.

      ENROLL

    SAS Viya Overview

    2

    • COURSE

      SAS® Viya Overview
      SHOW LESS ︿
      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.

      ENROLL

    Data Engineering Applications

    3

    • COURSE

      Managing and Querying Data Using Flows in SAS Studio
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Using SAS® Studio Engineer Steps in SAS® Studio Flows
      SHOW LESS ︿
      This course demonstrates how to take your point-and-click SAS Studio Flow skills to the next level with SAS Studio Engineer. This advanced SAS Studio license includes steps that enable you to integrate data, improve data quality, and perform specialized data transformation tasks while working with a variety of data types.

      ENROLL

    • COURSE

      Developing Custom Steps with SAS® Studio Analyst
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Self-Service Data Preparation in SAS® Viya®
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

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

      ENROLL

    • COURSE

      Govern Data with SAS® Information Catalog
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

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

      ENROLL

    • COURSE

      Scheduling and Orchestrating SAS® Programs and SAS® Studio Flows with SAS® Environment Manager Jobs and Flows
      SHOW LESS ︿
      Attendees will learn how to automate the regular execution of SAS Viya jobs by building time-based and event-based schedules. Attendees will learn to group jobs into job flows, which include complex execution dependencies, so jobs can wait for their prerequisites to be in place as well as to facilitate conditional execution.

      ENROLL

    DataOps

    4

    • COURSE

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

      ENROLL

    • COURSE

      DevOps with SAS® Viya® and GitLab
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Versioning with SAS® Studio Git Integration
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Managing SAS® and Python Program Development with Git in SAS® Viya® Workbench and SAS® Viya®
      SHOW LESS ︿
      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.

      ENROLL

    SAS Viya Programming Certification

    5

    • COURSE

      Accelerating SAS® Code on the SAS® Viya® Platform
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      High-Performance Data Processing with CASL in SAS® Viya®
      SHOW LESS ︿
      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.

      ENROLL

    • CERTIFICATION PREP

      SAS Certified Associate: Programming Fundamentals Using SAS Viya
      SHOW LESS ︿
      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.

      ENROLL

    • CERTIFICATION PREP

      SAS Certified Specialist: Intermediate Programming Using SAS Viya
      SHOW LESS ︿
      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.

      ENROLL

    Data Engineering Programming

    6

    • COURSE

      Efficiency Tips for Database Programming in SAS®
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Using SAS® Software with AWS
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      SAS® Programming Methods to Read, Process, and Write Database Tables
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Leveraging the Power of the SAS® Quality Knowledge Base
      SHOW LESS ︿
      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® Programming 1: Essentials, SAS® Programming 2: Data Manipulation Techniques, and SAS® SQL 1: Essentials courses, and is not recommended for beginning SAS software users.

      ENROLL

    • COURSE

      Engineering and Analyzing Data at Scale with SAS® SpeedyStore
      SHOW LESS ︿
      This course offers a deep dive into SAS SpeedyStore, which combines the power of SAS Viya with SingleStore—a modern, cloud-native relational database—to simplify your data architecture. You'll learn how to unify operational, analytical, and AI workloads in a single high-performance environment, leverage CAS and SAS Compute Server to run in-database analytics, accelerate DATA step processing, and build intelligent, end-to-end workflows using SAS Studio.

      ENROLL

    • COURSE

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

      ENROLL

    • COURSE

      Understanding SAS® In-Database Technologies on the SAS® Viya® Platform
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      SAS Viya: Data Management on Azure Cloud
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      SAS® Viya®: Cloud Data Exchange
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      Accessing Data on Google Cloud with SAS® Viya®
      SHOW LESS ︿
      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.

      ENROLL

    Event Stream Processing

    7

    • COURSE

      SAS® Event Stream Processing: Essentials (6.2)
      SHOW LESS ︿
      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.

      ENROLL

    • COURSE

      SAS® Event Stream Processing Essentials
      SHOW LESS ︿
      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.

      ENROLL

    SAS Products Covered

    • SAS Visual Analytics
    • SAS Studio
    • SAS Visual Statistics
    • SAS Viya
    • SAS Studio Analyst
    • SAS Intelligent Decisioning
    • SAS Lineage
    • SAS/ACCESS
    • Base SAS
    • SAS SpeedyStore
    • SAS Event Stream Processing
    • 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