Data Integration Developer

Duration: 120 Hours of Classroom Training

Course Introduction:

Learn how to write SAS programs and enter into the world of 4th generation programming even without any prior knowledge of programming. Understand the components of the SAS macro facility to automate your work and reduce the time and effort in writing and maintaining programs. Learn how to process SAS data using Structured Query Language (SQL). Move up the ladder in Data Management Technology and learn how to support the extraction, movement, transformation, and loading of data between systems. SAS Data Management products support migrating data between nearly any type of platform, database, and file format.

Who should attend: Aspirants who want to become Data Manager and build a strong SAS programming foundation to manipulate data, perform queries and analyses, and generate reports. Aspirants who want to develop skill set for building data warehouse and/or data mart while ensuring a high level of data quality and accessibility for business intelligence and data analytics applications and deliver data to the right place, at the right time, in the right form, to the right person.

Prerequisites: Flair of any programming language is preferred however not necessary. Candidates with experience in Data Management preferred
 

Course Modules

SAS® 
Programming 1: Essentials
  
  

It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses

SAS®
Programming 2:
Data Manipulation Techniques

Learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data.

SAS® Macro Language 1: Essentials
 
 

Learn the components of the SAS macro facility and how to design, write, and debug macro systems

SAS®
SQL 1: Essentials

 

This course teaches you how to process SAS data using Structured Query Language (SQL)


SAS®
Data Integration Studio:
Fast Track
 

Learn SAS Data Integration Studio for registering sources & targets; creating & working with jobs etc.

 


Data Integration developer

Case Studies in the Curriculum

Learn the application of data science through a comprehensive set of case studies designed by international industry experts in fields such as BFSI, Retail, E-Commerce, Cyber crime and much more

Preparing Data & Manipulation Techniques


Industry: Retail

  • Use programming approach for data preparation, manipulation & analysis purpose
     

Building Data Mart


Industry: Retail

  • Use Data integration techniques to integrate data from heterogeneous sources and build a data mart for future reporting analysis purpose.

Earn SAS Verified Digital Badges

Digital badges can be used in email signatures or digital résumés, and on social media sites such as LinkedIn, Facebook and Twitter. This digital image contains verified metadata that describes your qualifications and the process required to earn them.

  • Web-enabled version of your credential that can be shared online
  • Labor market insights that connect your skills to jobs
  • Trusted method for real-time credential verification.

"Smart Data Integration across various departments can help smooth out the rough edges of organization-wide workflows"

- Forbes

Quick Links