03 Date&Time Transformation & In-Database processing - Exercise

<p><strong>Learning objective: </strong>In this exercise you will learn how to handle date&amp;time data types and practice in-database data aggregation techniques.</p><p><strong>Workflow description:</strong></p><p>In Activity I, Date&amp;Time nodes are used for filtering and extracting date information. The total sale amount is aggregated for each quarter then the resulting time series data is plotted.</p><p>In Activity II, the data processed in Activity I is written to a database. This data is then read from a database, and the total sale amount is aggregated for each quarter within the database.</p><p>Activity III demonstrates other database-related nodes and focuses on a use case of a <strong>DB Joiner </strong>node to filter data.</p><p><strong>You will find the instructions to the exercises in the yellow annotations.</strong></p>