...
References
Studio
Keyboard Shortcuts, including those for PA SQL Console
Documentation
Datamart / Analytics Functions - example of OUTER JOIN of a DM with a DS
Comparison of Product Extensions and Data Sources / Datamart
Query Data Marts - contains example how to use the in-memory database and also reference of it’s API
Groovy API
executeSqlQuery() - with code sample of JOIN
External
Aggregate Functions for SQL queries