Tweakstreet Foundation Course

This 5-day instructor-led course provides a strong foundation for working with Tweakstreet. It is aimed at Data engineers, Data analysts, and Data architects.

Participants gain a solid understanding and plenty of hands-on experience with key concepts and workflows through exercise labs.

Fact Sheet

GoalsParticipants are self-sufficient working data projects with Tweakstreet.
DeliveryBy experienced instructor online or in-person on-site.
LanguagesEnglish or German.
PriceEUR 1200 per participant.
Travel and accommodation expenses if instructor delivers course on-site.
DeliverablesInstructor's slide deck with reference solutions to all exercise labs.
PrerequisitesComputer with stable internet connection. Administrative access to a local SQL database - such as Postgres or MySQL - for SQL exercise labs.
TailoringWe're happy to tailor topics to your needs. Mix, match, or remove topics to suit your needs and budget.

Course Overview

Module 1 - Tweakstreet platform

  • Introduction
  • Components
  • Configuration
  • The Workbench
  • Control Flows
  • Data Flows
  • Formulas
  • The CLI

Module 2 - Reading and writing files

  • CSV
  • Text
  • XML
  • JSON
  • Microsoft Excel

Module 3 - SQL databases

  • JDBC Datasources
  • SQL Scripting
  • Writing data to databases
  • Reading data from databases
  • Dimension Insert / Update

Module 4 - Data Transformation

  • Validation
  • Grouping
  • Sorting
  • Joining
  • Lookups

Module 5 - Project Organization

  • Shared Modules
  • Environment Management

© 2021 Twineworks GmbH. All rights reserved.