SAS 9 Data Management Learning Subscription

For programmers, data engineers, data integration developers, and data quality stewards using SAS®9 for their data management solution.
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 designing and deploying data integration and data quality processes. Learn how to access data from a variety of sources, efficiently extract the relevant data, detect data quality issues, and implement processes to improve data quality. In addition, you learn how to apply a variety of data transformation methods to structure the data in ways that support downstream business applications and analytic solutions.

Learn how to:

  • Access data from a variety of source systems and formats and transform it into structures required for business and analytical objectives.
  • Tune SAS programs accessing relational database tables for optimized execution.
  • Profile data to identify data quality issues.
  • Create data flows for data quality improvement and data transformation.
  • Automatically detect and report data quality issues by applying business issues.
  • Apply data quality algorithms to standardize data values and identify duplicate entities.
  • Schedule and manage jobs to execute data transformation pipelines.
  • Process, transform, and publish event stream data in real time.
  • Create a glossary of terms for data governance and associate terms with data sources and data pipelines.
  • View and interpret lineage relationships among data entities and terms.
  • Before taking courses in this learning subscription, it’s recommended you have experience with SAS programming basics, SQL processing, and the SAS macro facility. You can gain this experience by completing the SAS® Programming 1: Essentials course and the courses in the SAS Programming Learning Subscription.

    Gain expertise in designing and deploying data integration and data quality processes. Learn how to access data from a variety of sources, efficiently extract the relevant data, detect data quality issues, and implement processes to improve data quality. In addition, you learn how to apply a variety of data transformation methods to structure the data in ways that support downstream business applications and analytic solutions.

    Learn how to:

    Access data from a variety of source systems and formats and transform it into structures required for business and analytical objectives. Tune SAS programs accessing relational database tables for optimized execution. Profile data to identify data quality issues. Create data flows for data quality improvement and data transformation. Automatically detect and report data quality issues by applying business issues. Apply data quality algorithms to standardize data values and identify duplicate entities. Schedule and manage jobs to execute data transformation pipelines. Process, transform, and publish event stream data in real time. Create a glossary of terms for data governance and associate terms with data sources and data pipelines. View and interpret lineage relationships among data entities and terms.

    Before taking courses in this learning subscription, it’s recommended you have experience with SAS programming basics, SQL processing, and the SAS macro facility. You can gain this experience by completing the SAS® Programming 1: Essentials course and the courses in the SAS Programming Learning Subscription.




    Courses Included in Subscription

    Data Integration Developer Certification

    1
    • COURSE

      SAS® Data Integration Studio: Fast Track
      SHOW MORE ﹀
      This course introduces SAS Data Integration Studio and includes topics about change management, registering source data and target data in metadata, creating and working with jobs, and working with transformations. The course also provides information about creating iterative processes, creating conditional processes, defining new transformations, in-database processing, analyzing metadata, promoting metadata, versioning metadata, and deploying jobs.

      The self-paced e-learning includes:

      • Annotatable course notes in PDF format.
      • Virtual lab time to practice.


    • CERTIFICATION REVIEW

      Practice Exam: SAS Data Integration Development for SAS 9
      SHOW MORE ﹀

      This exam tests the candidate's ability to apply the skills and knowledge necessary for data integration development in the SAS environment. Successful candidates should be able to do the following:

      • Define architecture of the platform for SAS Business Analytics.
      • Create metadata for source and target data.
      • Create metadata for target data and jobs.
      • Work with transformations.
      • Work with tables and table loader transformation.
      • Work with slowly changing dimensions.
      • Define generated transformations.
      • Deploy jobs.



    Data Connectivity

    2
    • 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

      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.

    Data Governance

    3
    • COURSE

      SAS® Federation Server: Accessing and Virtualizing Enterprise Data
      SHOW MORE ﹀
      SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer.

    • COURSE

      SAS® Data Governance Essentials
      SHOW MORE ﹀
      This course teaches you how to create and manage terms using SAS Business Data Network, how to access and view relationship information in SAS Lineage, and how to monitor data in SAS Business Rules Manager and view the monitoring results in SAS Visual Analytics.

    Data Quality Steward Certification

    4
    • COURSE

      Using DataFlux® Data Management Studio
      SHOW MORE ﹀
      This course introduces DataFlux Data Management Studio and includes topics for data profiling, data jobs to perform data management tasks (such as data quality and entity resolution), data monitoring, usage of DataFlux Expression Engine Language, macro variables, and process jobs.

    • COURSE

      Understanding the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      This course is designed for data quality stewards who need to learn more about the Quality Knowledge Base (QKB), as well as how to use DataFlux Data Management Studio to investigate and work with the QKB and its components.

      The self-study e-learning includes:

      • Annotatable course notes in PDF format.
      • Virtual lab time to practice.


    • COURSE

      Creating a New Data Type in the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      This course is designed for data quality stewards who need to learn more about how to use DataFlux Data Management Studio to create new data types in the Quality Knowledge Base.

      The self-study e-learning includes:

      • Annotatable course notes in PDF format.
      • Virtual lab time to practice.


    • CERTIFICATION REVIEW

      Practice Exam: SAS Data Quality Using Dataflux Data Management Studio
      SHOW MORE ﹀

      Welcome to the practice exam for the SAS Certified Data Quality Steward for SAS9 credential. This exam is designed for individuals who are using DataFlux Data Management Studio to perform a variety of data quality tasks, including profiling data, cleansing data and monitoring data for usability. Successful candidates should be able to do the following:

      • Create and review data explorations and data profiles.
      • Create data jobs for data improvement.
      • Parameterize jobs and business rules within DataFlux Data Management Studio.
      • Create, maintain and apply business rules and tasks.
      • Understand the QKB components and various definition types.
      • Apply QKB components to address data quality issues.
      • Expand basic functionalities using Expression Engine Language (EEL).
      • Use macro variables.
      • Create process jobs.
      • Configure the DataFlux Data Management Server to run jobs.



    Additional Data Quality Topics

    5
    • COURSE

      Leveraging the Power of the Quality Knowledge Base (QKB) in SAS® Technology Components
      SHOW MORE ﹀
      This course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.

      The self-study e-learning includes:

      • Annotatable course notes in PDF format.
      • Virtual Lab time to practice.


    Hadoop

    6
    • COURSE

      Introduction to SAS® and Hadoop
      SHOW MORE ﹀
      This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Pig code from SAS via the HADOOP procedure. In addition, the SAS/ACCESS Interface to Hadoop methods that allow LIBNAME access and SQL pass-through techniques to read and write Hadoop Hive table structures are discussed. Although not covered in detail, a brief overview of additional SAS and Hadoop technologies, including executing DS2 in Hadoop with the SAS Code Accelerator for Hadoop and using Hadoop data sources for the distributed in-memory analytics platform of SAS Viya, is included. This course is included in the Expert Exchange on Hadoop: Using SAS/ACCESS service offering to configure SAS/ACCESS Interface to Hadoop or SAS/ACCESS Interface to Impala to work with your Hadoop environment.

    • COURSE

      Hadoop Data Management with Hive, Pig, and SAS®
      SHOW MORE ﹀
      In this course, you use processing methods to prepare structured and unstructured big data for analysis. You learn to organize this data into a variety of Hadoop distributed file system (HDFS) storage formats for processing efficiency using Apache Hive and Apache Pig. You also learn SAS software technologies that integrate with Hive and Pig and how to leverage these open source capabilities by programming with Base SAS and SAS/ACCESS Interface to Hadoop.

    • COURSE

      Working with SAS® Data Loader for Hadoop
      SHOW MORE ﹀
      This course gives business analysts and data scientists a seamless platform to profile, integrate, cleanse, and move big data without writing code in a Hadoop environment using an intuitive web-based interface.

    • 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.

    • 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 Data Quality Solution
    • SAS Data Integration Studio
    • SAS Analytics Platform
    • Base SAS
    • SAS/ACCESS
    • SAS Enterprise Guide
    • DataFlux Data Management Studio
    • SAS Federation Server
    • DataFlux Web Studio Server%3BSAS Data Governance%3BDataFlux Data Management Studio%3BSAS Marketing Automation%3BSAS Data Integration Studio%3BSAS Management Console%3BDataFlux Data Management Server%3BSAS Lineage%3BSAS Workflow Studio%3BSAS Business Data Network
    • DataFlux dfPower Studio
    • DataFlux Data Management Server
    • DataFlux Quality Knowledge Base
    • DataFlux Integration Server for SAS
    • SAS Data Connect Accelerator for Hadoop
    • SAS Data Connector to Hadoop
    • SAS Data Loader for Hadoop
    • SAS Event Stream Processing


    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 learning path, you will have the demonstrated skills necessary to prepare you to earn the following credentials:

  • SAS Certified Data Integration Developer
  • SAS Certified Data Quality Steward for SAS 9
  • When you complete the courses in this learning path, you will have the demonstrated skills necessary to prepare you to earn the following credentials:

    SAS Certified Data Integration Developer SAS Certified Data Quality Steward for SAS 9



    “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