Advanced query design

It is not enough to know how to configure reports. There can be multiple solutions to the same problem, one superior to the others. There can be situations where an ideal solution is not possible using the data that already exists. Creating data to simplify a query is a technique that can be leveraged. Also, the best way to store data to facilitate reporting needs to be made early on; data query ability cannot be an afterthought.

Fortgeschritten

Englisch

Nach Abschluss dieses Moduls können Sie Folgendes:

Produce queries that reference ancestors within a case hierarchy

Produce queries based on generated or reformatted data

Produce queries that include SQL Functions

Produce queries that contain complex SQL

In der folgenden Mission verfügbar:

Reporting Design v2

Themen

Inclusive and exclusive queries

15 Min.

Queries based on generated or reformatted data

15 Min.

Queries that contain complex SQL

15 Min.

SQL functions

20 Min.

Associations, class joins, and subreports

10 Min.

Modulquiz

5 Min.