Course: Pentaho Data Integration for Database Developers
Id: PDI 2000 Type: Instructor led lecture / lab Delivery Method: Classroom Duration: 4 Days Cost: $2,500 (2500 euro in EMEA)
Course Benefits:
Data is increasing becoming the currency of business. Efficiently moving and transforming data between business systems and processes is key to maximizing the use of data to make informed decisions. This course provides foundational theory, best practices, design patterns, and hands on exercises utilizing Pentaho Data Integration to maximize the value of data to the organization.
Learning Objectives:
At the completion of this course, you should be able to:
Understand the basic architecture of Pentaho Data Integration (PDI) and its modules
Load and write data from and to different data sources
Join data from different sources
Perform multiple data transformations
Use PDI and ETL design patterns to populate a data warehouse
Influence the performance aspects of databases and PDI
Develop advanced transformations and jobs
Build portable and flexible jobs
Use the logging, monitoring and error handling features
Use JavaScript and Java classes into transformations
Load, transform and create complex XML structures
Retrieve and serve data via web services using PDI and the Pentaho BI Server
Understand the integration in the Pentaho BI Suite
Who Should Attend:
This course is designed for database developers and administrators; however, it is valuable to anyone with at least two years of experience
with SQL and relational database design/implementation.
Course Prerequisites:
There are no Pentaho Training prerequisites for this course. This course is designed for students with at least two years of experience
with SQL and relational database design/implementation.
Course Requirements:
Students will need a Microsoft Windows XP or Vista computer with a 1GHz CPU, 1 GB RAM, and a DVD drive, and 750 MB of available hard drive
space in order to fully participate in the classroom delivered courses. We suggest the computer have at least 1.3 GHz CPU, 2 GB of
memory, and 1 GB of available hard drive space. Make sure you have a text editor such as Notepad; you may need it for some of the exercises.
