Self Taught AMQL Index

Project docs

Mission, notes, and source material.

3 files

Markdown

Mission: Holistics AMQL/AQL fluency

MISSION.md

Markdown

Lessons

Main AQL teaching pages in sequence.

16 files

HTML 0001

Three AQL Shapes

lessons/0001-three-aql-shapes.html

1. Metric expression: reusable business number2. Table expression: explicit rows3. Explore expression: report queryPractice: choose the shapeRead next

HTML 0002

Your First AQL Explore

lessons/0002-your-first-aql-explore.html

Core ideaLine-by-line readingRetrieval practiceDo in AQLearnNext local lesson

HTML 0003

Aggregate Functions

lessons/0003-aggregate-functions.html

Core ideaFour functions to memorize firstAQLearn exercise targetRetrieval practiceDo in AQLearnNext local lesson

HTML 0004

Dimensions and Measures

lessons/0004-dimensions-and-measures.html

Core ideaDataset diagramSame measure, different dimensionsHeuristic: how many rows will I get?Retrieval practiceDo in AQLearn

HTML 0005

date_trunc

lessons/0005-date-trunc.html

Core ideaDataset diagramSame field, four granularitiesRetrieval practiceDo in AQLearnNext local lesson

HTML 0006

Filters

lessons/0006-filters.html

Purpose of this lessonCore ideaDatetime literal @Common filter operatorsDataset diagramWorked examples

HTML 0007

Relationships

lessons/0007-relationships.html

Purpose of this lessonCore ideaDataset diagramWorked examplesWhat "many-to-one" means hereRetrieval practice

HTML 0008

Order of operations of an AQL query

lessons/0008-side-quest-order-of-operations.html

Purpose of this lessonSQL refresher: logical query orderAQL pipeline in 7 stepsAQL step to SQL clauseThe big two: dimension filter vs metric filterGotcha: step 4 drops filters when of_all excludes a dimension

HTML 0009

Practice (1)

lessons/0009-practice-1.html

Purpose of this lessonDataset diagramTasks (build the query one step at a time)Retrieval practiceDo in AQLearnNext local lesson

HTML 0010

Metric Expressions

lessons/0010-metric-expressions.html

Purpose of this lessonThree words, three jobsSame expression, two slotsReading the AQLearn exampleSide by side: definition vs useWhy a count can be a dimension

HTML 0011

Pipe (1)

lessons/0011-pipe-1.html

Purpose of this lessonOne rule, in one sentenceVisualize one stepSQL translationWhat can sit on each sideChaining: many pipes in a row

HTML 0012

Table vs Scalar outputs

lessons/0012-table-vs-scalar.html

Purpose of this lessonTwo shapes, that is the whole languageEach function has an input shape and an output shapeCheat sheetTwo pipelines, one legal and one notReading a pipeline shape by shape

HTML 0013

select() and group()

lessons/0013-select-group-1.html

Purpose of this lessonOne sentence eachShape diagramWorked example 1: rename in select()Worked example 2: select() with inline aggregatesWorked example 3: explicit group() for a derived table

HTML 0014

Pipe (2) and Source Table

lessons/0014-pipe-2.html

Purpose of this lessonPipe is first-argument sugarDe-sugaring exerciseThe deeper idea: source table semanticsWorked comparison: products vs order_items as sourceSQL parallel

HTML 0015

select() and group() (2)

lessons/0015-select-group-2.html

Purpose of this lessonThe trap, in one lineVisualize the conflictThe ruleTwo valid alternativesHow to read your own intent

HTML 0016

Nested Aggregations (1)

lessons/0016-nested-aggregations-1.html

Purpose of this lessonParse the question firstThe fixed pipeline shapeVisualize the two levelsWorked example, step by stepSQL parallel

Reference

Course maps and reusable AQL reference pages.

2 files

HTML

AQL Core Shapes

reference/aql-core-shapes.html

Metric expressionTable expressionExplore expressionDebugging heuristicPrimary docs