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.

Advanced

Inglês

Depois de concluir este módulo, você deverá ser capaz de:

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

Disponível na seguinte missão:

Reporting Design v1

Tópicos

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

Quiz do módulo

5 min