Exasol Database Developer
Zielgruppe:
Datenbank und ETL Prozess Developer:
Nach erfolgreicher Absolvierung des Kurses können Sie eine Zertifizierungsprüfung ablegen.
english:
The training course starts with a comprehensive introduction to Exasol’s in-memory analytic database. After a short section on the application use cases of Exasol, the course then covers important concepts and the database’s system architecture.
This includes the following topics:
Exasol in-depth: basic algorithmic principles of Exasol, especially massively parallel data processing, in-memory technology and compress
Exasol SQL
- Scheme concept
- Data types
- Identifier handling in Exasol SQL
- Interesting SQL statements
- Scripting basics ("Procedure scripts" in Exasol)
- Introduction to the topic "ETL"
- Transferring data via EXAloader
- The content of the course will be adapted to the requirements of the participants.
- The following topics can be covered optionally:
- Analytical functions
- Grouping sets
- MERGE statement
- Priorities
- Hierarchical queries (CONNECT BY)
- Geospatial data
- Time zones and timestamps
Prerequisites: Practical SQL experience, ideally in the scope of Business Intelligence