Description of the star scheme compared to the snowflake scheme.
Explanation of Apache Spark with a comparison to Hadoop.
Explanation of database schemas by example.
Explanation of Apache Presto compared to Apache Spark.
Explanation of OLTP including its features and differences from OLAP.
Common SQL commands explained with the help of examples.
Introduction to Online Analytical Processing with an explanation of the OLAP Cube.
Explanation of YAML files and their use in Python.
The XML structure explained with examples and how to open it in Python.
Explanation of the JSON file format with examples and possible applications.