SAS 9 Data Management Learning Subscription
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:
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
-
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 PREP
Practice Exam: SAS Data Integration Development for SAS 9 SHOW MORE ﹀Practice Exam: SAS Data Integration Development for SAS 9
Data Connectivity
-
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
-
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
-
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 PREP
Practice Exam: SAS Data Quality Using Dataflux Data Management Studio SHOW MORE ﹀Practice Exam: SAS Data Quality Using Dataflux Data Management Studio
Additional Data Quality Topics
-
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.
-
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.
Hadoop
-
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.
Event Stream Processing
-
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.
Decisioning
-
COURSE
Using SAS Intelligent Decisioning in SAS® Viya® SHOW MORE ﹀
SAS Products Covered
- SAS Data Integration Studio
- SAS Data Quality Solution
- SAS Analytics Platform
- Base SAS
- SAS/ACCESS
- SAS Enterprise Guide
- DataFlux Data Management Studio
- SAS Federation Server
- SAS Business Data Network
- SAS Data Governance
- SAS Lineage
- DataFlux dfPower Studio
- DataFlux Data Management Server
- DataFlux Quality Knowledge Base
- DataFlux Integration Server for SAS
- SAS Viya
- SAS Data Connect Accelerator for Hadoop
- SAS Data Connector to Hadoop
- SAS Data Loader for Hadoop
- SAS Event Stream Processing
- SAS Intelligent Decisioning
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:
“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.”