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.
|Goals||Participants are self-sufficient working data projects with Tweakstreet.|
|Delivery||By experienced instructor online or in-person on-site.|
|Languages||English or German.|
|Price||EUR 1200 per participant.
Travel and accommodation expenses if instructor delivers course on-site.
|Deliverables||Instructor’s slide deck with reference solutions to all exercise labs.|
|Prerequisites||Computer with stable internet connection. Administrative access to a local SQL database – such as Postgres or MySQL – for SQL exercise labs.|
|Tailoring||We’re happy to tailor topics to your needs. Mix, match, or remove topics to suit your needs and budget.|
Module 1 – Tweakstreet platform
- The Workbench
- Control Flows
- Data Flows
- The CLI
Module 2 – Reading and writing files
- Microsoft Excel
Module 3 – SQL databases
- JDBC Data Sources
- SQL Scripting
- Writing data to databases
- Reading data from databases
- Dimension Insert / Update
Module 4 – Data Transformation
Module 5 – Project Organization
- Shared Modules
- Environment Management