Denodo Platform 9 Certified Developer Professional study plan

Map every derived view type (selection, projection, join, union, aggregation, flatten, intersect, minus) to a concrete scenario and build a working view for each in a local Virtual DataPort instance

Create at least three join types (inner, left outer, full outer) across two base views and inspect the generated execution plan to identify where the join is pushed down versus executed in Denodo

Rewrite one slow join as a materialized-style derived view and compare query traces before and after to quantify the improvement

Explain in writing when a union versus an intersect or minus view is the correct modeling choice, with one example each

Apply the main query optimization levers (join order, join type selection, aggregation pushdown, subquery delegation, cost-based optimization hints) to a deliberately inefficient query and record each change's effect

Configure and validate a cache module on a derived view, including cache mode, invalidation schedule, and TTL, then prove the cache is hit using query statistics

Identify and fix at least two anti-patterns such as unnecessary DISTINCT, non-delegable functions in WHERE clauses, or cross joins that block pushdown

Build a baseline performance test with three representative queries and capture elapsed time and rows processed

Create base views over at least four source types (relational JDBC, delimited file, JSON/REST, and one additional such as XML or Excel) and configure each data source's connection pooling

Configure schema refresh and incremental metadata update for one base view, then trigger a change at the source and verify the view updates without breaking downstream views

Set up a JDBC data source with correct connection pool sizing, validation query, and timeout settings, and explain the effect of each parameter

Diagnose and resolve two deliberate connection failures (bad credentials, unreachable host) using Virtual DataPort logs

Configure two authentication mechanisms (local database and LDAP or another external provider) and assign users to roles with least-privilege grants

Implement row-level and column-level security on a derived view using a policy that filters by session user, then verify with two different logged-in users

Apply data masking to at least three sensitive columns, choosing between masking and encryption based on whether the consumer needs the original value

Create associations between related views and apply tags and descriptions so that the metadata is discoverable through search

Publish one derived view as a REST web service and one as an OData service, then call each successfully with a client tool and capture the request and response

Publish a SOAP web service and a GraphQL endpoint over the same or a related view, and compare the payload shape and filtering capability across the four protocols

Configure at least two service-level controls such as pagination, result limits, output format, or authentication on the published interfaces

Document when each protocol is the right choice for a consuming application

Create a Scheduler job that performs a full load into a target and a second job that performs an incremental load using a timestamp or sequence watermark

Run the incremental job twice with intervening source changes and verify that only new or changed rows are transferred

Configure job scheduling, error handling, and notification, then force a failure to confirm the alert path works

Tune one slow job by adjusting parallelism or batch size and measure the change

Export a project from Design Studio, import it into a second environment through Solution Manager, and resolve any dependency or revision conflicts that arise

Create a tagged revision or snapshot before a change, apply the change, and demonstrate rollback to the prior state

Use the elements and dependency view to identify everything affected by modifying one base view before making the change

Write a short promotion checklist covering what must be verified before moving a revision to production

Describe the role of the main platform components (Virtual DataPort server, administration tool, Scheduler, Solution Manager, cache and embedded databases) and how they communicate

Review server configuration and diagnostic tooling, including log levels, monitoring queries, and health checks, and use them to investigate one simulated issue

Re-run the week 2 performance baseline and the week 4 security checks to confirm nothing regressed

Take two timed practice assessments weighted toward domains 2, 4, and 6, and review every missed item by returning to the underlying concept