Training course (part VI): SQL

Last May, the «Intelligence and Data» team held an online training course on the Onesait Platform, of which we told you about here on the blog (part I and part II).

Due to the interest generated by the course, we have decided to create a number of explanatory videos with the content taught during the course, so that, over the next few weeks, we will be bringing you the different videos of the course.

The course is organized with the following sections:

  1. Ontologies
  2. DataFlow
  3. FlowEngine
  4. Notebooks
  5. APIs and Tokens
  6. SQL
  7. Introduction to MongoDB
  8. Datasources
  9. Dashboards and Gadgets
  10. My Files, Web Projects, My Projects
  11. JasperReports

Important: As the course videos were recorded in Spanish, we have added subtitles both in Spanish and English for your convenience.

6.- SQL

This session deals with the use of SQL in the Onesait Platform with Quasar SQL2. It specifies the Platform’s different modules where it can be used, whether the native database to store the information is SQL or not.

It also talks about the type of operations that can be executed on the ontologies and which ones must be carried out from the ontology management module itself.

The final part of the session deals with the differences between Quasar SQL2 and other versions of SQL, such as Oracle’s. To do this, the Query Tool module is accessed and some commands and functions that are not available in Quasar are specified, along with a way to solve their absence.

✍🏻 Author(s)

Leave a Reply

Your email address will not be published. Required fields are marked *