SAS Certified Data Integration Developer: Fast Track

- Slechts 5 dagen

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.

Lees meer...

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.

Zie Benefits...

Bekijk nu de prijzen om erachter te komen hoeveel je kunt besparen als je tweemaal zo snel traint.

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

  1. Jij zal in slechts 5 dagen Data Integration Developer getrained 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, examen, 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 72,589 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.

Bekijk nu de prijzen om erachter te komen hoeveel je kunt besparen als je tweemaal zo snel traint.

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

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

Zie Exam Track...

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

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%

Zie What's Included...

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

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

Zie Prerequisites...

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

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 u niet zeker of u aan de voorwaarden voldoet?
Maakt u zich geen zorgen. We bespreken uw technische achtergrond, ervaring en kwalificaties om te bepalen of deze versnelde cursus bij u past.

Bel ons op 024-8457770 en spreek met een van onze inschrijvingsadviseurs.

Firebrand is een meeslepende omgeving en vereist betrokkenheid. Sommige vereisten zijn slechts richtlijnen; je zult misschien je unieke ervaring, houding en vastberadenheid vinden die je in staat stelt om te slagen in je versnelde loop.

Zie Wanneer...

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

SAS Data Integration Developer Cursusdata

Start datum

Eind datum

Status

Locatie

Nu boeken

26/8/2019 (Maandag)

30/8/2019 (Vrijdag)

Beëindigde cursus

-

 

10/2/2020 (Maandag)

14/2/2020 (Vrijdag)

Beperkte beschikbaarheid

Landelijk

 

23/3/2020 (Maandag)

27/3/2020 (Vrijdag)

Open

Landelijk

 

4/5/2020 (Maandag)

8/5/2020 (Vrijdag)

Open

Landelijk

 

15/6/2020 (Maandag)

19/6/2020 (Vrijdag)

Open

Landelijk

 

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!

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


"Fantastic tuition, great surroundings and very helpful staff. Hard work but worth it. "
Anonymous. - Amazon Web Services (AWS) Firebrand's training for AWS's Certified Solutions Architect – Associate certificering (4 Dagen) (29/7/2019 t/m 1/8/2019)

"The learning process is intensive, however the trainer provided an excellent learning plan to manage the intensive shared knowledge."
Anonymous. - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 Dagen) (2/8/2019 t/m 4/8/2019)

"Excellent Training Center"
Pedro Goncalves. - ISACA CISA Certificering (4 Dagen) (4/3/2019 t/m 7/3/2019)

"Firebrand was a useful choice for completing the course in a timely fashion. Thanks!"
Marcus Bjork. - ISACA CISA Certificering (4 Dagen) (4/3/2019 t/m 7/3/2019)

"Prima cursus, prima trainer, goede lokatie. Gevolgd in het engels, goed te volgen voor iemand met ruime basis kennis van het Engels"
Anoniem - Scrum Firebrands opleiding voor Scrum.orgs Professional Scrum Master certificering (2 Dagen) (4/2/2019 t/m 5/2/2019)

"The instructor taught he material really well. There was a lot of material to cover and he managed it in an engaging effective manner. Thanks to the instructor"
Anonymous. - EC-Council Certified Ethical Hacker (CEH) (5 Dagen) (19/11/2018 t/m 23/11/2018)

"CEH course was a good mix of theory and practical labs. Really helpful to visualise the exam."
Anonymous. - EC-Council Certified Ethical Hacker (CEH) (5 Dagen) (19/11/2018 t/m 23/11/2018)

"An intense but enjoyable week. Thanks to team Firebrand. "
Richard Sumnall. - (ISC)2 CISSP Boot Camp (6 Dagen) (5/11/2018 t/m 10/11/2018)

"Iy is a good CISSP training. "
Anonymous. - (ISC)2 CISSP Boot Camp (6 Dagen) (5/11/2018 t/m 10/11/2018)

"De opleiding is aangevult met praktische voorbeelden. Dit maakt het allemaal iets bevattelijker en praktijk gericht. "
Johan van Kerkhove, C9. - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (12/9/2018 t/m 14/9/2018)

"Professionele aanpak, zeer accurate informatie betreffende verloop en organisatie. "
Kristel Singuele, crabos. - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (12/9/2018 t/m 14/9/2018)

"Again, another lightening fast course with a certificate in the end. The trainers amaze me everytime, on how well-skilled they are. Keep up the good work guys!"
Thomas Geens, SECOTRON. - Microsoft MCSA: Office 365 (5 Dagen) (10/9/2018 t/m 14/9/2018)

"Really good training"
Bram Cooreman, All Buro Solutions. - Microsoft MCSA: Office 365 (5 Dagen) (10/9/2018 t/m 14/9/2018)

"Fast, Fun and high quality training with the best instructors. "
Rune Gomo, Matiq. - ISO 27001 Lead Auditor - Information Security Management (3 Dagen) (10/7/2018 t/m 12/7/2018)

"Firebrand is a company who provides you with knowledge in less time. The people know what they are talking about. "
Anoniem - ISO 27001 Lead Auditor - Information Security Management (3 Dagen) (10/7/2018 t/m 12/7/2018)

"Improving course that provide me the information I was looking for. The instructor was very energetic and kept the course interesting. "
Stig Henning Verpe, Matiq. - ISO 27001 Lead Auditor - Information Security Management (3 Dagen) (10/7/2018 t/m 12/7/2018)

"verrijking en verbreding"
Anoniem, Top Vision Group - Scrum Firebrands opleiding voor Scrum.orgs Professional Scrum Master certificering (2 Dagen) (9/7/2018 t/m 10/7/2018)

"Een heldere uitleg waarbij concepten eenvoudig worden uitgelegd maar tegelijk toch doorspekt is met reële voorbeelden."
Anoniem, Michael Borchardt - Scrum Firebrands opleiding voor Scrum.orgs Professional Scrum Master certificering (2 Dagen) (9/7/2018 t/m 10/7/2018)

"Ik wist niet zo goed wat ik kon verwachten. Het is al weer even geleden een training namelijk. Prachtige locatie, erg goede trainer, alles goed geregeld. Samengevat: Zou het zo weer doen!"
Anoniem, Edutel - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (2/7/2018 t/m 4/7/2018)

"The last 3 days were awesome. "
Anoniem - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (2/7/2018 t/m 4/7/2018)

"Mijn ervaring is zeer positief. Goed verzorgd. "
Anoniem, Wasco - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (2/7/2018 t/m 4/7/2018)

"Practical, concise and worthwhile. "
Anoniem - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (2/7/2018 t/m 4/7/2018)

"Recommended it to any IT engineer, who wants to quickly get better at their work. "
Nico Verver. - Cisco ICND2 (CCNA) (3 Dagen) (29/6/2018 t/m 1/7/2018)

"doeltreffend to the point, de cursus die door PMI gegeven wordt is zeer goed reflecterend met de deliverables van PMBOCK. "
Anoniem, D-TEC PMC B.V. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (18/6/2018 t/m 22/6/2018)

"doeltreffend to the point, de cursus die door PMI gegeven wordt is zeer goed reflecterend met de deliverables van PMBOCK. "
Anoniem, D-TEC PMC B.V. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (18/6/2018 t/m 22/6/2018)

"Enjoyable course although intensive in time frame. Kept topics interesting, food energy. "
Anoniem - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Enjoyable course although intensive in time frame. Kept topics interesting, food energy. "
Anoniem - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"I enjoyed this course more than any other that I have taken previously and I think that was in part due to the instructor's depth of knowledge and ability to explain things clearly."
Anoniem - Amazon Web Services (AWS) Firebrand training for AWS Certified Solutions Architect - Associate and Professional certificering (7 Dagen) (22/5/2018 t/m 27/5/2018)

"Third training at Firebrand and for the third time, a great and fruitful experience."
Anoniem - EC-Council Certified Ethical Hacker (CEH) (5 Dagen) (11/6/2018 t/m 15/6/2018)

""
Anoniem, QAD - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

""
Anoniem, QAD - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Excellent Knowledge from a great practitioner with good training material."
Christian Lux, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Excellent Knowledge from a great practitioner with good training material."
Christian Lux, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"The training I received from Firebrand was like no other - informative, engaging and above all, the knowledge transfered to me in a way that I can recall easily."
Neil Staniforth. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"The training I received from Firebrand was like no other - informative, engaging and above all, the knowledge transfered to me in a way that I can recall easily."
Neil Staniforth. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"If you ever consider PMP prep training, I recommend you hire Firebrand. The instructor has a clear and detailed understanding of the content. The approach of the training is very lively and energetic."
Ronald Berenschot. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"If you ever consider PMP prep training, I recommend you hire Firebrand. The instructor has a clear and detailed understanding of the content. The approach of the training is very lively and energetic."
Ronald Berenschot. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"A great training, driven by a very knowledgeable and experienced trainer. The content of the training is well balanced and build up. All key areas of PMBOK are addressed as well as information about the exam content and exam applying process. On top of the training, the provided pdf-files and other digital available materials are a great asset and really help to prepare you for the exam. Finally the learning portal is a very user friendly tool to see were you are with your knowledge build up."
William Van den Berk, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"A great training, driven by a very knowledgeable and experienced trainer. The content of the training is well balanced and build up. All key areas of PMBOK are addressed as well as information about the exam content and exam applying process. On top of the training, the provided pdf-files and other digital available materials are a great asset and really help to prepare you for the exam. Finally the learning portal is a very user friendly tool to see were you are with your knowledge build up."
William Van den Berk, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Great use of training materials, great support portal and PDFs for reference."
Satpal Mali, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Great use of training materials, great support portal and PDFs for reference."
Satpal Mali, QAD. - Project Management Institute (PMI)® Project Management Professional (PMP)® Certificering (5 Dagen) (28/5/2018 t/m 1/6/2018)

"Intensive, focused and effective. Days are long, but managable. The Instructor is very helpful and approachable. His knowledge level of the topic is pro, period."
Jan Nakolinna, Boliden Kevitsa. - Microsoft MCSA: SQL Server 2016 - Database Administration (6 Dagen) (28/5/2018 t/m 2/6/2018)

"The speed is pretty fast and days could be a few hours shorter. But still nice and fast way to do the training."
Pasi Angeria. - Microsoft MCSA: SQL Server 2016 - Database Administration (6 Dagen) (28/5/2018 t/m 2/6/2018)

"The course gave me the confidence to put further applied knowledge into my day to day workload. I feel it has opened a level of awareness that I had not tapped into before."
Jordan Aimakhu, Beumer Group. - Project Management Institute (PMI)® Scheduling Professional (PMI-SP)® (3 Dagen) (30/5/2018 t/m 1/6/2018)

"Training with Firebrand was effective and a pleasure. Good accommodation, great trainer, well organised and clear communication."
A.P., 50five. - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (28/5/2018 t/m 30/5/2018)

"Every serious project manager (certified or not) should attend this training (and exam) on her/his list before 2020!"
Robert Welling, Red Hat. - Project Management Institute (PMI)® Agile Certified Practitioner (PMI-ACP)® (3 Dagen) (15/5/2018 t/m 17/5/2018)

"Excellent training, gained knowledge in short amount of time!"
Markus Schneck, CGI. - EC-Council Certified Incident Handler (ECIH) v2 (3 Dagen) (8/5/2018 t/m 9/5/2018)

"Trained with experienced instructor which added value and could answer questions."
Harald Weiss, CGI. - EC-Council Certified Incident Handler (ECIH) v2 (3 Dagen) (8/5/2018 t/m 9/5/2018)

"The training was well organised. The study materials were very useful, the instructions were very clear, very professional staff. In terms of logistical and other support, the environment was amazing, fantastic food, and very peaceful. Above all, the trainer was very professional, friendly and on top of his subject. I loved it!"
Abubakar Koroma. - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (23/4/2018 t/m 25/4/2018)

"The training was clear and a good understanding of business. "
Ola Ajannaku, zzp. - Data Protection Certified Data Protection Officer - GDPR Compliance (3 Dagen) (23/4/2018 t/m 25/4/2018)

Nieuwste Data Integration Developer-beoordelingen van onze studenten

Denk jij klaar te zijn voor deze opleiding? Doe een GRATIS oefentest om je kennis te testen!