Ons Benelux trainingscentrum is  weer geopend. Boost jouw skills en train versneld & voordelig met onze zomeractie en ontvang een korting tot 25% tijdens de maanden juni, juli en augustus.

SAS - Certified Data Integration Developer: Fast Track

Looptijd

Looptijd:

Slechts 5 dagen

Methode

Methode:

Klas / Online / Hybride

Volgende datum

Volgende datum:

28/9/2020 (Maandag)

Overview

On this accelerated 5-day SAS® Data Integration Studio course, you'll gain the knowledge and skills necessary for data integration development in the SAS environment.

You’ll first learn SAS SQL 1: Essentials and Macro Language 1: Essentials, learning how to process SAS data using Structured Query Language (SQL) and to write and debug macro systems.

Your expert instructor will then expand on this knowledge, taking you through SAS Data Integration Studio: Fast Track topics such as setting up change management, registering sources and targets, working with transformations and databases and defining new transformations.

You'll be immersed in official SAS curriculum through our unique Lecture | Lab | Review technique, which allows you learn and retain information faster than traditional courses.

You'll also learn how to:

  • Query, summarise and present data
  • Combine tables, including complex joins and merges
  • Replace multiple DATA and PROC steps with one SQL query.
  • Perform text substitution in SAS code
  • Automate and customise the production of SAS code
  • Conditionally or iteratively construct SAS code
  • Use macro variables and macro functions.
  • Work with slowly changing dimensions, Loop transformations
  • Examine impact analysis, exporting and importing of metadata
  • Establish checkpoints in job flow
  • Deploy jobs for scheduling and SAS Stored Processes.

You'll benefit from 24-hour lab access, allowing you to practice and apply your knowledge whenever you want.

During the course, you‚ll prepare for and sit the SAS® Certified Data Integration Developer for SAS9 exam. Don't pass the first time? Don‚t worry - you'll be covered by our Certification Guarantee.

If you're a Data integration developer, architect or an experienced SAS programmer looking to write reusable and dynamic SAS programs, this course is ideal for you.

Zeven redenen waarom jij voor jouw Data Integration Developer cursus voor Firebrand kiest:

  1. Jij zal in slechts 5 dagen Data Integration Developer gecertificeerd zijn. Doordat onze cursussen residentieel zijn kunnen wij langere lesdagen aanbieden en zal je tijdens je verblijf volledig gefocust zijn op jouw cursus
  2. Onze Data Integration Developer cursus is all-inclusive. Cursusmaterialen, examens, accommodatie en maaltijden zijn inbegrepen.
  3. Slaag de eerste keer voor Data Integration Developer of train gratis opnieuw.Op basis van onze certificeringsgarantie kun je voor het geval je de eerste keer niet slaagt binnen een jaar terugkomen en opnieuw trainen. Je betaalt dan alleen voor accommodatie en examens. De andere kosten zijn inbegrepen.
  4. Je zal meer over Data Integration Developer leren. Waar opleidingen elders doorgaans van 9:00 tot 17:00 duren, kan je bij Firebrand Training rekenen op 12 uur training per dag!
  5. Je zal Data Integration Developer sneller beheersen. Doordat onze cursussen residentieel zijn word je in korte tijd ondergedompeld in de theorie. Hierdoor zal je volledig gefocust zijn op de cursus en zal je sneller de theorie en praktijk beheersen.
  6. Je zal voor Data Integration Developer studeren bij de beste training provider. Firebrand heeft het Q-For kwaliteitlabel, waarmee onze standaarden en professionaliteit op het gebied van training erkend worden. We hebben inmiddels 75945 professionals getraind en gecertificeerd!
  7. Je gaat meer doen dan alleen de cursusstof van Data Integration Developer bestuderen. We maken gebruik van laboratoria, case-studies en oefentests, om ervoor te zorgen dat jij jouw nieuwe kennis direct in jouw werkomgeving kan toepassen.

Benefits

Curriculum

SAS Macro Language 1: Essentials

Introduction

  • course logistics
  • purpose of the macro facility
  • program flow

Macro Variables

  • introduction to macro variables
  • automatic macro variables
  • macro variable references
  • user-defined macro variables
  • delimiting macro variable references
  • macro functions

Macro Definitions

  • defining and calling a macro
  • macro parameters

DATA Step and SQL Interfaces

  • creating macro variables in the DATA step
  • indirect references to macro variables
  • creating macro variables in SQL

Macro Programs

  • conditional processing
  • parameter validation
  • iterative processing
  • global and local symbol tables

Learning More

  • SAS resources
  • beyond this course

Supplemental Materials

  • program flow

SAS SQL 1: Essentials

Introduction

  • overview of SAS Foundation
  • course logistics
  • course data files
  • introducing the Structured Query Language

Basic Queries

  • overview of the SQL procedure
  • specifying columns
  • specifying rows

Displaying Query Results

  • presenting data
  • summarising data

SQL Joins

  • introduction to SQL joins
  • inner joins
  • outer joins
  • complex SQL joins

Subqueries

  • noncorrelated subqueries
  • in-line views

Set Operators

  • introduction to set operators
  • the UNION operator
  • the OUTER UNION operator
  • the EXCEPT operator
  • the INTERSECT operator

Creating Tables and Views

  • creating tables with the SQL procedure
  • creating views with the SQL procedure

Advanced PROC SQL Features

  • dictionary tables and views
  • using SQL procedure options
  • interfacing PROC SQL with the macro language

Learning More

  • SAS resources
  • beyond this course

SAS Data Integration Studio: Fast Track

Introduction

  • exploring the platform for SAS Business Analytics
  • introduction to the Data Management applications
  • introduction to the classroom environment and the course tasks

Working with Change Management

  • introduction to change management
  • establishing a change management environment (Self-Study)

Creating Metadata for Source Data

  • setting up the environment
  • registering source data metadata

Creating Metadata for Target Data

  • registering target data metadata
  • importing metadata

Creating Metadata for Jobs

  • introduction to jobs and the job editor
  • using the Join transformation

Orion Star Case Study

  • defining and loading the customer dimension table
  • defining and loading the organisation dimension table
  • defining and loading the time dimension table

Additional Features for Jobs

  • importing SAS code
  • propagation and mapping
  • chaining jobs
  • performance statistics
  • metadata reports

Working with Transformations

  • using the extract and summary statistics transformations
  • exploring SQL transformations
  • establishing status handling
  • using the Data Validation transformation
  • using the Transpose, Sort, Append, Rank, and List Data transformations
  • using the Apply Lookup Standardisation, Standardise with Definition and One-Way Frequency transformations(self-study)

Working with the Loop Transformations

  • introduction to the loop transformations
  • iterating a job
  • iterating a transformation

Working with Slowly Changing Dimensions

  • defining slowly changing dimensions
  • using the SCD Type 2 Loader and Lookup transformations
  • using the SCD Type 1 Loader transformations
  • introducing the Change Data Capture transformations (self-study)

Creating Custom Transformations

  • using the new transformation Wizard
  • using the new transformation wizard

Working with the Table Loader Transformations

  • exploring the basics of the Table Loader transformations
  • exploring the load styles of the Table Loader transformation
  • managing indexes and constraints during loading
  • exploring bulk loading for DBMS tables

Working with Databases

  • introduction to In-Database processing
  • using In-Database processing
  • exploring ELT processing
  • using DBMS functions

Additional Topics for SAS Data Integration Studio Users

  • overview
  • analysing metadata using impact analysis
  • comparing tables
  • conditional execution
  • metadata promotion
  • version control
  • establishing checkpoints

Deploying Jobs

  • introduction
  • deploying jobs for scheduling
  • deploying jobs in batch
  • deploying jobs as stored processes

Implementing Data Quality Techniques

  • verifying data quality settings
  • using the DataFlux transformation

Exam Track

On this course, you'll sit the SAS® Certified Data Integration Developer for SAS®9 exam, covered by your Certification Guarantee

  • Number of questions: 76
  • Format: multiple choice questions
  • Duration: 105 minutes
  • Passing score: 70%

What's Included

On this course, you'll receive official SAS courseware.

Prerequisites

Before you attend this course, you should have experience with:

  • Submitting SAS programs on your operating system
  • Creating and accessing SAS data sets
  • Using arithmetic, comparison, and logical operators
  • Invoking SAS procedures
  • Using a DATA step to read from or write to a SAS data set or external file
  • Using DATA step programming statements such as IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO
  • Using SAS data set options such as DROP=, KEEP=, and OBS=
  • Using character functions such as SUBSTR, SCAN, INDEX, and UPCASE
  • Forming subsets of data using the WHERE clause
  • Creating and use SAS date values and constants
  • Using SAS procedures such as SORT, PRINT, CONTENTS, MEANS, FREQ, TABULATE, and CHART.

Weet je niet zeker of je aan de vereisten voldoet? Maak je geen zorgen. Jouw trainingsadviseur bespreekt jouw achtergrond met je om te begrijpen of deze cursus geschikt is voor je.

Beoordelingen

Wereldwijd heeft Firebrand in haar 10-jarig bestaan al 75945 studenten opgeleid! We hebben ze allemaal gevraagd onze versnelde opleidingen te evalueren. De laatste keer dat we onze resultaten analyseerden, bleek 96.75% ons te beoordelen als 'boven verwachting'


"With the training I got the necessary basis and direction and on how to approach the preparation for the CISA exam. I recommend to CISA candidates to first follow a training by Firebrand."
Anoniem, Rodriguez AertsFinancial Consultancy (11/5/2020 (Maandag) t/m 14/5/2020 (Donderdag))

"I wanted to learn more about Scrum, how to implement it in a company, how to act agile, but I have received so much more. The teacher did way more than just giving his course, he listened to us, thought with us, and really helped us move forward, both towards the exam as to how to implement it in real companies. The feedback did not end after the session, but the teacher has really put his time into helping us achieve our goal, and to gather even more knowledge than I thought I would."
Chiel Tondeleir, Digital Competitive. (4/4/2020 (Zaterdag) t/m 5/4/2020 (Zondag))

"The bootcamp formula and excellent instructor provide a perfect training environment. "
Anoniem (9/3/2020 (Maandag) t/m 14/3/2020 (Zaterdag))

"Goed, duidelijk op maat "
Anoniem, Bentacera (9/3/2020 (Maandag) t/m 11/3/2020 (Woensdag))

"Good organisation, pleasant environment "
Anoniem, Divitel (9/3/2020 (Maandag) t/m 11/3/2020 (Woensdag))

Cursusdata

Start datum

Eind datum

Status

Locatie

Nu boeken

25/5/2020 (Maandag)

29/5/2020 (Vrijdag)

Beëindigde cursus

-

 

28/9/2020 (Maandag)

2/10/2020 (Vrijdag)

Wachtlijst

Landelijk

 

9/11/2020 (Maandag)

13/11/2020 (Vrijdag)

Beperkte beschikbaarheid

Landelijk

 

21/12/2020 (Maandag)

25/12/2020 (Vrijdag)

Open

Landelijk

 

1/2/2021 (Maandag)

5/2/2021 (Vrijdag)

Open

Landelijk

 

15/3/2021 (Maandag)

19/3/2021 (Vrijdag)

Open

Landelijk

 

Nieuwste beoordelingen van onze studenten