mirror of https://gitee.com/bigwinds/arangodb
58 lines
2.1 KiB
Markdown
58 lines
2.1 KiB
Markdown
---
|
||
layout: default
|
||
description: The AQL tutorial is an introduction to ArangoDB’s query language. In this AQL tutorial you can interact with ArangoDB using its web interface.
|
||
title: ArangoDB Query Language (AQL) Tutorial
|
||
---
|
||
AQL tutorial
|
||
============
|
||
|
||
This is an introduction to ArangoDB's query language AQL, built around a small
|
||
dataset of characters from the novel and fantasy drama television series
|
||
Game of Thrones (as of season 1). It includes character traits in two languages,
|
||
some family relations, and last but not least a small set of filming locations,
|
||
which makes for an interesting mix of data to work with.
|
||
|
||
There is no need to import the data before you start. It is provided as part
|
||
of the AQL queries in this tutorial. You can interact with ArangoDB using its
|
||
[web interface](../getting-started-web-interface.html) to manage
|
||
collections and execute the queries.
|
||
|
||
Chapters
|
||
--------
|
||
|
||
- [Basic CRUD](tutorial-crud.html)
|
||
- [Matching documents](tutorial-filter.html)
|
||
- [Sorting and limiting](tutorial-sort-limit.html)
|
||
- [Joining together](tutorial-join.html)
|
||
- [Graph traversal](tutorial-traversal.html)
|
||
- [Geospatial queries](tutorial-geospatial.html)
|
||
|
||
{%- comment %}TODO: Advanced data manipulation: attributes, projections, calculations... Aggregation: Grouping techniques{% endcomment %}
|
||
|
||
Dataset
|
||
-------
|
||
|
||
### Characters
|
||
|
||
The dataset features 43 characters with their name, surname, age, alive status
|
||
and trait references. The surname and age properties are not always present.
|
||
The column *traits (resolved)* is not part of the actual data used in this
|
||
tutorial, but included for your convenience.
|
||
|
||
|
||
|
||
### Traits
|
||
|
||
There are 18 unique traits. Each trait has a random letter as document key.
|
||
The trait labels come in English and German.
|
||
|
||
|
||
|
||
### Locations
|
||
|
||
This small collection of 8 filming locations comes with two attributes, a
|
||
*name* and a *coordinate*. The coordinates are modeled as number arrays,
|
||
comprised of a latitude and a longitude value each.
|
||
|
||
|